How to automate Harvey Balls based on % Complete Summary Field

Hi everyone, I'm looking to find a way to automate the Harvey Balls symbols based on a % complete Summary field where the percente complete is 25% 50%, 75% or 100%. Any help is greatly appreciated.

Thanks,

Robert

Find more posts tagged with

Human Resources

Sheets

Healthcare

Comments

Atus Bartal

Robert,

This works in a Harvey Balls symbol column (row 1):

=IF([% Complete]1 < 0.25, "Empty", IF([% Complete]1 < 0.5, "Quarter", IF([% Complete]1 < 0.75, "Half", IF([% Complete]1 < 1, "Three Quarter", "Full"))))

I hope this is what you're looking for.

Atus

Robert Y

Thanks Atus this worked like a charm.

Robert