Filters shows full data list, but not what is valid based on other filters

When you’re editing your control, there’s a “Show relevant values only” button at the bottom. Click on it to see a list of all other controls on your sheet. You can then select any of those controls to create the dependency.

3 Likes