Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I have a sheet that has checkboxes. I would like to be able to make a chart in the dashboard that shows percentage of how many checked out of total. I have a count for the checked boxes, but no total to reference. How would I go about this?
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:
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 non-empty rows. Without the use of NOT and ISBLank.
It would, I agree. But at least we now have Facebook Workchat
Currently, there is a form linked to a Smartsheet that automatically updates every time the form is submitted. I need to graph data from specific columns, which I want to be in another sheet for visual clarity. From what I understand, I need to pull that data into the sheet I am charting in before I can plot it. What…
Hi all, I have a sheet "Transition Tracker" where my team adds data that can often change throughout the lifecycle of a project. When this data is initially added, I have an automation that copies it to another sheet used by another department. I need to add a formula to the other department's sheet that will update a…
Hi all, I have set up a form and workspace, this has multiple sheets and dashboards so that each form filled in finds its way to the correct sheet and dashboard. But when each form is completed on a sheet, the original sender does not receive an alert to inform them the form is now closed. I have 6 different sheets so what…
