Need a formula for % complete for all phases on the parent project summary row. Row is non editable

Nikki G

I need an average formula in the parent project summary (row 23). Formula should include all phases (initiating, planning, executing, closing). The parent row is un-editable and not allowing me to enter a formula.

Matt Johnson

Hi @Nikki G

If you indent all phases so that «SCC Project Name» is the top level parent to all, then everything will roll up to that row. You might need to adust the conditional formatting to keep the look of this sheet with the Dark Blue but that should do what you want. It will also rollup you Start and Finish dates for the whole project too.

I hope that helps.

Matt

Matt Johnson

Hi @Nikki G

If you indent all phases so that «SCC Project Name» is the top level parent to all, then everything will roll up to that row. You might need to adust the conditional formatting to keep the look of this sheet with the Dark Blue but that should do what you want. It will also rollup you Start and Finish dates for the whole project too.

I hope that helps.

Matt

SSFeatures

Hi @Nikki G,

For the Initiating, Planning, Executing, and Closing rows, you can use this formula to calculate the average of all of their children rows.

=AVG(CHILDREN())

For the «SCC Project Name» row, you cannot use the CHILDREN function since Initiating, Planning, Executing, and Closing are not children of the «SCC Project Name» row. So you must use a function like this:

=AVG([% Complete]28, [% Complete]35, [% Complete]42, [% Complete]47)

The numbers 28, 35, 42, and 47 represent the row numbers for Initiating, Planning, Executing, and Closing.

I hope this helps!

Nikki G

That worked! Thanks so much!

Nikki G

I'm having issues again :(

My project row «SCC Project Name» is the parent row (hierarchy level 1). The phases under it are indented as child rows (hierarchy level 2).

The % complete and Status are not computing. It also will not allow me to enter a formula. They are not locked columns.

Please help!