New answers tagged google-sheets-query
0
votes
Accepted
Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col1
The error indicates that query() is not getting a valid data table to process. You cannot fix the error by adjusting the query statement.
The issue is with the OC_HISTORY_FILTER() function or one of ...
0
votes
Google Sheets QUERY to return if contains multiple selection and all other values
Alternative approach using matches rather than booleans to handle multiple wheres per column (as we can concatenate the terms with |):
=arrayformula(let(
cols,{"A";"B";"C"...
0
votes
Google Sheets QUERY to return if contains multiple selection and all other values
This is basically an exercise in building your query text string. For simplicity, the solution puts parentheses around text that doesn't actually need it.
For example, it returns
"Where (B =...
Top 50 recent answers are included
Related Tags
google-sheets-query × 923google-sheets × 884
formulas × 363
google-sheets-arrayformula × 263
importrange × 96
vlookup × 56
google-sheets-filter × 53
google-sheets-dates × 51
regex × 34
google-apps-script × 30
concatenate × 27
sorting × 20
google-sheets-arrays × 20
google-forms × 15
regexextract × 11
google-sheets-charts × 10
google-sheets-timestamp × 9
conditional-formatting × 8
google-sheets-custom-function × 7
importhtml × 6
pivot-table × 6
google-docs × 5
google × 5
importxml × 5
search × 4