% complete not rolling up
Friends,
I am having a hard time with the % complete.
All I want is a simple % complete - regardless of the duration. My parent / child rows are correctly intended.
I have 3 tasks -
Task 1 - 75% complete
Task 2 - 25% complete
Task 3 - 50% complete
Parent % complete should be 50%. How do I achieve this?
Thanks.
Comments
-
Hello—
As you've found, when you use the % complete rollup functionality with dependencies, you'll see a weighted percent complete based on the duration and % complete of all child tasks.
If you'd rather have % complete rollup that doesn't take duration into account, then you'll need to disable the dependencies functionality altogether and manually create a formula in the parent rows of your sheet.
From your example, it appears that you're looking for an average % complete as opposed to a weighted roll-up of total % complete. Try the following (I'd recommend making a copy of your sheet and testing this out on the copy first):
- Disable dependencies, more info on this here: https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors
- You'll want to then place a formula like this in your parent rows:
=AVG(CHILDREN())
-
Thank you.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives