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

After graduating from Kennesaw State, Chase, seeking to increase his business acumen while attending law school joined Network 1 Consulting.  Excited about the opportunities at Network 1, Chase is attacking each day to learn all that he can about technology and business. or 404-997-7616

Network 1 Consulting is a 21-year-old IT support company in Atlanta, GA. We become – or augment – the IT department for law firms and medical practices. Our IT experts can fix computers, but what our clients value most are the industry-specific best practices we bring to their firms. This is especially important with technology, along with regulations and cyber threats, changing so rapidly. We take a proactive approach to helping our clients use technology to gain and keep their competitive advantage.


Leave a Comment