Create a filter to compare two values in a view

Question

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 · Accepted Answer

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

kautuk_sahni · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded