% 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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!