% Complete Manually Formula
Smartsheet Community:
I need to Manually calculate the % Complete for the Parent Task because I want to use a formula for the children. Does anyone have the formula that the Automatic Project Settings use for % Complete?
Thanks
Answers

Hi Ray
I have had a quick look and play with this and if your manual % complete column is formatted as a % (i.e. you've used the % button to format the column) then putting this formula in the parent row should summarise it appropriately
=SUM(CHILDREN()) / COUNT(CHILDREN())
I hope this helps
Kind regards
Debbie

That helps, but I need a weighted average. I used the Following % to compare to the automated % calculation set in the Project Settings of Smartsheet:
Formula % Calculation was 20%
Automated (Smartsheet Project Settings)
Summary Task % =30%
Task 1 20%
Task 2 40%
Task 3 60%

Sorry Ron
I have been playing with it for over an hour and I can't work out the algorithm. It is linked to the duration.
I'll carry on thinking about it though...
Kind regards

Thanks
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 378 Global Discussions
 208 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
 290 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!