Query breaks when criteria come from cells
Query formulas fail with parse or column errors when the criteria or column names are built from cell values.
Tier I · Proven The best-established problems.
5 public reports · first reported 29 April 2024 · last reported 9 June 2025
What's going wrong
Spreadsheet users building Google Sheets QUERY formulas often find them break when the filter text or the selected column comes from another cell.
AI-assisted: written with the help of AI from the reports. The idea report has the full summary.
In the idea report
- The full summary.
- The products the 5 reports are about, and how many came each month.
- Related problems.
No business has been found with this problem yet, so the report has no contacts. All sales are final — no refunds. Pricing.