I'm trying to create a drop-down menu that is dependent on a previous cell in a row.
The data coming in from a DB is M or F. Male or female. Then from what is displayed there I want the next column to do a dropdown of only the categories that each gender is eligible for.
I'd rather do this via custom formula of data validation over a script but I've gotten to the end of the internet and can't quite get this solved.
Here is my sample data link: https://docs.google.com/spreadsheets/d/1OL4MTFELjnluo9o_dIBAMvDzsYarx7IKATodDqo2tU8/edit?usp=sharing