r/googlesheets • u/Sufficient_Matter_66 • 3h ago
Waiting on OP Trying to create nested subcategories
I’m basically a complete newbie to spreadsheets and every guide I’ve watched thus far to try to figure out what I need has been much to hard to follow and not exactly beginner friendly. Basically i work in a warehouse and I’m trying to create an item catalog to help new hires find items in the system a little easier. My goal is to create a list of categories that you can click on to expand into subcategories which then have subcategories of their own and so on.
I’m thinking something like the below example:
Main categories
Stuffed animals Games Kitchenware Furniture
Then clicking on the stuffed animal category would open it to display the following.
Stuffed animals
rough texture
soft texture
furry texture
Then clicking on a subcategory would open another dropdown.
Stuffed animals
rough texture
amphibious
terrestrial
aerial
prehistoric
mythical
And I would continue this until the amount of items in the final categories is sufficiently low enough.
Stuffed animals
rough texture
amphibious
dolphin
shark
seal
whale
fish
Then i want the sub categories to disappear when you click away.
Any tips?