I'm trying to do a data validation list that is dependent on other validation lists in Google Sheet. In context, I’m helping with a content planner calendar. This calendar is divided into five pillars, each with its own set of topics. So I need the topic dropdown to change every time I select a pillar.
The headers are the first data validation dropdown. According to the headers, I want the second data validation to change the dropdown elements. I've already created the five columns I'll need and named the ranges the same as the header. I experimented with the following formulas:
Indirect – However, I discovered that in order to work, I must create multiple ref erence columns. It doesn't work for me because I need these dropdowns for a year's calendar.
Index + match – Every time I try this, I get an error message because I selected 5 columns. I used the following video for this formula: https://www.youtube.com/watch?v=ku17vgq4Q14&t=244s
Pillars and Topics of the pillars
I would be grateful for any assistance.
