Google Sheets: Filter View
A common problem with a shared Google Sheet is when different users want to filter the data differently; I want to filter based on my class, and you want to filter it based on your class. Or perhaps someone filtered the sheet before you, and now you have to remove their filter so you can filter based on your own needs...
Well stress no longer because Google Sheets has a clever feature called Filter view which allows every user to create any view they want, without affecting any of the other views of the sheet.
Data > Filter views
Data > Filter views
You can even save the view to refer back to later.
Filter View
Filter View
The view is dynamic, so updates if the underlying sheet is updated.
Google Sheets Filter View.mov