Discussions

Expand all | Collapse all

Color Cell Formula is not working, any help please?

  • 1.  Color Cell Formula is not working, any help please?

    Posted 08-16-2018 17:32
    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!




  • 2.  RE: Color Cell Formula is not working, any help please?

    Top
    Contributor
    Posted 08-16-2018 18:21
    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. 


  • 3.  RE: Color Cell Formula is not working, any help please?

    Posted 08-16-2018 19:11
    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")