% Complete is Incorrect
In project settings I have dependencies enabled. This auto calculates % complete; however, the. percentage is incorrect.
In my example I have 2 Parent rows, each with 5 tasks. Everything under Parent 1 is complete and everything under Parent 2 is not started. The % complete should be 50%; however it shows 43% complete.
I am able to determine the expected complete using this formula:
=IF(Status@row = "Pending", 0, IFERROR(AVG(CHILDREN()), IF([End Date]@row <= TODAY(), 1, IF([Start Date]@row >= TODAY(), 0, IF([Start Date]@row <= TODAY(), NETWORKDAYS([Start Date]@row, TODAY()), 0) / NETWORKDAYS([Start Date]@row, [End Date]@row)))))
My goal is to compare the % Expected Complete against the (actual) % Complete columns to identify where we have a variance.
Thoughts?
Best Answer
-
Ha! I was able to figure it out… It takes duration into consideration. Since the Parent 1 Tasks have a duration of 18 days and my Parent 2 Tasks have a duration of 24 days, they are weighted differently.
Answers
-
Ha! I was able to figure it out… It takes duration into consideration. Since the Parent 1 Tasks have a duration of 18 days and my Parent 2 Tasks have a duration of 24 days, they are weighted differently.
-
Hi,
I hope you're well and safe!
Excellent! Glad you got it working!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
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
Check out the Formula Handbook template!