Skip to main content
Level 3
Jul 10, 2025 8:51 PM UTC
Solved

Create a filter to compare two values in a view

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

JustinRenteria2
JustinRenteria2Accepted solution
Level 6
Jul 10, 2025 10:18 PM UTC

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
Jul 10, 2025 10:18 PM UTC

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

projectedCompletionDate_Mod=gt

Translate
kautuk_sahni
Level 9
Jul 16, 2025 11:43 AM UTC

@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!

Translate
Kautuk Sahni