Report filtering for Multi-Select Fields

Rebecca Bennett
Rebecca Bennett ✭✭✭
edited 06/17/22 in Smartsheet Basics


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?