2

Hello All, 

I am trying to automate the blue ball based on complete and the red, yellow and green based on date. I have come up with the following formula but I am getting an UNPARSE any help would be great.

=If(Status1 =Complete, "Blue", IF(OR(ISBLANK([End Date]1), [End Date]1 >= Today(-5)), "Red", IF([End Date]1>=Today(-7), "Yellow", IF([End Date]1 <=Today(-10), "Green"))))

 

Functionality

Comments

=If(Status1 ="Complete", "Blue", IF(OR(ISBLANK([End Date]1), [End Date]1 >= Today(-5)), "Red", IF([End Date]1>=Today(-7), "Yellow", IF([End Date]1 <=Today(-10), "Green"

 

You were missing quotes around "Complete".