Filter Views in Google Sheets: Stop Breaking Everyone Else's View When You Sort

Learn how filter views in Google Sheets let you sort and filter without disrupting teammates. Step-by-step setup for shared spreadsheets.

Last Tuesday, my business partner called me from across the office — which is to say, from the other side of a folding table — and said, "Did you just sort the client tracker? Because everything I was looking at is gone." I had. I'd hit A→Z on the name column because I needed to find someone fast. And in doing so, I'd rearranged every row on the live sheet she was mid-way through updating. Her cursor was now sitting in the wrong client's row, and she'd just typed a note into someone else's record. We've all done this. And most of us keep doing it because we don't know that Google Sheets solved this problem years ago with a feature almost nobody uses correctly: filter views.

The Difference Between Filters and Filter Views (And Why It Actually Matters)

Google Sheets has two filtering mechanisms that look almost identical but behave in completely opposite ways. A regular filter — the one you get from Data > Create a filter — is applied to the sheet globally. When you filter or sort, every person looking at that sheet sees the same result. Rows disappear for everyone. The sort order changes for everyone. If someone's in the middle of entering data three rows down, their row just moved. This is the one most people use, and it's the one that causes 90% of the "who moved my data" arguments in shared spreadsheets.

A filter view, on the other hand, is personal. It's your lens on the data. When you create a filter view and sort by date or filter to show only "In Progress" rows, you're the only one who sees that change. Everyone else's screen stays exactly as it was. The underlying data doesn't move. Nobody's cursor jumps. Nobody accidentally edits the wrong row because you needed to find something.

The mental model I use: a regular filter is like rearranging the furniture in a shared office. A filter view is like putting on a pair of glasses that only changes what you see. Same room, same furniture, different perspective.

How to Create a Filter View (Step by Step, 2 Minutes)

This takes less time than explaining to your teammate why their data moved. Here's the exact sequence:

• Open your shared spreadsheet and go to the tab you want to filter.
• Click Data in the top menu, then Filter views, then Create new filter view.
• The screen will shift — you'll see a dark bar at the top with a name field (it defaults to "Filter 1"). Rename it to something useful: "My Active Projects", "Sarah - Overdue Only", "Q2 Invoices".
• Use the dropdown arrows in the column headers to sort or filter however you want. Filter by status, sort by date, hide completed rows — whatever you need.
• When you're done, just click the X on the dark bar at the top to close the view. The sheet goes back to its normal, unfiltered state for you. It never changed for anyone else.

That's it. You now have a saved, named filter view you can return to anytime from Data > Filter views. It stays there until you delete it. You can have dozens of them on a single sheet.

Five Filter Views I Actually Use Every Week

The real power of filter views isn't that they exist — it's that you can build a library of them and flip between perspectives on your data in two clicks. Here are the five I keep on our main tracker and reach for constantly:

• "My Tasks Only" — Filters the Assigned To column to just my name. I see my work. My partner sees hers. Neither of us has to scroll past the other's rows.
• "Overdue" — Filters to show only rows where the due date is before today and the status isn't "Complete". This is my Monday morning reality check.
• "Needs Files" — Filters to rows where the attachment or document column is blank. These are the tasks that are technically "done" but missing their deliverable, receipt, or signed form — the ones that come back to bite you.
• "This Month" — Filters the date column to the current month. Useful for invoicing, for reporting, for just knowing what's on the plate right now without scrolling through six months of history.
• "Flagged" — We use a simple checkbox column for flagging rows that need a second look. This filter view shows only checked rows. It's our "come back to this" list.

Each one takes 30 seconds to set up, and once it's saved, it's two clicks to apply. Compare that to manually scrolling, squinting, and Ctrl+F-ing your way through 400 rows every time you need a specific slice of data.

The Permissions Wrinkle (And How to Handle View-Only Collaborators)

Here's where filter views get slightly complicated, and where most people hit a wall and give up. If someone has edit access to your spreadsheet, they can create their own filter views and use any filter view that already exists. No issues. But if someone only has view access — a client you've shared a read-only link with, a manager who just needs to see the dashboard — they can't create filter views at all. They're stuck with whatever default view the sheet loads in.

Google added a workaround for this a few years ago: when you create a filter view, there's a small option in the dark bar at the top that says "Create a copy for each user with view access." It's called a "temporary filter view" and it lets view-only users filter and sort the sheet without affecting the underlying data or anyone else's view. It works — but it's temporary, meaning their filter isn't saved when they leave.

I use this all the time. Instead of saying "open the tracker and filter column D to your name and sort by date," I just send the URL. They click it. They see exactly what they need. No instructions required.

Combining Filter Views With Other Spreadsheet Patterns

