Forum Discussion

Rez's avatar
Rez
Qrew Member
2 months ago

How to color code a table based on a forumla field?

I have a report I created where Days Remaining is a formula: -(ToDays(Today() - ToDate([Due Date]))) I want to color code the table such that  Days Remaining = 5  -> Red Days Remaining = 5-10 -> ...
formulas
QuickBaseJunkie's avatar
QuickBaseJunkie
Icon for Qrew Legend rankQrew Legend
31 days ago

This should do it

var number DR = -(ToDays(Today() - ToDate([Due Date])));

If(
$DR = 5,"Red",
$DR > 5 and $DR <= 10,"Yellow",
$DR > 10,"Green",
$DR < 0,"Purple")

You can also replace the names like "Yellow" with a hex code like "#FDFD96" if you find the named color is not the best shade. Just be sure to include the pound sign.

-Sharon