Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How to automate Harvey Balls based on % Complete Summary Field
Options
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
Tags:
Comments
-
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
-
Thanks Atus this worked like a charm.
Robert
This discussion has been closed.