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 wan...
Forum Discussion
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
------------------------------