All articles

Color-Coding Results in Formula Custom Fields

Table 16. Availability






When you create custom fields with formulas that automatically calculate data from other custom and system fields in your account, you can color-code the calculation results. 

Color-coding allows you to add green, amber, and red markers to the result of the calculation. The markers appear on Table view in the calculated field’s column next to the result. This way, you can quickly view which of your projects require immediate attention.

How to color-code formula results

Formula example: [Expences]/[Estimated Budget]="Percentage"

Let’s say we need to see which of our projects are outside of the budget limit and by what percentage. We divide the actual [Expenses] by [Estimated Budget] and change the resulting type of data from Number to Percentage, as described in Step D of adding a formula.

To color-code the calculation results:

  1. While creating or editing the formula custom field, check the box next to Show conditional marker.


    The checkbox will be labeled Add conditional coloring if the result of the calculation is set as Percentage and the Show progress bar box is checked.

  2. In the opened window, click + Add another rule.

  3. Select a condition from the drop-down list.

  4. Select a color for the marker that will be shown if the condition you set in the previous step is true.

  5. Repeat Steps 2 to 4 to set up as many markers as you need.

  6. Click Create if you’re creating the calculated custom field or Save if you’re editing it.

After you complete the steps, the colored markers will immediately appear next to each calculation result in the column of the formula custom field.

Color-Coding Results in Formula Custom Fields