% 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!