% complete using checkboxes

MrDramaFree

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!

Mike Wilday

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.

Mike Wilday

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.

MrDramaFree

Thanks @Mike Wilday ! Worked perfectly!

Mike Wilday

Awesome! Glad I could help you out.