Filters on mixed date and text columns miss rows
Date-range and text filters on imported or mixed-type columns return wrong or empty results.
Tier II · Emerging Problems that are still building up.
4 public reports · first reported 22 October 2023 · last reported 9 May 2024
What's going wrong
Users pulling transactions or sales data from other sheets with QUERY and IMPORTRANGE report that date-range filters are ignored and that columns mixing codes with words cannot be filtered by pattern.
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 4 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.