Grouping (on a Report) by a Multi-Select Drop Down List

I have a Column (Multi-Select) Drop down List that will not "Group" on a Report, now that I have switched that Column to a Multi-Select Drop down list. Is that a thing? It was working fine, when it was a single list / text; but now that it has multiple items in some of the fields, it seems to get confused (which makes sense). Any way around this?
😕
Answers
-
Ya, that's a thing that you cannot group multi-select columns. You could try creating a helper column that you group by instead:
It's just a formula of =MultiSelect@row ...it's just telling the cell to display what's in the other cell.
-
You can even turn word wrap on for the new column so the results are stacked to make it easier to read. I'm not sure how that will display on the report/grouping though...
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives