Data Validation Dropdown With Filtered Data Range

Question

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?

Answer 1

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.