Filter: eliminate items in a list by comparing two fields

Last update: February 25, 2025

CREATED FOR:

  • User

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

Expand to view access requirements for the functionality in this article.

You must have the following access to perform the steps in this article:

Adobe Workfront planAny
Adobe Workfront license*

New:

  • Contributor to modify a filter

  • Standard to modify a report

Current:

  • 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

Object permissionsManage permissions to a report

*For information, see Access requirements in Workfront documentation.

Filter items by comparing two fields

  1. Go to a list of tasks.

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

  3. Add a filter for Task:Actual Completion Date > Greater Than > Select a date.

    TIP
    Choose the filter modifier you want to use for the selected field, if available.

  4. Click Text mode.

  5. In the area displayed, add the following code:

    actualCompletionDate=FIELD:plannedCompletionDate
actualCompletionDate_Mod=gt

  6. Click Apply > Save as new.

More help on this topic

Previous pageFilter: display only items in an approval status
Next pageFilter: display parent tasks

Workfront

Register to learn something new

WORKFRONT

Join Adobe product experts in live events where you will learn Adobe Workfront best practices, tips and tricks, and hear about the latest product features and updates.