politicalangel
New Member
Hi,
If I create a drop down option, I would like the next drop down to filter by the certain groups within that option that I first selected, so if there is no information on a particular field the field doesn't show up in the second drop down.
Attached is the spreadsheet- I want to be able to select "research" from the first drop down and only the countries that have data in research appear in the 2nd drop down.
What should I do to make this happen?
If I create a drop down option, I would like the next drop down to filter by the certain groups within that option that I first selected, so if there is no information on a particular field the field doesn't show up in the second drop down.
Attached is the spreadsheet- I want to be able to select "research" from the first drop down and only the countries that have data in research appear in the 2nd drop down.
What should I do to make this happen?