Percent Completed Calculation
I am new to Smartsheets and looking to do a basic calculation of % completed of a status column.
I have multiple steps with task that all need to be completed for the overall project to be considered completed. I want to calculate % completed of each step and to count it completed if status = completed, and if status = not needed.
For this post lets say there are 7 tasks that would need to be marked as completed or not needed in order to equal 100%
If I write the following formula =COUNTIF(Status11:Status17, "Complete") + COUNTIF(Status11:Status17, "Not Needed") it will calculate the proper number of items marked as either completed or not needed.
However, if I try to divide that by the number of tasks to get the percentage (7 for this example) =COUNTIF(Status11:Status17, "Complete") + COUNTIF(Status11:Status17, "Not Needed")/7 the percentage is way off.
I have currently found a work around by hiding another column at this time but I feel like I should be able to calculate this without hiding a column.
Thank you in advance!
Best Answer

You need to add parenthesis so it will do all of the addition before dividing. Add a ( in front of CountIF and a second ) after the "Not Needed")
=(COUNTIF(Status11:Status17, "Complete") + COUNTIF(Status11:Status17, "Not Needed"))/7
Answers

You need to add parenthesis so it will do all of the addition before dividing. Add a ( in front of CountIF and a second ) after the "Not Needed")
=(COUNTIF(Status11:Status17, "Complete") + COUNTIF(Status11:Status17, "Not Needed"))/7

Thank you! Ugh so simple
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!