Feb 11, 2018 12:30 AM
Let’s say I want to assign the same item to two categories in a multiple select field. And I am grouping my view by that field. For instance maybe I am creating a list of vendors and what we buy from them, so for HP I want to select “computers” and “printers” from my multiple select field. For Xerox I would only select “printers”. I would now want my grouped view to look something like this:
But instead what Air Table understandably does is this:
Is there a way to create the grouping I want where HP would be listed twice, once under each category, as in my first example? Hopefully I’ve described my question in a way that makes sense.
Feb 11, 2018 09:00 AM
You may not like the solution I think of…
Create a seperate record for every item, and let go of the idea of Multi Select and switch to Single Select. Something like this:
If you enter it like that, the grouped view will be like this:
I know, it’s not perfect, but it works.
Feb 11, 2018 09:47 AM
Thank you. Yes, as long as that’s the solution I can live with that :-).
Aug 09, 2018 07:06 AM
This is also why I have come to the forum today.
Airtable should have a switch to group in this way. It’s confusing to see so many groups - arbitrary, non-existent groups of multiple combinations.
Mar 17, 2021 06:40 AM
Hello! It’s now 2021 - has there been any progress on this issue?
In Grid View - Is there a way to group by a Multiple Select field that separates each ‘select’ to a group?
Jan 24, 2023 11:26 AM - edited Jan 24, 2023 11:26 AM
Hello! It is not 2023 – has there been any progress on this issue?
I would also like to group by a multi-select field, displaying records with multiple values separately in each distinct selected value group. Notion does this perfectly.