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:

Adobe Workfront plan*
Any
Adobe Workfront license*

Request to modify a filter

Plan to modify a report

Access level configurations*

Edit access to Reports, Dashboards, Calendars to modify a report

Edit access to Filters, Views, Groupings to modify a filter

NOTE

If you still don’t have access, ask your Workfront administrator if they set additional restrictions in your access level. For information on how a Workfront administrator can modify your access level, see Create or modify custom access levels.

Object permissions

Manage permissions to a report

For information on requesting additional access, see Request access to objects.

*To find out what plan, license type, or access you have, contact your Workfront administrator.

Filter items by comparing two fields

  1. Go to a list of tasks.

  2. From the Filter drop-down menu, select New Filter.

  3. 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.
  4. Click Switch to Text Mode.

  5. In the Set Filter Rules for your Report area, add the following code:

    code language-none
    actualCompletionDate=FIELD:plannedCompletionDate<br>actualCompletionDate_Mod=gt
    
  6. Click Done, then Save Filter.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43