IF AND Statement for Color Statuses
I am trying to do something that I thought was fairly simple, but I keep running into an issue and receive an "#Unparceable" with my current formula.
I am trying to build a Task Status based on Red, Yellow, Blue, and Green Circles. My challenge is getting the proper formula/syntax for my Yellow Status.
=IF([Status]1 = ???, "Yellow", IF([Status]1 = "Complete", "Green", IF([Satus]1 = "In Progress", "Blue", IF([At Risk]1 = 1, "Red"))))
Status is simply the drop down column that comes in the project (Not Started, In Progress, and Complete).
At Risk is simply a check box column.
For the Yellow I would like for it to be IF Status = "Not Started" and the "Start Date" is > Today THEN Show Yellow.