Filter views vs filters in Google Sheets - Business Scenario Comparison

Scenario Mode

👤 Your Role: You are a sales coordinator managing a shared sales report in Google Sheets.

📋 Request: Your manager wants you to show how to use filters and filter views to analyze sales data without disturbing others' work.

📊 Data: You have a sales data table with columns: Date, Salesperson, Region, Product, and Sales Amount.

🎯 Deliverable: Create examples using filters and filter views to show filtered sales data by Region and Salesperson.

Sample Data

Date	Salesperson	Region	Product	Sales Amount
2024-06-01	Alice	East	Widget	500
2024-06-02	Bob	West	Gadget	300
2024-06-03	Charlie	East	Widget	700
2024-06-04	Alice	North	Gizmo	400
2024-06-05	Bob	East	Gadget	600
2024-06-06	Charlie	West	Gizmo	200
2024-06-07	Alice	South	Widget	450
2024-06-08	Bob	North	Gizmo	350
2024-06-09	Charlie	South	Gadget	500
2024-06-10	Alice	East	Gizmo	550

1

Step 1: Apply a filter to the sales data to show only rows where Region is 'East'.

Select the data range including headers. Click Data > Create a filter. Click the filter icon in the Region column header. Uncheck all regions except 'East'.

Expected Result

Only rows with Region 'East' are visible: rows with dates 2024-06-01, 2024-06-03, 2024-06-05, and 2024-06-10.

2

Step 2: Explain that this filter affects the whole sheet and other users will see the filtered view.

No formula needed. Just observe that the filter applies to all users viewing the sheet.

Expected Result

All users see only the filtered rows for Region 'East' until the filter is cleared.

3

Step 3: Create a filter view to show sales only by Salesperson 'Alice' without affecting others.

Click Data > Filter views > Create new filter view. In the Salesperson column filter, select only 'Alice'.

Expected Result

A filter view named 'Filter 1' shows only rows where Salesperson is 'Alice'. Other users see the full data without filters.

4

Step 4: Explain that filter views allow multiple users to filter data differently at the same time without conflicts.

No formula needed. Just note that filter views are personal and do not change the sheet for others.

Expected Result

You can switch between filter views or turn them off without changing the main data view.

5

Step 5: Demonstrate how to save and name filter views for easy access later.

While in a filter view, click the name box at top left and rename it to 'Alice Sales'.

Expected Result

Filter view is saved as 'Alice Sales' and can be selected anytime from Data > Filter views.

Final Result

Sales Data Filtered by Region 'East'
+------------+-------------+--------+---------+--------------+
| Date       | Salesperson | Region | Product | Sales Amount |
+------------+-------------+--------+---------+--------------+
| 2024-06-01 | Alice       | East   | Widget  | 500          |
| 2024-06-03 | Charlie     | East   | Widget  | 700          |
| 2024-06-05 | Bob         | East   | Gadget  | 600          |
| 2024-06-10 | Alice       | East   | Gizmo   | 550          |
+------------+-------------+--------+---------+--------------+

Filter View 'Alice Sales' Showing Only Alice's Sales
+------------+-------------+--------+---------+--------------+
| Date       | Salesperson | Region | Product | Sales Amount |
+------------+-------------+--------+---------+--------------+
| 2024-06-01 | Alice       | East   | Widget  | 500          |
| 2024-06-04 | Alice       | North  | Gizmo   | 400          |
| 2024-06-07 | Alice       | South  | Widget  | 450          |
| 2024-06-10 | Alice       | East   | Gizmo   | 550          |
+------------+-------------+--------+---------+--------------+

Bonus Challenge

Create a filter view that shows sales for the 'West' region and the product 'Gizmo' together.

Show Hint

In the filter view, apply filters on both Region and Product columns by selecting 'West' and 'Gizmo' respectively.

Practice

1. What is the main difference between a Filter and a Filter View in Google Sheets?

easy

A. Filters only work on numbers, Filter Views only work on text.

B. Filters save your filter settings permanently, Filter Views do not save any settings.

C. Filters change the data view for everyone, while Filter Views create personal saved filters only you see.

D. Filters are only available in Excel, Filter Views are only in Google Sheets.

Solution

1. Step 1: Understand what Filters do

   Filters apply changes to the data view that everyone sharing the sheet can see.

