What you will build
Complete “Use filter views with collaborators” using the visible Task, Owner, Status sample so each action and the final state can be checked against the source data.
Learning objectives
Open the practice workbook
Practice in your own copy
Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.
Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.
Hands-on practice
Step 1: Select the complete table A1:C5, including the Task, Owner, Status header row.
Step 2: Choose Data > Create filter view. Verify the green temporary filter-view bar appears and shows Range: A1:C5; do not choose Create a filter, which changes the normal sheet view.
Step 3: Confirm the temporary filter view shows filter controls in the header row while all source rows remain present. Use this view for collaborator-specific filtering or sorting without changing the shared normal view.
Step 4: Click the X at the right end of the filter-view bar. When Sheets asks “Save your temporary view?”, click Don't save. Verify the normal sheet view returns with all source rows unchanged.
Checkpoint
| Task | Owner | Status |
|---|---|---|
| Brief | Linh | Done |
| Dataset | Minh | Working |
| QA | An | Planned |
| Launch | Linh | Planned |
Checkpoint for “Use filter views with collaborators”: keep the Task, Owner, Status source records intact after the lesson action.
Common mistakes and fixes
Correction: return to the exact range and command named in the steps, then compare the live sheet with the Task, Owner, Status source fields.
Independent practice
Add one row with the same schema, repeat the action, verify the new row behaves correctly, then remove it to restore the sample.
Key takeaways
- ✓Select the full A1:C5 table, including headers.
- ✓Use Data > Create filter view, not Create a filter.
- ✓Check the green temporary filter-view bar and Range: A1:C5.
- ✓Filter views keep the underlying source rows intact for collaborators.
- ✓Close with X, choose Don't save, and confirm the normal sheet view returns.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Group and ungroup rows.