Filter views get dramatically more useful when your spreadsheet is already set up with clean, consistent data. If your status column has six different spellings of "complete" ("Done", "done", "DONE", "Complete", "Completed", "finished"), your filter view for completed items is going to miss half of them. This is where data validation dropdowns and filter views become best friends.

Set up a dropdown with exactly four or five status options — "Not Started", "In Progress", "Waiting", "Complete" — and suddenly your filter views work perfectly every time. No fuzzy matching. No missed rows. The same goes for any column you plan to filter on: assignee names, project types, priority levels. If the data going in is consistent, the filter views coming out are reliable.

Another pattern that pairs well: if you've built a master tab that pulls data from multiple sheets, filter views on that master tab let you slice across your entire operation without jumping between tabs. Want to see all overdue items across every project? One filter view. All items assigned to a specific person across every department? One filter view. The master tab does the aggregating; the filter view does the focusing.

The Mistakes That Trip People Up (And How to Avoid Them)

After setting up filter views for a few different teams, I've seen the same handful of mistakes come up repeatedly. Here's what to watch for:

• Forgetting you're in a filter view and adding new rows. New rows added while a filter view is active will appear, but they might seem to vanish when you close the view if they don't match the filter criteria. Always close the filter view before adding new data to avoid confusion.
• Using a regular filter on a sheet where filter views already exist. They don't conflict technically, but they cause confusion. If you turn on a global filter, everyone sees the filtered version — and some people will think their filter view is broken. Pick one pattern and stick with it.
• Not naming filter views. "Filter 1" through "Filter 12" is organizational debt. You'll forget what each one does within a week, and so will everyone else on the sheet.
• Creating filter views that overlap too much. If you have "Overdue Tasks" and "Tasks Due This Week" and "Urgent Tasks" and they all show basically the same 15 rows, consolidate. Fewer, more purposeful views beat a cluttered list.
• Deleting a filter view someone else uses. Filter views are shared across all editors. If you delete "Sarah's View," Sarah can't use it anymore. Ask before you clean up.

Making Filter Views Part of Your Standard Setup

The biggest shift I've made in how I build spreadsheets is treating filter views as part of the initial setup, not an afterthought. When I create a new tracker — for projects, for clients, for inventory, whatever — I build three or four filter views before I even start entering data. It takes five minutes. And it means that from the very first day the sheet is in use, everyone on the team has their own way into the data without stepping on each other.

My default starter set for any new shared sheet: one filter view per team member (filtered to their name), one for overdue items, one for items missing files or attachments, and one for "this week." That covers about 80% of the reasons anyone opens the sheet in the first place.

If your spreadsheet has a file or document column — where you're tracking which rows have their signed contract, their receipt, their photo attached — a "Needs Files" filter view is genuinely one of the most useful views you can build. It instantly shows you every row that's technically complete but still missing its proof. That's the stuff that creates problems three months later when someone asks for documentation and you realize it was never uploaded.

Here's the thing nobody tells you about shared spreadsheets: the technical features aren't the hard part. The hard part is making a shared space where five people can work without undoing each other's work, without hiding each other's data, without having to send a Slack message every time they need to sort a column. Filter views solve that specific, daily, deeply annoying problem. Set them up once. Stop having the "who moved my data" conversation. Start using that time for actual work.

Frequently Asked Questions

What's the difference between a filter and a filter view in Google Sheets?

A regular filter (Data > Create a filter) applies to the sheet globally — everyone sees the same filtered/sorted result. A filter view (Data > Filter views > Create new filter view) is personal, meaning only you see the change while everyone else's view stays the same. For shared spreadsheets, filter views are almost always what you want.

Can view-only users use filter views in Google Sheets?

View-only users can't create permanent filter views, but they can use temporary filter views that let them sort and filter without affecting the sheet. You can also send them the direct URL of a saved filter view, which opens the sheet pre-filtered for them.

How many filter views can you have on one Google Sheet?

There's no hard limit published by Google, and in practice you can create dozens per sheet. That said, keeping the number manageable (under 10–15 per tab) makes it easier for your team to find the view they need without scrolling through a long list.

Do filter views affect formulas in Google Sheets?

No. Filter views don't change the underlying data or affect any formulas. SUMs, COUNTIFs, and lookups all continue to reference the full dataset regardless of what's visible in your filter view. The only thing that changes is what rows you see on screen.

Can I share a specific filter view with someone via a link?

Yes. When a filter view is active, the URL in your browser changes to include that filter view's ID. Copy that URL and send it to anyone who has access to the spreadsheet. When they open it, they'll land directly in that filter view. This is a great way to send a client or teammate a pre-filtered view without making them set anything up.