Compare fields in conditional formatting

You can use conditional formatting to compare 2 different fields in a view and highlight them when certain criteria are met between the fields.

Access requirements

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

Adobe Workfront plan*
Adobe Workfront license*
Access level configurations*

Edit access to Filters, Views, Groupings

Edit access to Reports, Dashboards, Calendars to edit the view in a report

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 to edit the view in a report

Manage permissions to a view

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.

Example: Compare Actual Start Date and Planned Start Date

For example, if the Actual Start Date of a task is after the Planned Start Date you can highlight the Planned Start Date column using conditional formatting.

To compare the Planned Start Date and Actual Start Date of task using conditional formatting:

  1. Go to a task view or a report.

  2. (Conditional) If you are working with a report, from the Columns (View) tab, click the header of the column you want to conditionally format to select it.
    For example, select the Actual Start Date column if you want to add the conditional formatting to it by comparing the Planned Start Date and the Actual Start Date fields.

  3. Click Advanced Options, then click Add a Rule for this Column.

  4. Enter the comparison criteria using existing values found in the builder and specify your conditional formatting.
    For example, we want to highlight tasks where the Actual Start Date is later than ( or greater than) the Planned Start Date. Select the Greater Than modifier, and select an actual date in the date field.

  5. (Optional) Select Apply to entire row if you want to apply the formatting to the entire row.

  6. Click Add Rule, then Done.

  7. Select the Actual Start Date column, then click Switch to Text Mode.

  8. Click to edit text mode then add the following line of text:

    code language-none <field to compare>

    In our example:

    code language-none
    note note
    If you are comparing a Workfront native field, use camel case syntax for the name of the field. If you are comparing a custom field, use DE:Actual Name of the Field for the name field you are comparing with the first field.
    For example, if you are comparing the Actual Start Date with a custom field labeled Delivery Date, add the following statement in your text mode code: Date
  9. Ensure that the righttext line of code matches the statement in the rightmethod line of code.

  10. Click Save.

  11. Click Save + Close.

    The column highlights the fields that meet your criteria.