Indented Functions not working properly

I have a sheet that I built off a template. I have a column that is % complete. normally when you indent it auto averages the % complete of all the children, but not this time. Any ideas?

It is also not a formula issue as when you click on the parent % you get this message.


Best Answer

  • Julio S.
    Julio S. Moderator
    Answer ✓

    Hi @J.Barrow,

    The parent rollup functionality that you are using to calculate the % Complete average takes into account each task duration so that a weighted average can be calculated. In doing some testing, it seems like only filling in the duration (without start or end dates) should do the trick (see below) but, if filling in just the duration isn't an option either, maybe you can create a helper Column with the following formula on parent rows =AVG(CHILDREN()) to manually calculate these values without taking into account task duration.

    I hope that this can be of help.

    Cheers!

    Julio

Answers

  • Learned that the issue is that if the date range and is left blank and the duration is blank it skips the calculation.

    Anyone know a work around for this as sometimes projects time lines are built as the project is progressing and I want an accurate % complete without those details.

  • Julio S.
    Julio S. Moderator
    Answer ✓

    Hi @J.Barrow,

    The parent rollup functionality that you are using to calculate the % Complete average takes into account each task duration so that a weighted average can be calculated. In doing some testing, it seems like only filling in the duration (without start or end dates) should do the trick (see below) but, if filling in just the duration isn't an option either, maybe you can create a helper Column with the following formula on parent rows =AVG(CHILDREN()) to manually calculate these values without taking into account task duration.

    I hope that this can be of help.

    Cheers!

    Julio