Tuesday Tip: Google Docs Filter View

By: Chase Petersen

Google docs, specifically the spreadsheet version, are handy for multiple people to see and create together, but it can be difficult to keep the sheet clean.  One person can filter it one way and make it difficult for others to use it and over time the sheet can become unrecognizable.  Fortunately, Google has a solution built into their product: filter view.  Filter views are separate instances of the data that each individual can change the filters to his or her liking without everyone else seeing those filters.

The sheet maintains the property of data visibility, where as when data is added everyone can see it; even if I am in a filter view and someone else adds to the sheet, that data is added to my filter view.  Conversely, if I add data to the filter view it is also added to the base sheet.  The truly brilliant part of the filter view is that you can save the filter views and name them for anyone who has access to use.

To create a filter view select the data bar at the top of your screen, then hover over the filter views section.  This is were you can create a new filter view, save your filter view, or select a previously created filter view.

The days of losing your google spreadsheet to entropy are over with the proper use of filter views!

 

Chase Petersen: Chase works at Network 1 as a Sales Operations Associate, where he partners with clients to learn their needs and provide thoughtful recommendations on how to meet each one. He is a graduate of Kennesaw State University where he earned his degree in Economics and Political Science.

Network 1 designs, builds and supports the IT you need to run your business more securely, productively and successfully. Whether you want to outsource all of your IT needs to a reliable, responsive, service-oriented company, or need to supplement the work of your internal IT staff, we will carefully evaluate where you are now, discuss where you want to go and implement and support a plan to get you there with as little interruption as possible.

Leave a Comment





Related Posts