Grouping by multi-select treats same values in different order as separate groups

Product Feedback Bugs
1

When grouping a table by a multi-select column, rows with identical selections entered in a different order are placed into separate groups instead of the same group.

Example:

  • Item 1 categories: A, B

  • Item 2 categories: B, A

These end up in two different groups despite having the same set of values selected.

I think either these should be treated as the same group by default, or maybe there should be a way to have the selections sorted automatically. So they would always be “A, B “no matter which order they are chosen.

2

There are 2 options:

  1. use an automation to every so often (or upon row changed) sort these field(s) (use modifyrows()
  2. create an extra column and use CFL to fill this column with the sorted values (add .sort()) and use this column as your grouping column.

If you need help, share a dummy doc and we can show how this is done in this doc.

2 Likes