2. Step 2: Understand what Filter Views do

   Filter Views create personal saved filters that only the user applying them can see without affecting others.

3. Final Answer:

   Filters change the data view for everyone, while Filter Views create personal saved filters only you see. -> Option C

4. Quick Check:

   Filters affect all users, Filter Views are personal [OK]

Hint: Filters affect all; Filter Views are personal and saved [OK]

Common Mistakes:

• Thinking Filter Views affect everyone
• Confusing Filters with Filter Views saving settings
• Believing Filters only work on numbers

2. Which of the following is the correct way to create a Filter View in Google Sheets?

easy

A. Click Data > Filter views > Create new filter view

B. Click Data > Create a filter

C. Right-click a cell and select 'Filter Data'

D. Use the formula =FILTER() in a cell

Solution

1. Step 1: Identify menu options for Filter Views

   Filter Views are created via the menu path Data > Filter views > Create new filter view.

2. Step 2: Differentiate from Filters and formulas

   Click Data > Create a filter creates a normal filter affecting all users, Use the formula =FILTER() in a cell is a formula, and Right-click a cell and select 'Filter Data' is not a valid method.

3. Final Answer:

   Click Data > Filter views > Create new filter view -> Option A

4. Quick Check:

   Filter Views menu path = Data > Filter views > Create new filter view [OK]

Hint: Filter Views are under Data > Filter views menu [OK]

Common Mistakes:

• Choosing Data > Create a filter (normal filter)
• Using formulas instead of menu options
• Right-clicking expecting filter options

3. You have a shared Google Sheet with sales data. You apply a Filter to show only sales above $1000. What happens?

medium

A. Only you see the filtered data; others see all data.

B. The sheet data is permanently deleted for sales below $1000.

C. The filter is saved as a Filter View automatically.

D. Everyone viewing the sheet sees only sales above $1000.

Solution

1. Step 1: Understand effect of applying a Filter

   Applying a Filter changes the data view for all users currently viewing the sheet.

2. Step 2: Confirm what others see

   Since it's a Filter (not a Filter View), everyone sees only sales above $1000 while the filter is active.

3. Final Answer:

   Everyone viewing the sheet sees only sales above $1000. -> Option D

4. Quick Check:

   Filter affects all users = Everyone viewing the sheet sees only sales above $1000. [OK]

Hint: Filters affect all users' views immediately [OK]

Common Mistakes:

• Thinking only you see the filtered data
• Confusing Filters with Filter Views
• Believing data is deleted by filtering

4. You created a Filter View but your colleague says they cannot see your filtered data. What is the most likely reason?

medium

A. Filter Views only affect your personal view, not others'.

B. You forgot to share the Filter View link with your colleague.

C. Filter Views require a paid Google Workspace account to share.

D. Filter Views automatically apply to all users, so this is impossible.

Solution

1. Step 1: Recall how Filter Views work

   Filter Views create personal saved filters visible only to the user who created or opened them.

2. Step 2: Understand sharing behavior

   Filter Views do not change the view for others unless they open the same Filter View themselves.

3. Final Answer:

   Filter Views only affect your personal view, not others'. -> Option A

4. Quick Check:

   Filter Views are personal, not shared views [OK]

Hint: Filter Views are personal; others must open them to see [OK]

Common Mistakes:

• Assuming Filter Views auto-share with others
• Thinking Filter Views need paid accounts
• Believing you must share a link for Filter Views

5. You want to analyze a large dataset in a shared Google Sheet without disturbing others' views. Which approach should you use?

hard

A. Apply a Filter to hide unwanted rows temporarily.

B. Create a Filter View to save your personal filter settings.

C. Delete rows you don't want to see.

D. Copy the sheet and apply filters there.

Solution

1. Step 1: Identify the need to avoid disturbing others

   Applying a Filter affects all users, which can disrupt their work.

2. Step 2: Choose a method that keeps your view personal

   Creating a Filter View lets you filter data without changing what others see.

3. Step 3: Consider alternatives

   Deleting rows is destructive, copying the sheet is extra work and may cause version confusion.

4. Final Answer:

   Create a Filter View to save your personal filter settings. -> Option B

5. Quick Check:

   Filter View = personal, safe data exploration [OK]

Hint: Use Filter Views to explore data without affecting others [OK]

Common Mistakes:

• Using Filters and disturbing others
• Deleting data instead of filtering
• Copying sheets unnecessarily