Automating Harvey Balls from the Status column?

04/08/21
Accepted

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

Answers

Sign In or Register to comment.