Roll Up Harvey Balls

cmcneillyjci ✭✭✭
edited 12/09/19 in Formulas and Functions

I am currently working on a tracking page where I've been asked to create a "Progress" column using Harvey Balls.  The goal is to use empty, half and full to represent not started, in progress and complete by training module (children) and then overall.  Below is one of the many formulas I've been working on.


=IF(AND(COUNTIF(CHILDREN(), "Half") = 0, COUNTIF(CHILDREN(), "Empty") = 0), "Full", "Empty")

(AND(COUNTIF(CHILDREN(), "Half") = 1, COUNTIF(CHILDREN(), "Full"= 0", "Half", "Empty")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!