Report Summarize

Eenmeier · 02/15/24

Hi,

I have a report that I am struggling to summarize correctly. The first is a Drop Down column with options 1-3, the next is a checkbox column. I have grouped the report by the Drop Down column and that is working well, but there does not seem to be a way to count the the checked rows in the checkbox column. I would expect that it would recognize the box checked as "1" and the box not checked as "0", but it does not and is counting all the boxes blank or checked. How can I get a count of the Install Tier grouped and summarized, with a count of the Router with checked boxes on the same report?

MariaCurtis · 02/19/24

Hi! What I have done in one of my sheets in order to get this total in a report is I have a "helper" column in the main sheet. So in your case, you have your Router column. You could have a "Router Count" column in your main sheet as a column formula:

=COUNTIF(Router@row, true)

I personally like to lock and turn gray or hide my helper columns when I have them. See sample below of how I would approach updating the main sheet.

Then, in the report, instead of using count, you can use Sum. See sample below.

I DO wish we could do a COUNTIF directly in a report. That would be fabulous! Maybe I'll submit as an idea!

MariaCurtis · 02/19/24

Created an idea for this: https://community.smartsheet.com/discussion/117737/allow-countif-in-report-summaries/p1?new=1

MariaCurtis · 02/19/24

Hi! What I have done in one of my sheets in order to get this total in a report is I have a "helper" column in the main sheet. So in your case, you have your Router column. You could have a "Router Count" column in your main sheet as a column formula:

=COUNTIF(Router@row, true)

I personally like to lock and turn gray or hide my helper columns when I have them. See sample below of how I would approach updating the main sheet.