Create a filter to compare two values in a view | Community
Skip to main content
B
BillPe
Level 3
July 10, 2025
Solved

Create a filter to compare two values in a view

  • July 10, 2025
  • 2 replies
  • 293 views

In my task view, I want to create a filter to compare two field values to determine which task lines to display

I want to compare the Task: projected Completion date and the Project: Planned Completion date.

I want to display any task that has a task: projected completion date greater than the Project: Planned Completion date.

I know I need to do this in Text mode.

Can you tell me the text I need to create

Best answer by JustinRenteria2

This will give you what you need on a task report:
projectedCompletionDate=FIELD:project:plannedCompletionDate

projectedCompletionDate_Mod=gt

2 replies

JustinRenteria2
JustinRenteria2Accepted solution
Level 6
July 10, 2025

This will give you what you need on a task report:
projectedCompletionDate=FIELD:project:plannedCompletionDate

projectedCompletionDate_Mod=gt

    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    July 16, 2025

    @billpe Just checking in — were you able to resolve your issue?
    We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

    Kautuk Sahni
    Terms & ConditionsAccessibility statement

    Loading footer...