← Problems

ARRAYFORMULA wrappers fail to fill down rows

ARRAYFORMULA-wrapped formulas do not fill down the column or return a different result per row.

Tier II · Emerging Problems that are still building up.

5 public reports · first reported 1 August 2024 · last reported 18 September 2024

Idea report · $9 · No contacts · All sales final

See a sample idea report

What's going wrong

Google Sheets users who wrap a row formula in ARRAYFORMULA often find it stays on one row or returns the same value everywhere, so they still copy formulas down by hand whenever new entries arrive.

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.