/SQL/Google sheets data validation custom formula filter

Google sheets data validation custom formula filter

-- Google Sheets: Using filter()
--   in custom formula in data validation

=query(filter('sheet1'!$A$2:$A, 'sheet1'$A$2:$A < 4),
       "select Col1 where Col1 = '" & 'sheet2'!A2 & "'")
       = 'sheet2'!A2

-- Note: The 'sheet2'!A2 must be
--   the first (top-left) cell of the validated range

Similar codes

0 vote147 views1 answer
How to map sql column to custom names
SQL
0 vote147 views1 answer
How to locate pg_hba.conf file
SQL
0 vote144 views2 answers
Connect to mysql server mac terminal
SQL
0 vote229 views1 answer
Oracle sql alter view add column
SQL
1 vote220 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
7 votes130 views3 answers
How to check table name in current database sql
SQL
0 vote147 views1 answer
Select into table variable
SQL
1 vote134 views1 answer
Alphabetical order mysql
SQL
0 vote135 views1 answer
Postgresql like
SQL
1 vote131 views2 answers
Sql for date greater than
SQL