Dashboard - Charting how many checked out of total boxes

Hi there,

Looking at your dilemma I've just discovered a Smartsheet bug

By all rights =COUNT(Checkbox:Checkbox) should give me a count of the number of checkboxes in my Checkbox column, regardless of whether they are checked or unchecked. What it actually does is calculate the number of visible rows in the sheet as it's even counting rows that have no checkbox (because the other fields are blank). In my example, it always came up as 50 for a new sheet.

Using workarounds like the following also doesn't seem to work:

• NOT(ISBLANK()) 
• COUNTIF(Checkbox:Checkbox, 1) + COUNTIF(Checkbox:Checkbox, 0)

It only seems to affect Checkbox formatted columns as changing it to Symbols etc. gives me a true total (e.g. the number of cells with something in them)

To get around this, the easiest way is to create another control column to the right and enter =IF(NOT(ISBLANK(Task1)), 1, "")

This will check a column (in this case what I've named as Task) to see if it is not blank and then put a 1 in the new column. If it is blank, then no value (and therefore no Checkbox) will be present. You can then COUNT(Check:Check) to get your total and plot your original count of checked boxes against this.

Kind regards,

Chris McKay

It would, I agree. But at least we now have Facebook Workchat