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
-
@Sabrina Petersen, try this:
=if(Status@row="Not Started","Blue",if(OR(Status@row="In Progress",Status@row="Complete"),"Green",if(Status@row="At Risk","Yellow",if(Status@row="Postponed","Red",""))))
Let me know if it works for you!
Best,
Heather
Answers
-
@Sabrina Petersen, try this:
=if(Status@row="Not Started","Blue",if(OR(Status@row="In Progress",Status@row="Complete"),"Green",if(Status@row="At Risk","Yellow",if(Status@row="Postponed","Red",""))))
Let me know if it works for you!
Best,
Heather
-
Thank you Heather. That worked perfectly.
-
Fantastic! Glad it worked for you.
Help Article Resources
Categories
Check out the Formula Handbook template!