Request: Report summaries should count checked = 1 and unchecked = 0 for Checkbox columns

CMathews · 05/10/23

Love the reporting column summaries feature for most column types. However, the Count summary option isn't very useful for Checkbox fields. I want to see how many "violations" there are which we denote with flags being checked or unchecked. I'd expect the following scenario to return "3" and not "5".

Or am I missing a way to configure this to make it return the number of checked flags?

Kelly Moore · 05/12/23

Hey @CMathews

Add a filter to your report where Flag column 'is checked'. This will only count the flagged flags. If you want a count of both, don't add the filter but add a grouping on the Flag column. You will then see the total of unchecked and checked.

or, with the Group on the Flag column, sorted Descending Order

Will this work for you?

Kelly

Leslie S. · 01/16/24

Good morning. I'm also working with check boxes in a report and am having the same problem. I have filters set to only show checks but the report is still counting all of the rows. I'm sure I've just been looking at this too long and am missing something obvious. I appreciate any help you can offer.

Check box counting.PNG

Uploaded Jan 16, 202418.94 KB

CMathews · 01/16/24

Kelly Moore

May 12, 2023

Hey @CMathews
Add a filter to your report where Flag column 'is checked'. This will only count the flagged flags. If you want a count of both, don't add the filter but add a grouping on the Flag column. You will then see the total of unchecked and checked.
https://us.v-cdn.net/6031209/uploads/0GB0CAUO71CR/image.png
or, with the Group on the Flag column, sorted Descending Order
https://us.v-cdn.net/6031209/uploads/D01WXYE57L23/image.png
Will this work for you?
Kelly

Appreciate the idea @Kelly Moore! Unfortunately we're trying to retain grouping and sorting another way in that report. I ended up making a helper function column that counted a checked checkbox as 1 and unchecked as 0, and then used SUM. It's not my favorite workaround because it really clutters my report, but it at least helps with the issue.

Kelly Moore · 01/16/24

Hey @Leslie S.

Is it possible to get screenshots of your Filter, Grouping and Summaries?

Leslie S. · 01/16/24

Hi Kelly. They are attached. Let me know if you need anything else.

Thanks so much for your help!

Filters.PNG

Uploaded Jan 16, 202431.12 KB

Grouping.PNG

Uploaded Jan 16, 202413.19 KB

Summaries.PNG

Uploaded Jan 16, 202415.93 KB

HectorH · 04/02/24

The proposed solution while viable is not ideal. I would much rather see a true count of checked boxes in comparison to the total number of rows without having to use one of the three available grouping layers. This should be a simple side by side view.

Stephen_at_ODOC · 04/16/24

I find it very counterintuitive that on a Report, using the Summarize function on columns that have checkboxes, the report always counts every row instead of only the ones with the boxes checked. Why would it count unchecked boxes, too?

I have three different checkbox columns that I want summarized on a single report. Using the filter workaround would work for a single column, but not for multiple columns.

Ultimately, the goal of this report is to watch the progress (of the three right-most columns) go up until they match the "Facility Count", which tells me that they've all been completed (noted by a check in the box on the associated sheet). Currently, it just looks like everything is already completed.

RubyL · 07/17/24

I ran into the same issue and would like to see if Smartsheet has the solution to sum up the checked boxed today.

Sara T. · 10/17/24

Agree with the feedback, it would make much more sense to have the count only count the check boxes/flags/symbols, or at least have the option for this. otherwise it defeats the purpose of a report with groupings and columns of different counts.

Formulas and Functions

Formulas and Functions

Request: Report summaries should count checked = 1 and unchecked = 0 for Checkbox columns

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Unparseable Error

Finding if a date falls in a range in a referenced sheet

CountIF contains name from a contact list help needed