How to use Filter Views in Google Sheets

I considered myself a Power User of Google Sheets, until I found that this feature has existed in Google Sheets for more than a year now.

How to use Filter Views in Google Sheets to Collaborate

When you use data filters in a Google Sheets spreadsheet to filter rows of your interest, other collaborators working with the same data also have to ‘deal’ with the filtered view of the data that you created.

So that begs a couple of questions:

  • Can you truly collaborate in Google Sheets when such constraints exist?
  • Can you view the data of your interest without troubling other team members who are sharing the same Google Sheets spreadsheet with you?

I have faced this exact challenge ever since I switched from Microsoft Excel to Google Sheets a couple of years ago. I have worked under this constraint since then and I thought a solution to this problem didn’t exist. Although this challenge has led me to find some alternative solutions that work very well for me today (which could be a story for another day).

Using Filter Views in Google Sheets, you can now filter the data, without it affecting what any of your other collaborators see in their version of the spreadsheet.

So whenever you would like to create a view that doesn’t affect anybody else, simply filter the data and save it as a Filter View with a name of your liking.

#googlesheets #analytics #productivity #tipsandtricks #collaboration #poweruser

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s