I want to create two picklists, where the chosen option in picklist1 determines the available options in picklist2. I created a table1 which contains one column with the main categories. I created a table2 which contains column1 with the subcategories and column2 with the main categories.
I wrote the filter for picklist2 as follows : =FILTER(Table2,"Table2[Column2]=$[Picklist1]") , which gives me an empty picklist2.
If I replace the reference to picklist1 and just enter the chosen main category : =FILTER(Table2,"Table2[Column2]=""Main Category 1"""), it does give me the subcategories belonging to Main Category 1.
How can I make this work?