Health column formula to automatically change based on due date


Hi all,

Looking to get some help / formulas to help me with my sheet.

I would like my health column to change colours automatically based on:

Green = Status column marked completed

Yellow = due date two days away from today

Red = Due date in the past


  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭

    HI @Keelie Hoskin

    This should do the trick.

    =IF([Completed (TICK)]@row = true, "Green", IF([Due date]@row < TODAY(), "Red", IF([Due date]@row <= TODAY() + 2, "Yellow", "")))

    Meets all criteria, anything falling outside will not display anything.

    Hope it helps



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!