Color Cell Formula is not working, any help please?

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
Hello,

I'm trying to create a Rich Text Formula fields called "Cell Color for Days Past ISD"  that will color the cell "Days Past ISD" which is is a formula - duration field. If the days are under 120, they should remain white. If the days are between 121 and 180, it should be orange. If it is over 180 days, the cell should be red. This is the formula I have written for it:

If(
[Days Past ISD] > Days(0) and [Days Past ISD] <= Days(120), "0-120",
[Days Past ISD] > Days(120) and [Days Past ISD] <= Days(180), "<div style='font-weight: bold; background-color:#ED9121; '>" & "121-180" & "</div>",
[Days Past ISD] > Days(180), "<div style='font-weight: bold; background-color:#EE3B3B; '>" & ">180" & "</div>", null
)

However, it won't do anything to the field "Days Past ISD", it will only change the color cell of "Cell Color for Days Past ISD".

Any help?

Thank you!


Photo of Iris Bonilla

Iris Bonilla

  • 320 Points 250 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,744 Points 5k badge 2x thumb
Hi Iris,

A formula field set up for colorization will only color that specific field that contains the colorization formula. It will not colorize another field outside of the field that contains the formula. You can set up colorization on a report for an entire row but there is not an option to colorize another field separate from the field that contains the colorization formula. I hope this information is helpful Iris and thank you for your time today. 
Hi Iris, Evan is spot on.

I have a video on how to do the report colorization here if you need it: https://www.quickbasejunkie.com/blog/how-to-color-code-rows


You could reference the Cell Color for Days Past ISD field you've already created, like such:

Case([Cell Color for Days Past ISD],"121-180","#ED9121",">180","#EE3B3B")