Percentage

ejacksonBPT

What is the formula for % complete.

I want to calculate the % complete for Task A.1 and A.2 and put it in the highlighted cell for Task A. Same with Task B and then the top cell "Percent complete" I want % complete for all of it.

kowal

Hi Jackson,

I would use the formula to sum children and dived by amount of children

so it would be sth like: =sum(children())/count(children())

ejacksonBPT

Thank you. how would I write that if I have three tiers

Parent
Child
Grandchild