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


  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    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.



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!