How to automate Harvey Balls based on % Complete Summary Field

Robert Y

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

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