A shared job sheet may be used by someone checking unpaid work while another person allocates tomorrow’s jobs. A normal filter changes the shared view. A filter view lets a reviewer work with a particular subset without applying that same view to everyone else.

Begin with a table that has clear headings and a stable identifier for each record. An invoice number or job ID is safer to discuss than “row 18”, because the visible row order can change. Confirm that your intended table range includes all the relevant columns.

Create a view for one decision

Select a cell in the data and use Data, Create filter view. Apply the condition that matches your task, such as a status column containing “awaiting information”. Save the view with a name that describes its purpose. Google’s current interface also lets you reopen saved views through Data, Change view.

Check a known record that should appear and one that should be excluded. This small check catches the common mistake of filtering the wrong status column or missing rows outside the selected range. It is especially useful before reporting that there are no outstanding jobs.

Keep viewing separate from editing

A personal view does not create a private copy of the data. Changes to the underlying records remain real edits. If you need to experiment with bulk changes, agree a separate test-copy process rather than relying on the view to protect the original.

For an illustrative rehearsal, ask an authorised colleague to keep the normal sheet open while you change your filter view. Confirm that their view remains suitable for their work. Close your view and make sure you can see the expected full list again.

When passing a finding to someone else, identify the record and the issue, not just its position on your screen. A filter view helps people look at the same dataset for different reasons; it does not decide who is responsible for correcting the records.

References: Google Sheets collaboration.