DocumentationWorkfrontWorkfront Guide

Filter: eliminate items in a list by comparing two fields

Last update: Fri Oct 17 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

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.
table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header
Adobe Workfront package Any
Adobe Workfront license

Contributor or Request to modify a filter

Standard or 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 permissions Manage permissions to a report

For more detail about the information in this table, 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.

    note tip
    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:

    code language-none 
    actualCompletionDate=FIELD:plannedCompletionDate
actualCompletionDate_Mod=gt

  6. Click Apply > Save as new.

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