Report filtering for Multi-Select Fields
Rebecca Bennett
✭✭✭
Hello,
We have created a report that pulls from a master sheet. Within the report we have set it up so that it filters for a multi-select field, then groups by the responses in the field.
What we are finding, is that the filter works, but it only groups under the first option selected in the multi-select field. What we would like to have happen is for a response with multiple selections to be duplicated and grouped under each response.
Here is an example. What we would like to have happens for this person to be grouped both under Boise and under Harriet Tubman grouping in a report. Is there a way to do this?
Tags:
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives