Fix the Google Sheets QUERY error "Unable to parse query string for Function QUERY parameter 2": quotes, cell references, dates, clause order, GROUP BY, Col1 and IMPORTRANGE.
Why Google Sheets shows #REF! "Array result was not expanded because it would overwrite data", how to find the blocking cell, and 6 fixes with copy-ready formulas.
Why IMPORTRANGE shows #REF! "You need to connect these sheets" in Google Sheets, how to click Allow access, and what to do when the button never appears.