% complete using checkboxes
Is there a formula or function that will count up the # of children checked off and report the total % checked in the parent row?
As an example, I have two out of six activities (children) checked off, which means the parent work package is 33.33% complete. I would like the parent checkbox to report the 33.33% and update automatically as more activities are checked off.
Or, if there a better/another way to capture progress as activities (children) are completed and reported in the parent row, that would be useful! Thank you!
Best Answer

Try adding this formula to your parent row:
=ROUND(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()), 2) * 100 + "%"
I added the "%" because it will convert your answer to a text format which will display in the checkbox column (as long as the column settings are not restricted). Otherwise a number can't be displayed.
This basically did the math and rounded it to two decimal points.
Answers

Try adding this formula to your parent row:
=ROUND(COUNTIF(CHILDREN(), 1) / COUNT(CHILDREN()), 2) * 100 + "%"
I added the "%" because it will convert your answer to a text format which will display in the checkbox column (as long as the column settings are not restricted). Otherwise a number can't be displayed.
This basically did the math and rounded it to two decimal points.

Thanks @Mike Wilday ! Worked perfectly!

Awesome! Glad I could help you out.
Help Article Resources
Categories
Check out the Formula Handbook template!