Automate RYGGrey

jlr67

I need help with a formula to automate my RYGGrey. Here are the rules:

If status = complete, grey

If status is in progress or not started and finish is in the past, red

If status is in progress or not started and finish is today + 5 days (within the next 5 days), yellow

If status is in progress or not started and finish is greater than 5 days out, green

Paul Newcome

Give this a go...

 

=IF(Status@row = "Complete", "Gray", IF(Finish@row < TODAY(), "Red", IF(Finish@row < TODAY(5), "Yellow", "Green")))