RYG Automation using TODAY, AND, and OR functions

System

This discussion was created from comments split from: Automate RYG For Project Tasks.

Molly Roy Yanus

Similar Goal - RYG Automation - What is wrong with my formula :

=IF(AND(TODAY() > Finish@row, OR(Status@row = "In Progress", Status@row = "Not Started"), "Red", IF(AND(TODAY() < Finish@row, OR(Status@row = "Complete", Status@row = "In Progress"), "Green", IF(AND(TODAY() = Finish@row, OR(Status@row = "In Progress", Status@row = "Not Started")), "Yellow", IF(AND(TODAY() < Finish@row, (Status@row = "Not Started", "Gray"))))))))

L_123

=IF(AND(TODAY() > Finish@row, OR(Status@row = "In Progress", Status@row = "Not Started")), "Red", IF(AND(TODAY() < Finish@row, OR(Status@row = "Complete", Status@row = "In Progress")), "Green", IF(AND(TODAY() = Finish@row, OR(Status@row = "In Progress", Status@row = "Not Started")), "Yellow", IF(AND(TODAY() < Finish@row, Status@row = "Not Started"), "Gray"

You didn't close out your first 2 and statements or the last one. Check and see if that works, if not I can troubleshoot further.