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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!