Overall Status with Weighted Average
I have a project split by 8 different milestones, is there a way to add a weighted average of completion? For example Milestone A and all of the tasks under it should account for 5% of the project completion, Milestone B and all of it's tasks should account for 15%.
Answers

Hi @Kristin Fortner, you can create a formula that will weight the completion average. Assume you have three projects with the below details. I'll use CompleteA, CompleteB, and CompleteC as a stand in for any calculation or reference you use to generate the percent complete for each of the subprojects. Weight, below, is in reference to the weighted percentage of each individual subproject.
Project A, Weight: 20%
Project B, Weight: 40%
Project C, Weight: 60%
The total calculated completion would then be a formula like this:
=0.2*CompleteA + 0.4*CompleteB + 0.6*CompleteC
For instance, if Projects A, B, and C were 55%, 35%, and 87% complete, respectively, the formula would resolve to:
02*0.55 + 0.4*0.35 + 0.6*0.87 = 0.772
So the overall project in this case would be 77.2% complete.
Let me know if that makes sense!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!