Try the example, then check the result.
Download the fictional material and follow the steps below. The video uses English illustrative diagrams; it does not present a live app recording. Product controls may vary by version.
Check the answer before applying the method to your own data. How we review guides ↗
Watch the complete lesson.
The video uses English illustrative diagrams; it does not present a live app recording. English captions. Product menus may differ in your account.
Use a filter view when you need a private slice of a collaborative table. Google's ordinary Create a filter can be visible and changeable to others with access, while a filter view applies its sorting and filtering to your view. The fictional ticket tracker and worked answer make the result checkable. The companion video's interface panels are labelled illustrative.
Build the practice view
- Import or paste the CSV into a native Google Sheet. Keep the headers Ticket, Status, Owner, and Topic, plus all six data rows. If you open an Office file in editing mode, convert it to a Google Sheet before relying on Sheets-only controls.
- Select the table, including the header row. Choose Data > Create filter view. Do not choose the ordinary Create a filter for this exercise.
- In the new view, filter Status to
Open, then Owner toCasey. Both conditions should be active together. - Name the view Open — Casey and choose Save View if that control appears in your current interface. Use Data > Change view to reopen saved views.
| Ticket | Status | Owner | Expected in the view? |
|---|---|---|---|
| T-101 | Open | Jordan | No |
| T-102 | Open | Casey | Yes |
| T-103 | Done | Casey | No |
| T-104 | Open | Morgan | No |
| T-105 | Open | Casey | Yes |
| T-106 | Waiting | Casey | No |
Swipe or scroll sideways to see every table column →
The answer is exactly T-102 and T-105. Close the view and verify that all six rows remain in the source table. You have filtered what you see; you have not deleted rows.
Saved views, temporary views, and sharing
Google says a user with view-only access may create a temporary filter view, but it is not saved. An editor can name and save one. A filter view is a presentation feature, not an access restriction. Anyone who can open the Sheet according to its sharing settings may still see source rows. Do not put private data into a Sheet on the assumption that a filter view hides it.
Why do colleagues see my filter? You may have used the common Create a filter command. Close that filter and use Create filter view on a copy of the practice data.
Why is my view missing after closing? Check whether you saved it and whether you had edit permission. A viewer's temporary view is not saved.
Why is the answer more than two rows? Check both Status and Owner. Waiting is not Open, and Jordan and Morgan are not Casey.
Sources and verification
Google's sort and filter guidance documents Create filter view, Save View, temporary viewer views, and Change view. Its collaboration guidance recommends filter views when collaborators need independent filtering. Reviewed 11 October 2026. We also tested the six fictional rows in a private native Sheet: Open + Casey displayed two of six rows. Another live collaborator was not observed.
Practice downloads.
The exercise files contain invented information. Save a local copy before editing.