How can I make a dropdown that changes based on the first dropdown's answer?
I don't have much experience with Google Sheets, but I'm trying to make a book tracking spreadsheet. I've already written down a list of the genres and subgenres specific to the first genre.
How can I make it so you are forced to choose a genre in the first column, and afterwards, the subgenre list has options pertaining to that specific genre only? For instance, if my book is fantasy, I can click that as the genre, and when I move to the subgenre cell, the dropdown only shows specific fantasy subgenres.
Also I feel it is important to note that not every genre has a subgenre, so that's also made it kind of confusing while I was working on it.
Here's what I got so far: https://docs.google.com/spreadsheets/d/1HtYIohmmwO1a-Q_MeoiFgHu83EAFCtErky7gputHVJ0/edit?usp=sharing
edit: i've figured it out! thanks for all the help!!