New answers tagged

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 ...
doubleunary's user avatar
  • 13.3k
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"...
The God of Biscuits's user avatar
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 =...
Blindspots's user avatar
  • 3,411

Top 50 recent answers are included