% 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!

Find more posts tagged with

Formulas

functionality

Accepted answers

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.

All comments

Mike Wilday

Try adding this formula to your parent row:

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

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.