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
-
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.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives