Data Validation Dropdown With Filtered Data Range

user_3749219 0
Viewed 799

I'd like to use data in column D
For a drop down in another sheet (data validation)
Only items where column A is less than 9

I tried List from a range
But it looks like you cannot put a formula in the range box
e.g.

=FILTER(GrpsTY!D2:D, GrpsTY!A2:A < 9)

Any suggestions?

enter image description here

enter image description here

dropdown google-sheets-formula google-sheets filter validation
2 Answers

formulas are not supported in data validation. the best course of action is to create a helper column with your filtered entries and then feed it to data validation.

user_56326290

Maybe they have added the functionality since the most recent answer (last July, 2020)?

I'm trying to figure out a formula that will let me validate data using a filtered list, and stumbled onto this:

This image shows that Google Sheets supports data validation using a custom formula

For Criteria, select "Custom formula is" instead of the default, "List from a range". Hope this helps anyone who comes after me :)

user_58185440
Related