Skip to main content
Web Applications

Return to Question

deleted 11 characters in body
Source Link
Rubén - Volunteer Moderator - ♦
Rubén - Volunteer Moderator - ♦
  • 46.1k
  • 18
  • 100
  • 297

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 exchangeStack 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. Does sheets (or Excel) have a function that can do this?

An 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

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. Does sheets (or Excel) have a function that can do this?

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.

Here is a link to the sheet, if that helps https://docs.google.com/spreadsheets/d/1LhIfHTvo3qED2C0UgXDw2EiyoFfWBOSbo5UZUQvxV9c/edit?usp=sharing

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

Source Link
Samuel Holland
Samuel Holland
  • 25
  • 1
  • 6

Does Google Sheets have a 'Tag' system

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. Does sheets (or Excel) have a function that can do this?

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.

Here is a link to the sheet, if that helps https://docs.google.com/spreadsheets/d/1LhIfHTvo3qED2C0UgXDw2EiyoFfWBOSbo5UZUQvxV9c/edit?usp=sharing