Grouping on Reports - Source Column is Dropdown List with Multiple Values allowed
I am creating a Report where once I apply my filtering, I need to be able to Group my results based on specific criteria. One of those criteria comes from a source column in a sheet where the column is a Dropdown List that is allowed to have multiple values selected.
When I create the Report, the column with the Dropdown/Multi-select is not an option. This does not allow me to count the number of line items with that characteristic; more specifically, I would expect that if a dropdown list had options A, B, C and I had 3 entries with: (A, C), (B, C), and (A, C) for example, I would be able to see in my report the following counts:
A: 2, B: 1, C: 3
Is there a way to create a Report to take into account a field with multiple values and be able to count those values under each option?
Many thanks in advance!
Best Answer
-
Reports cannot be grouped by multi-select fields. You would have to create a separate metrics sheet and use formulas with cross sheet references.
Answers
-
Reports cannot be grouped by multi-select fields. You would have to create a separate metrics sheet and use formulas with cross sheet references.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!