Quantity AND % Complete for children rows

I'm trying to make the parent row say the qty of children AND the % in the "Complete" column that will auto adjust once checkboxes are clicked. Note, each parent row will have different quantities of children.

Right now I am using the below formula and I don't like that it gives so many decimals:

=COUNTIF(CHILDREN(), true) / COUNT(CHILDREN()) * 100 + "%"

example: "(0/7) 0%"

Any advise is much appreciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!