Compare fields in conditional formatting

Last update: Thu Jan 16 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Rubriques :

Créé pour :

Utilisateur ou utilisatrice

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

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

You must have the following:

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: Standard Current: Plan
Access level configurations	Edit access to Filters, Views, Groupings Edit access to Reports, Dashboards, Calendars to edit the view in a report
Object permissions	Manage permissions to a report to edit the view in a report Manage permissions to a view

For information, see Access requirements in Workfront documentation.

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:

Go to a task view or a report.
(Conditional) If you are working with a report, from the Columns (View) tab in the report editor, 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.
Click Advanced Options, then click Add a Rule for this Column.
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.
(Optional) Select Apply to entire row if you want to apply the formatting to the entire row.
Click Save.
Select the Actual Start Date column, then click Switch to Text Mode.

Click Edit Text Mode, then add the following line of text:

code language-none
`styledef.case.0.comparison.rightmethod= <field to compare>`

In our example:

code language-none
`styledef.case.0.comparison.rightmethod=plannedStartDate`

note 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:
`styledef.case.0.comparison.rightmethod=DE:Delivery Date`

Ensure that the righttext line of code matches the statement in the rightmethod line of code.
Click Save.
Click Save + Close.

The column highlights the fields that meet your criteria.

recommendation-more-help

5f00cc6b-2202-40d6-bcd0-3ee0c2316b43