Dependent enumlist based off of a previous enumlist

[David_Vanderpoo]

Can you make a dependent enumlist based off of a previous enumlist? As an example from the original sheet file used in this video (https://youtu.be/5PiRkXVj1Xo), is there a way to select both “Asia” and “Africa” and see all of their respective countries in the subsequent enumlist while still filtering out every country from “North America” and “South America”? Basically, I want a multiple choice option that then provides a multiple choice option based on the previous selection.

[David_Vanderpoo]

@Stefan_Quartemont What do you think about this?

[Stefan_QREW · Accepted solution]

SELECT(Documents[Country],CONTAINS([_THISROW].[Continent],[Continent]))