Help with formula: color rows based on duration field

Question

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 on hold] that I've used to calculate the duration [# days on hold] (a Formula-Duration field).

I'd like the formula to say
if [# Days on hold] is 14-29 color the row yellow
if [# Days on hold] is 30-59 color the row orange
if [# Days on hold] is greater than 59 color the row pink

Can someone help me write this formula? I'd be ever so grateful.

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

MarkShnierYou · Answer

try thisIF([# Days on hold] >=14 and [# Days on hold] <= 29, "yellow",[# Days on hold] >=30 and [# Days on hold] <= 59, "orange",[# Days on hold] >=60, "pink")I think that all those color names should work, but you can also use those hex codes. Another QSP, Laura, from IDS, did this nice app here https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000728 ------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community