Filter: eliminate items in a list by comparing two fields
You can filter items out of a list by comparing two of their fields. For example, you can display only tasks where the Actual Completion Date of the task is greater than the Planned Completion Date.
Access requirements
You must have the following access to perform the steps in this article:
*To find out what plan, license type, or access you have, contact your Workfront administrator.
Filter items by comparing two fields
-
Go to a list of tasks.
-
From the Filter drop-down menu, select New Filter.
-
Click Add Filter Rule and add Actual Completion Date >Greater Than > Select a date.
note tip TIP Choose the filter modifier you want to use for the selected field, if available. -
Click Switch to Text Mode.
-
In the Set Filter Rules for your Report area, add the following code:
code language-none actualCompletionDate=FIELD:plannedCompletionDate<br>actualCompletionDate_Mod=gt
-
Click Done, then Save Filter.
recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43