Percentage Complete of child tasks

Hello!

I'm trying to figure out a formula to do the following:

1.) Display percentage complete of tasks marked "complete" within a child group, at the child top level

2.) Display percentage complete of child groups in the parent row.

Note that I am not using dependencies, and am using an independent "% complete" column (I can't organize my sheet like I need to when enabled).

See attachment for a mock-up example. Thanks in advance!

Find more posts tagged with

Education

Formulas

Project Management

Accepted answers

All comments

Andrée Starå

Hi Eric,

Try this.

=IFERROR(AVG(COLLECT(CHILDREN(); CHILDREN(Status@row); "Complete")); 0)

The same version but with the below changes for your and others convenience.

=IFERROR(AVG(COLLECT(CHILDREN(), CHILDREN(Status@row), "Complete")), 0)

=AVG(CHILDREN())

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

eric_moss66076

Thanks Andree-

I'm in the U.S, so I used the second version you provided, but it doesn't appear to be working. I've included a screenshot w/how it looks with the formulas in place. Any further advice?

Eric

Andrée Starå

Happy to help!

Try this.

It should be: =IFERROR(AVG(COLLECT(CHILDREN(), CHILDREN(Status@row), "Complete")), 0)

Best,

Andrée

George Allen

Andrée Starå Thank you. This really helped me!

Andrée Starå

Hi @George Allen

You're more than welcome!

Glad to hear that it helped you as well!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

goose

Hello I am trying to do the same thing but it's not working. all im getting it zero's in the percentage box.

Genevieve P.

Hi @goose

Can you share more information? Such as what formula you're using, and perhaps a screen capture of your sheet (with sensitive data blocked out).

Thanks!

Genevieve

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.