Health column formula to automatically change based on due date

Keelie Hoskin

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

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