Percentage of Child Rows with Check Mark
Options
Comments
-
It doesn't work because it is text.
=100*(COUNTIFS(CHILDREN(),1) / COUNT(CHILDREN())) + "%"
Craig
-
That's amazing. Thanks so much.
-
You are welcome.
-
Thank you, J. Craig!!!
-
How do I round this percentage to the nearest whole number? Or at the most 2 decimal places?
=100 * (COUNTIFS(CHILDREN(), 1) / COUNT(CHILDREN())) + "%"
-
You would wrap the portion of the formula that generates the actual number in your ROUND function.
=ROUND(100 * (COUNTIFS(CHILDREN(), 1) / COUNT(CHILDREN()))) + "%"
The above will give you the nearest whole number.
The below would be two decimal places.
=ROUND(100 * (COUNTIFS(CHILDREN(), 1) / COUNT(CHILDREN())), 2) + "%"
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!