Percentage Complete of child tasks

eric_moss66076 · 04/22/19

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!

Andrée Starå · 04/23/19

Hi Eric,

Try this.

1.

=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)

2.

=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 · 04/23/19

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å · 04/23/19

Happy to help!

Try this.

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

Best,

Andrée

George Allen · 10/09/20

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

Andrée Starå · 10/09/20

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 · 10/05/22

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. · 10/05/22

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

Percentage Complete of child tasks

Answers

Help Article Resources

Categories