Health column formula to automatically change based on due date

Options

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


Answers

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Options

    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

    Thanks

    Paul

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!