QUERY and array formulas return partial results
QUERY and array formulas return only the first result or fail to expand, and the error messages do not explain why.
Tier II · Emerging Problems that are still building up.
3 public reports · first reported 27 September 2024 · last reported 12 May 2025
What's going wrong
People using QUERY, FILTER, MAP or array formulas to build lists often find that only the first item comes back, or the result refuses to expand and reports a size limit.
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 3 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.