How to Fix Google Sheets Filter Not Working

If a filter is hiding, sorting, or excluding rows you expected to see, do not start by rewriting formulas. That is how a small spreadsheet problem becomes a business-system problem. Preserve the file, isolate the failure, and change only the smallest part you can prove is wrong.

A filter can fail at several layers: the criteria themselves, the range it covers, the data inside it, a protected or shared view, or a FILTER formula. The fix depends on which layer broke.

If this is one of several things breaking in the same file, use the broader Google Sheets troubleshooting guide first, then come back to this specific repair path.

First decide whether this is a view problem or a data problem#

Make a duplicate or version-safe copy before risky edits. You do not need a perfect backup ritual; you need one clean rollback point before you touch formulas, protected ranges, source lists, imported data, or dashboard ranges.

Then write the symptom in one sentence: what changed, where it changed, and what the sheet should have done instead. That sentence keeps you from treating every spreadsheet issue like a formula issue.

Use this diagnosis table before changing anything#

Identify the layer that failed before you edit; do not jump from symptom to fix because a forum answer sounded plausible. Read the middle column first, then apply the safest fix in the right column.

Test the smallest visible part before editing anything#

Now narrow the failure to one place. If it is a formula, test one referenced cell or one row. If it is a dropdown, inspect one validation rule. If it is a protected range, check one blocked cell and its owner. If it is formatting, check whether the value is really a date or number before you change the display style.

This is where most rushed fixes go wrong: they edit the final visible output while the actual failure is upstream. For formula issues, the guide on finding which cell is breaking a Google Sheets formula is the safer path.

Fix filter views without damaging the shared sheet#

Shared templates add another layer: other people may be using filters, protected ranges, or views that change what you see without changing the underlying data. Before you delete rows or overwrite formulas, check whether you are looking at a filtered view, a locked range, or a copied template with inherited settings.

If the problem appeared right after copying a template, pause and compare it with a clean original. The copy process itself may have changed sharing, validation, protected ranges, or references. See how to make a copy of a Google Sheets template without breaking it before rebuilding the file from scratch.

When a FILTER formula is the real problem#

If you are using the FILTER function and it returns nothing, the condition almost never matches the data the way you assumed. Test each condition on its own before combining them. Treat Google's documented behavior for the function as the boundary, and only use a workaround once you understand what it bypasses.

Safe repair sequence for business templates#

A safe repair sequence looks like this: duplicate the file, reproduce the issue in one place, isolate the input or setting, make one edit, test with a realistic sample row, then document the change. If you cannot reproduce the problem in a small test, do not make a large change to the live sheet.

For formulas specifically, start with the plain-English Google Sheets formulas guide if the syntax itself is unclear. Guessing at functions while a live template is broken is slower than learning the one pattern you need.

How to prevent the same filter problem next time#

Prevention is mostly structure. Keep raw data separate from formulas. Keep formulas separate from dashboard outputs. Keep source lists for dropdowns on a clearly named tab. Protect formula cells, but make input cells obvious. Add a small notes tab that explains which ranges are safe to edit.

The goal is not to make the sheet impossible to break. The goal is to make the next break obvious enough that a tired operator can fix it without opening ten tabs and hoping.

What to do next#

If the sheet is business-critical, make the smallest repair in a duplicate, test it with realistic sample data, and then apply it to the live version only after the symptom is gone. If the issue is formula-related, continue with how to fix formula parse error in Google Sheets or how to fix VLOOKUP returning N/A in Google Sheets depending on what you see.

Spreadsheet confidence comes from a repeatable repair loop: preserve, isolate, test, fix, document. That loop beats almost every one-line answer pasted from a random thread.