Formula filters fail on text ranges and sorts
Formula-based filters and sorts cannot pull an ordered subset from a list by comparing text values or dates.
Tier II · Emerging Problems that are still building up.
3 public reports · first reported 17 May 2022 · last reported 22 April 2024
What's going wrong
People building dashboards in Google Sheets want formulas that return the rows between two text values, sort one column by another, or filter by date while inserting blank separator rows.
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.