Report Summarize
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?
Best Answers
-
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!
-
Answers
-
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!
-
-
This worked. Thank you
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives