Trying to get an accurate count of checked boxes in a report

kmagley · 12/03/24

hi there, I am trying to get my report to only count boxes checked in each row. instead, it is counting the checked and unchecked boxes, which doesn't translate into my dashboard report. Is there a way to make sure it only counts check boxes for each summary?

Paul Newcome · 12/03/24

You will need to use a separate sheet with formulas on it to calculate this. You won't be able to do this through a report.

=COUNTIFS({Source Sheet Checkbox Column}, @cell = 1)

=Chris Palmer · 12/03/24

Hello @kmagley

Something like this perhaps?
=COUNTIF([Check Box Column]:[Check Box Column], 1)

kmagley · 12/03/24

https://community.smartsheet.com/discussion/comment/464185#Comment_464185

does that formula go into both sheets that I have feeding the report? here is a screenshot of what it looks like right now

I only want the reappointments that are checked to be counted, not the terminate or transfers, as those are counted in another column.

florian.zbinden7 · 12/03/24

hi,

yes this is possible. There are several ways to do it, it depends on what you want to do with it afterwards.

You can filter for the checked checkboxes, or summarize (and count) or group.

kmagley · 12/03/24

I have filters and summaries set up; the summary is set to count each. I would like for this to filter to a dashboard chart with an accurate count of reappointments, terminations, and transfers.

florian.zbinden7 · 12/03/24

Hard to say without knowing how your sheet is structured. Did you try filtering for reappointment only ?

kmagley · 12/03/24

yes, but it still counts 26 for the other two columns.

Paul Newcome · 12/03/24

You will need to use a separate sheet with formulas on it to calculate this. You won't be able to do this through a report.

=COUNTIFS({Source Sheet Checkbox Column}, @cell = 1)

kmagley · 12/03/24

THANK YOU!!! i made a sheet just for countifs and it worked on my chart.

Paul Newcome · 12/03/24

Happy to help. 👍️

Trying to get an accurate count of checked boxes in a report

Best Answer

Answers

Help Article Resources

Categories