Forum Discussion

Gelo's avatar
Gelo
Qrew Trainee
3 years ago

Color-coding specific time sensitive records

Hello Everyone,

I have a table report that the sales team uses to work through deals. I know we can create a formula for color-coding the records, just not sure what the formula would be.

We want to color-code records like so: If the today's date is 1 week before [Closing Date] highlight red. If today's date is a month before [Closing Date], highlight yellow, etc. Once that date has passed, highlight another color. 

I really appreciate any help, thank you!

------------------------------
AG
------------------------------
  • JeffPeterson1's avatar
    JeffPeterson1
    Qrew Captain
    3 years ago

    Try this in the formula for color-coding:

    If(
    Today() > [Closing Date], "purple",
    Today() >= [Closing Date] - Days(7), "red",
    Today() >= [Closing Date] - Days(30), "yellow"
    )



    ------------------------------
    Jeff Peterson
    ------------------------------