Why do I get a #Incorrect argument set error with the formula below/

Carole M.

=IF(Status@row = "Not Started", "Blue", IF(OR(AND(TODAY()>[End Date]@row, Status@row = "Not Started"), AND(TODAY()>[End Date]@row, Status@row = "In Progress")), "Red", IF(OR(AND(TODAY(-5)>[End Date]@row, Status@row = "Not Started"), AND(TODAY(-5)>[End Date]@row, Status@row = "In Progress")), "Yellow", IF(Status@row = "Complete", "Green")))))

Carson Penticuff

14 opening parentheses, 15 closing parentheses.

Carson Penticuff

It's an easy mistake to make. Glad I could help.

Carson Penticuff

14 opening parentheses, 15 closing parentheses.

Carole M.

Got it, thanks!

Carson Penticuff

It's an easy mistake to make. Glad I could help.