% 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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives