Forum Discussion

KarenHenke's avatar
KarenHenke
Qrew Cadet
5 years ago

Help with formula: color rows based on duration field

I'm stumped and could use some help writing a formula please. Goal: To color rows in a report based on the number of days a record has been in "On Hold" status. I have a date field [Date placed ...
Formulas and functions
reports and charts
KarenHenke's avatar
KarenHenke
Qrew Cadet
5 years ago
Thank you Mark!
I'm getting this error:


------------------------------
Karen Henke
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
OK, I did not realize that this was a Duration field type.
try this

var number DaysOnHold = ToDays([# Days on hold]);

IF(
$DaysOnHold >=14 and $DaysOnHold <= 29, "yellow",
$DaysOnHold>=30 and $DaysOnHold <= 59, "orange",
$DaysOnHold >=60, "pink")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • KarenHenke's avatar
    KarenHenke
    Qrew Cadet
    5 years ago
    That worked perfectly! Thanks again!

    ------------------------------
    Karen Henke
    ------------------------------