Parent Rows Not Summing % Complete of Children Rows

Michael Hutcheson

Hello,

I have a Sheet that has multiple children rows below the Parent Row (and tabbed in) and the Parent row either only shows the % Complete of the row directly below it or does not show percentage complete of any of the children rows below it.

I've checked that the children rows are tabbed in under the parent row, also the parent row rolls up all the children rows.

I cant figure out how to get the parent row to calculate the sum of % Complete since it stopped doing it after I closed it and then reopened the Sheet.

I cant think of anything I could have changed to make this happen.

Please give me some guidance.

Thanks,

Mike

Paul Newcome

Are you using the sheet dependencies?

Paul Newcome

The dependencies provide a weighted result in the parent rows. So if you have two tasks that are both at 50% but one is a day into a two day duration and the other is a day into a 100 day duration, your parent row may not reflect 50%. I also notice you have some blanks in the % Complete column. Try filling those in as well.

Paul Newcome

Are you using the sheet dependencies?

Michael Hutcheson

Here is a look at the dependencies.

Thanks for the help.

Mike

Paul Newcome

The dependencies provide a weighted result in the parent rows. So if you have two tasks that are both at 50% but one is a day into a two day duration and the other is a day into a 100 day duration, your parent row may not reflect 50%. I also notice you have some blanks in the % Complete column. Try filling those in as well.

Michael Hutcheson

Thank you, I'll try filling in the start/end dates and fill in the blanks to see if that helps.

Mike