I am attempting to create a Red, Yellow, Green, Blue health check based on a Status Column and Planned and Actual Dates. I continue to get an #UNPARSABLE error message on below.
I have checked, spelling, quotation marks and I can validate every logic function except the first =IF statement. Thought it was a ")" issue, but validated those also....
Can anyone spot something basic that I might be missing?
=IF(Status1 = "Complete", "Blue",IF(OR(Status1 = “Cancelled”, Status1 = “Not Applicable”),“”,IF(Status1 = “On Hold”, “Yellow”,IF(AND(Status1 = "Not Started", [Planned Start Date]1 > TODAY()), "Green",IF(AND(Status1 = "In Progress", [Planned End Date]1 > TODAY()), "Green",IF(AND(Status1 = "Not Started", ISBLANK([Actual Start Date]1), [Planned Start Date]1 <= TODAY(-7)), "Red",IF(AND(Status1 = "In Progress", ISBLANK([Actual End Date]1), [Planned End Date]1 <= TODAY(-7)), "Red",IF(AND(Status1 = "Not Started", ISBLANK([Actual Start Date]1), [Planned Start Date]1 <= TODAY()), "Yellow",IF(AND(Status1 = "In Progress", ISBLANK([Actual End Date]1), [Planned End Date]1 <= TODAY()), "Yellow", “Red”)))))))))
Appreciate the help!