Conditional Formatting based on Dates

Joe Goetschel
Joe Goetschel ✭✭✭✭✭✭

Is there a way to have the system highlight using Conditional Formatting when it's past a number of days?

Yellow when it's 30 days after "booked date"

Orange when it is 45 days after "booked date"

Red when it is 60 days and older after "booked date"

Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner

joe.goetschel@scscloud.com

Save My Contact

"The only real limitation of Smartsheet is the level of effort required to achieve your goal."

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try this...

    =IF(TODAY() > [Booked Date]@row + 60, "Red", IF(TODAY() > [Booked Date]@row + 45, "Orange", IF(TODAY() > [Booked Date]@row + 30, "Yellow")))


    Then you can set up your conditional formatting to highlight your column(s) based on the text value in this column.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers