Formulas fail to expand across dynamic rows
Dynamic ranges and repeated formulas do not expand cleanly, so users copy formulas into thousands of rows by hand.
Tier II · Emerging Problems that are still building up.
3 public reports · first reported 16 June 2019 · last reported 27 September 2024
What's going wrong
Google Sheets users want a formula to fill to the bottom of a growing list, but a full-column reference returns an expansion error or adds many blank results.
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.