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:
| table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header | |
|---|---|
| Adobe Workfront plan | Any |
| Adobe Workfront license* |
New:
Current:
|
| 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 information, see Access requirements in Workfront documentation.
Filter items by comparing two fields
-
Go to a list of tasks.
-
From the Filter drop-down menu, select New filter.
-
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. -
Click Text mode.
-
In the area displayed, add the following code:
actualCompletionDate=FIELD:plannedCompletionDate<br>actualCompletionDate_Mod=gt -
Click Apply > Save as new.