I am making a google sheet showing details about a set of TCG cards and I would like to be able to filter the table to easily find cards that fit a specific criteria. With something like the cards colour this is easy because you can simply filter by the value of the colour column, but I would like a solution to make more complex filtering possible.
What I am picturing is a 'tag' system similar to what the Stack Exchange website has where you click a rows tag and are shown all other rows with the same tag. A row can have many tags, or none. An example is a card might say "Search your deck for a card that costs 3 or less" so I will create a tag called '3 or less', then assign this tag to all cards that do cost 3 or less, as well as more expensive cards that have the same text. Clicking this tag will show all cards with the tag, so it will achieve a different result than simply filtering by cost.
Does Sheets have a function that can do this?
Here is a link to the sheet, if that helps https://docs.google.com/spreadsheets/d/1LhIfHTvo3qED2C0UgXDw2EiyoFfWBOSbo5UZUQvxV9c/edit?usp=sharing