Harvey Ball Formula based on multiple criteria

CharSM13User

Hi,

I'm looking for a formula to populate the Harvey Ball color based on the Status of the project

For example:

In Progress = Green

In Progress and Delayed = Yellow

Not Started = Red

Complete = Blue

Cancelled = Blue

On Hold = Yellow

My formula is

=IF(Status@row = "In Progress", "Green", IF(Status@row = "In Progress and Delayed", "Yellow", IF(Status@row = "Complete", "Blue", IF(Status@row = "Not Started", "Red", IF(Status@row = "On Hold", "Yellow", IF(Status@row = "Cancelled", "Blue" )))))

but the colors won't change on Cancelled and In Progress & Delayed, and I believe I need to put a "AND" in the formula, but I don't know where.

Sincerely,

Novice :)

Paul Newcome

Your formula has the correct syntax which leads me to believe there may be an issue with the data itself.

Double check that "Cancelled" really is "Cancelled" with two Ls and not "Canceled" with one. Also double check whether you are using "&" or "and".

If that doesn't work, how is the status updated and what type of column is it?

CharSM13User

Thanks Paul! I got it fixed! :)

Paul Newcome

Glad you were able to get it sorted. 👍️