قالب وردپرس درنا توس
Home / Tips and Tricks / Filter Google Sheets data without changing what collaborators see

Filter Google Sheets data without changing what collaborators see



  Google Spreadsheets logo

Filters in Google Spreadsheets allow you to analyze data in your document by showing only the things you want. However, it also changes how others see the document. Here's how you can use filter views to keep the view of each employee unchanged.

Start Google Spreadsheets and open a spreadsheet to get started.

  Example of a data set in Google Spreadsheets.

Click Data> Filter Views> Create New Filter View.

 Click Data> Filter Views> Create New Filter View. "Width =" 650 "height =" 368 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "/> </p>
<p>  The row numbers and column letters turn dark gray on activation. This time, you must name your filter view to distinguish it from other views you create in the future and check if the range is correct. You can both later always change if necessary. </p>
<p>  <img class=

For this guide we want to filter there is something in the table that has a price per unit of more than $ 10. Click the filter icon in the "Price per unit" field.

 Click the filter icon next to the column name that you want to filter on.

For this following part you can choose to filter by values ​​or conditions to analyze your data. "Filter by value" provides a simple way to view data and choose specific values ​​in the column. "Filter by condition" offers you a much more detailed approach ak with the option to add custom formulas to find data.

First, click on "Filter by condition" to expand the section, then click on the "Then" drop-down list option.

 Click

RELATED: How to mark a row in Google Sheets with conditional formatting

Enter the conditions for the filter and Click the OK button".

 Typ

Now you can see all products that cost more than $ 10 per unit without disturbing the view of other contributors. [19659003]   Voila! The data in the table now only shows rows that cost more than $ 10 per unit.

Because you can only switch one filter at a time, you can stack filters for each column to increase your data analysis potential. All you have to do is click on one of the filter icons and repeat the same process.

 Add another filter to the same view by clicking on an additional filter icon in the column that you want to filter.

To disable all filter views, click the "X" in the upper right corner of the sheet.

 Click the

If you want to enable a filtered view again, click Data> Filter Views and then choose a filter to view.

 Do you want to see your view again? Click Data> Filter Views and choose a filter to view. "Width =" 650 "height =" 451 "src =" / pagespeed_static / 1.JiBnMqyl6S.gif "onload =" pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "onerror =" this.onerror = null; pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon (this); "/> </p>
<p>  One of the great things about filter views is the ability to view filtered data without changing the spreadsheet view of other collaborators, but if someone wants to use your filter views, they can – even people who only have access to view. </p>
<p>  Click Data> Filter Views and then choose one of the custom views of other collaborators. </p><div><script async src=

 Although filter views do not change someone else's perspective, everyone can switch this by choosing a filter from the menu.


Although this is a very basic use of a filtered view, its use seems to be unlimited, you can stack multiple filters and even add custom formulas to store your data. analyze and sort without disturbing other people you work with.


Source link