I know this has been posted many times before, but we need a real solution to allow for grouping by multi-select fields in a way that makes all records associated with at least that value shown in the value grouping.
Yes, this might result in one record appearing multiple times in a grid view. Yes, that is desirable.
Notion users know that this is much more intuitive and user-friendly than the way Airtable handles this behavior.
Here's a real example for us:
We do project planning in Airtable across quarters. Projects may span multiple quarters (multi-select field). There is no way to view all projects grouped by quarter where all Q1 projects are collected in a single group!
As a designer, it boggles my mind that it behaves this way...