dependent drop down is not working, can't figure it out!
EDIT: SOLVED - Thank you thank you thank you!!!!
Hello everyone, I need help creating a multiple selection dependent dropdown. I'm a Sheets amateur but have always been able to figure things out. This time, my attempts to solve it have been many and are not working. I feel like - if you play Cultist Simulator, I feel like I've summoned a minion who is trying to break free, and I used Passion but it's probably about to kill me.
I'm going to err on the side of less information because when I typed out more it was a mess, but of course I can share screenshots or etc. ETA: created a shareable sheet. Sheet1 and Data1 are set up like the guide; Data2 is another way I've seen could work (it didn't).
Basically, I'm following this guide. I have it set up exactly the same in my workbook EXCEPT my categories/labeled headers run A-F (instead of A-C). I changed Cs to Fs and nothing is happening; dropdown 1 is working fine but dropdown 2 only shows "Waiting..."
Thank you so much!