In a Task Report how can I display a red background row IF the Task Due Date ends before the Project Due Date? | Community
Skip to main content
JoeSalas
Level 3
February 28, 2020
Question

In a Task Report how can I display a red background row IF the Task Due Date ends before the Project Due Date?

  • February 28, 2020
  • 1 reply
  • 411 views

Hello Workfront Community!

I have made many attempts in Columns (View) | Text Mode | to create a report but had no success.

The Task Report criteria is:

IF the Task Due Date ends before the Project Due Date, turn the background red.

Thank you for reading!

Kind regards,

- Joe

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Doug_Den_Hoed_AtAppStore
Community Advisor
Community Advisor
February 28, 2020

Hi Joe,

One way to compare fields in conditional formatting is shown here, which you could use show plannedCompletionDate less than project.plannedCompletionDate in red.

Regards,

Doug