/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 vote330 views1 answer
Online sql testing tool
SQL
0 vote372 views1 answer
Table structure in sql
SQL
0 vote382 views1 answer
Python dictionary to sql update
SQL
3 votes374 views4 answers
Truncate syntax in sql
SQL
4 votes316 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
8 votes342 views2 answers
Python simple connect to mysql
SQL
33 votes346 views6 answers
Change column name in mysql
SQL
0 vote338 views1 answer
Get the previous column of a table in mysql
SQL
0 vote344 views1 answer
SQL authentication error
SQL
0 vote365 views1 answer
How to retrive the today date sql
SQL