Report - Summarize Count Function is not Offering a Column to Select
I created a report from a sheet in which I want to use the summarize count function in the report to count the number of tasks in the report. When I go to Summarize, it does not offer me a column to summarize to count. Screen shot below:
Best Answer
-
Within "Data & Chart Type" settings, uncheck "Use First Column as Series Labels". Then click on "Vertical Axis" and give it a Title that you want. You can also add a Title to the "Horizontal Axis". I believe that should do what you want.
Answers
-
The Summarize Count feature of a Report will not work for a Drop-Down Multi-Select type of column. Why are you using that column type and can you change to a single select?
-
Here's a possible work-around. On your working sheet create a helper column and create a column formula that's:
=Dept@row
Then create a report using the helper column to report on.
-
Thanks, that did work. But how do you count it by Dept if there are multiple departments? I don't want a total count, I want the count of each Dept, if that makes sense.
-
By Grouping setting like so:
-
Thanks. I was able to do that and then create a widget off of the count. My only other issue is that the column name wants to stay next to the chart. And when I click off "use column names as category labels", it uses one of the counts as the axis header. see attached
-
Within "Data & Chart Type" settings, uncheck "Use First Column as Series Labels". Then click on "Vertical Axis" and give it a Title that you want. You can also add a Title to the "Horizontal Axis". I believe that should do what you want.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives