Use conditional formatting in views

As you share your reports with other users in Adobe Workfront, consider customizing the view of the reports, to make certain information easier to read, or just stand out.

You can customize the Details tab of your reports by adding special or conditional formatting to the view of your reports.

You must have Manage permissions to the report, to be able to edit it and add special formatting to the view.

For more information about creating reports, see the article Create a custom report.

By conditionally formatting columns in the view of the report, you can set up rules that affect the way the report is displayed. When those conditions or rules are met, the special formatting is applied.

For example, if the percent complete of a task is less than 20 percent, you can highlight the field by showing the percentage number in bold, red text, and a yellow background color.

With a conditionally formatted view, you can:

• Change the header of a column.
• Change the value of a column to customized text or an image.
• Format the display of a field by changing the font type, color, alignment, or the color of the background.

The changes you make in the view of the report take effect only in the Details tab of the report. These changes do not affect the Summary, Matrix, or Chart tabs of the report.

Access requirements

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

*To find out what plan, license type, or access you have, contact your Workfront administrator.

Prerequisites

You must create a report before you can add conditional formatting to it.

For information on creating a report, see Create a report.

Create a conditionally formatted view

1. Click the Main Menu icon in the upper-right corner of Workfront,then click Reports.

2. Click the name of a report where you want to create a conditionally-formatted view.

   Or

   Click Report Actions, then click Edit.

3. (Conditional) If you edited a report, select an existing column, or create a new column.

4. Click Advanced Options.

5. Specify the following information:

   Custom Column Label	Specify a name for the column. If you are editing an existing column, specifying a name here changes the existing column name.
   Field Format	Choose the format in which the value in the column displays. Depending on what the column field is, this allows you to set how dates, numbers, or currency display.
   Show this column when on a Dashboard	Select this field if you want the column to display when the report is placed on a dashboard. The column always displays when you look at the report outside a dashboard.

6. Click Add a Rule for this Column.

7. In the When the: section, set a condition statement for the column. For example: when the Task Percent Complete Equals (Case Sensitive) 50.

8. In the Show the field like this: section specify what this field looks like when the condition defined above is met.

   Specify the following information:

   Text Color	Select the color in which the text is displayed. There are 8 colors available. Note: If the field contains a hyperlink, the text color selections are not applied to this field.
   Text Format	Select whether to display text in bold or italic.
   Text Alignment	Select whether to align the text to the right, center, or the left within the column.
   Background	Select the color of the background for the text. There are 8 colors available.
   Show Icon	Select from one of 16 icons, if you want to display an icon instead of the actual value for this column.
   Show Text	Select this option to display a custom label for this column, instead of its actual value. Specify the text to show instead of the value in the field provided. Important: Selecting Show Text disables the ability to inline edit the text in this column. Also, you can't change the value of a Predecessor column because it contains built-in logic.
   Apply to the entire row	Select this option to apply settings to the entire row rather than applying settings to just the selected column.

9. Click Add Rule.
   You can add additional rules to the same column, or add rules to other columns.

   Rules are applied in the order that they were created. They are combined but do not overwrite each other, though a column rule takes precedence over a row rule on the same cell.

   Example 1: You can first create a rule that states when the Project Status is Building, the text color is purple and bold. You then create a second rule that states when the Task Name is not blank, the text color is red and italicized, and the background color is green. In this example, the following occurs:

   • Tasks whose Project Status is Building are displayed in purple and bold text. If the task name is not blank, tasks also have a green background.
   • Tasks whose Project Status is anything other than Building (and the Task Name is not blank) are displayed in a red and italicized text with a green background.

   Example 2: Create a rule on the Project Planned Completion Date that affects the entire row, turning the background gray if the project is canceled (Status = “Dead”). Then create a column rule that turns the background red when the Project Planned Completion Date is less than today (meaning the project is late). In this example, if a canceled project has a late completion date, that cell will appear red even though the other cells in the row are gray. To correct this formatting:

   • Edit the formatting for the Planned Completion Date and delete the column rule for the red background on late projects.
   • Add a column rule with the same formatting as the row rule (gray background when the Project Status = “Dead.”)
   • Add the column rule again for the red background on late projects.
   • When you save the rules and the view, the red background is not applied to a canceled project.

10. Click Done.

11. Click Save + Close.
    On the report, users see changes to the format if the specified conditions have been met.

Business.Adobe.com resources