Hello. I’ve been searching around online and I still can’t seem to find a solution. I was hoping someone here might be able to help. I’m looking to do the following:
- When a board game owner is selected from A1, a list of their owned games should be listed alphabetically by the Game Title. Otherwise, no games should be listed.
- The games should list not only Game Titles, but Player Number, Recommended Players, and Playtime.
- If a genre is selected from the Choose Genre(s) dropdown, the listed games should be filtered to only include games including that genre (as seen in the “Game Collection” sheet). If an additional genre is selected, then only games containing both genres should be listed.
- Like the genres, if a mechanic from Choose Mechanic(s) the list of games should be filtered to only include games with those mechanics. This also needs to work along with the genre selection.
Example:
- Selecting “Alex’s Board Games” should list all of Alex’s games.
- When selecting “Card Games” from a Choose Genre(s) dropdown, the following games should be listed:
Anatomy Fluxx
Binding of Isaac: Four Souls - Ultimate Collector’s Edition, The
Cult Following
Here to Slay
Here to Slay: Berserkers & Necromancers
Here to Slay: Warriors & Druids Expansion
Unstable Unicorns
Xybrid - When additionally selecting “Party Game” from another Choose Genre(s) dropdown, only the following should be listed:
Cult Following
Unstable Unicorns - Furthermore, when selecting “Storytelling” from the Choose Mechanic(s) dropdown, only the following should be listed:
Cult Following
If anyone can help me with this it would be highly appreciated. Thanks.
My file:
Board Game Annex.ods (29.1 KB)