Formula Help

Lee Wood

Good morning Community,

Please could somebody help me figure this out. When the schedule date = today, the status is turning red, whereas it should be yellow. Any date past today should be red only. I hope that makes sense!

=IF([Scheduled Date]3 = "", "", IF([Date Completed]3 <> "", "Green", IF([Scheduled Date]3 <= TODAY(), "Red", IF([Scheduled Date]3 <= TODAY(10), "Yellow", IF([Scheduled Date]3 >= TODAY(10), "Blue")))))

Thank you.

Nick Korna

Hi @Lee Wood ,

Change:

IF([Scheduled Date]3 <= TODAY(), "Red"

To:

IF([Scheduled Date]3 < TODAY(), "Red"

At the moment it is also including equal to, whereas you don't want it to.