# 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.

Tags:

• ✭✭✭✭✭✭

The protion that outputs the number would be wrapped in the ROUND function like so:

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

• ✭✭✭✭✭✭

You can wrap the portion that outputs the number in a ROUND function and specify how many decimals to show before the "%" is appended.

• thanks for the response @Paul Newcome would you mind helping me out with the full formula for this? i would prefer to round to the nearest whole number, eliminating all decimals if there is no way to count them and display the percent in the same cell.

• ✭✭✭✭✭✭

The protion that outputs the number would be wrapped in the ROUND function like so:

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

• That will work for what I am doing. Thank you so much for your help! @Paul Newcome

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!