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
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Can I link a Smartsheet report in a form. My form will be for a person to confirm info from a report is correct. So I want the user to be able to view the report while filling out the form.
- I have 4 sheets used by individuals to track their work. I have a report that pulls from all 4 of those sheets to give me a total count of items they listed for the month as well as each line item (de…
- Hi All! Quick question - I am working on a form with a lot of yes or no questions, and I decided to display them as horizontal radio buttons. They are all circles except for one question, which shows …
