With the new update for the dropdown column (allowing multiple selection of labels), there is an issue with filtering views. I am creating a database of my volunteer team members and using the dropdown column to identify which teams they are assigned to. Some members are in more than 1 team and with the new dropdown column, I can select more options without creating a secondary column.
However, in the filter view, it creates a brand new category and doesn’t read within the option.
Joe is in A Team and B Team.
Jane is in A Team only.
If I go into filter views, I can’t just selection ‘A Team’ and have both Joe and Jane appear. Joe is now ‘A Team and B Team’.
Is it possible to have it so that it actually searches within the field for the selected option?