Automating Harvey Balls from the Status column?
I would like to automate my Harvey Balls (in a Health column) from the Status column using the following criteria:
Not Started = "Blue"
In Progress = "Green"
Complete = "Green"
At Risk = "Yellow"
Postponed = "Red"
But when I try to nest the formula I get an error message. What am I doing wrong?