Automating Harvey Balls from the Status column?

Sabrina Petersen

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?

Heather Duff

@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

Heather Duff

@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

Sabrina Petersen

Thank you Heather. That worked perfectly.

Heather Duff

Fantastic! Glad it worked for you.