is there a way to sum a column of checkboxes?
We have a tasklist of 100 items, they are pretty simple, so really nothing more than a checklist. But when we roll this up to a master smartsheet I would like to roll up a "% complete" value.
Is there a way to sum up the number of rows with a checkbox (checked or not), and divide it into the number of checkboxes that are checked/done to calculate a % complete that is then rolled up to a master project smartsheet?
I was using the checkbox because that is the easiest way to get people to mark when their task is done. People were not using a "status" pulldown with 0%/25%/50%/100%. they only updated at 100% so I changed to a "done" checkbox.
Should I be using "COUNT" or "SUM" to do this? Somewhat of a newbie to smartsheets and I didn't find anything in the search to indicate how to do this, or if I am going about it the wrong way
Answers
-
Hi@David Park ,
You can count checked boxes. The formula is just =COUNT([box column]:[box column],=1) Insert the correct name for your checkbox column.
To figure out % checked you need to count a column that requires data. That prevents you from including blank rows at the bottom of the sheet. Use the formula =Count([range]:[range], ISTEXT()) or = COUNT([range]:[range],>0). Then use the 2 formulas to divide and calculate the % checked.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!