QUERY criteria on imported rows return wrong or no rows
Text, sum and cell-reference criteria in an imported QUERY return wrong rows or none, and filters on source rows give disordered results.
Tier II · Emerging Problems that are still building up.
6 public reports · first reported 22 July 2020 · last reported 17 January 2024
What's going wrong
People who filter imported rows by a text match, a status word, a cell value or a sum get results that are missing rows, include the wrong ones, or fail with syntax errors.
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 6 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.