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?

Best Answer


Sign In or Register to comment.