Can someone tell me whats wrong with this equation?

Kenny13

I'm looking to get Yellow when the due date is between 5-0 days, Red after one day late and otherwise green.

=IF(AND(([Target End Date]@row) = TODAY(), ([Target End Date]@row - 5) >= TODAY()), "Yellow", IF(TODAY() > ([Target End Date]@row + 1), "Red", IF(TODAY() > ([Target End Date]@row - 6), "Green")))

Nick Korna

Hi @Kenny13,

If I've understood properly this is the outcome you're looking for:

With the formula being:

=IF(TODAY() > [Target End Date]@row, "Red", IF(TODAY(5) >= [Target End Date]@row, "Yellow", "Green"))

If I've misunderstood something or you've questions etc. then just post! 😊