is there a way to sum a column of checkboxes?

David Park

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

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