Dashboard  Charting how many checked out of total boxes
Comments

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 sure would be nice to have a =Counta formula like in Excel and Sheets that counts all nonempty rows. Without the use of NOT and ISBLank.

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

Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!