Forum Discussion
MarkShnier__You
Qrew Legend
5 years agotry this
IF(
[# 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
IF(
[# 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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
KarenHenke
5 years agoQrew Cadet
Thank you Mark!
I'm getting this error:
------------------------------
Karen Henke
------------------------------
I'm getting this error:
------------------------------
Karen Henke
------------------------------
- MarkShnier__You5 years ago
Qrew Legend
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
------------------------------- KarenHenke5 years agoQrew CadetThat worked perfectly! Thanks again!
------------------------------
Karen Henke
------------------------------