Calendar App Grouping
I have a multi select column called 'Venue' that contains 4 values to choose from:
I want to group by Venue in Calendar App, but the app wont recognize the unique value in the column, and instead creates groupings based on the total group in the cell.
Meaning, I want to have a cell in the sheet with A,C,D in it, but group the calendar by A, then C, then D. But Calendar App creates the grouping 'ACD'. A report also will not group on a unique value.
How can I split out the grouping to have one calendar? Right now, I have 4 calendars, one for each venue, and it is a bit clunky.