CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsspreadsheet
Damien
Damien

Reputation: 373

Is it possible to have several filters in a single Google sheet?

I'm trying to get multiple filters on the same row that filter different tables. So users can sort data from table 1, 2 or 3 individually as they wish. Is it possible to do that in Google sheets?

Quick sample of my data below to better understand what I'm trying to do https://docs.google.com/spreadsheets/d/1Ed0aBmcCN5vUYOIw3-17A2xsFVC4eCT77_nSdToP1h4/edit?usp=sharing

Upvotes: 6

Views: 31898

Answers (3)

Shawn Forgaard
Shawn Forgaard

Reputation: 1

You don't need a workaround. You can do this with array style notation. You just need separate the filters with ";" and add "{" and "}" to either end of the command. I.e. "={filter(, conditions...); filter(, conditions...)}"

Upvotes: 0

Damien
Damien

Reputation: 373

It's actually possible with the "Filter views" accessible from the menu.

  1. Select your data range.
  2. Go in "Filter Views" and create a new filter view.
  3. Rename the filter and adjust the range if needed.
  4. All the filter views that you created can be access from the menu and will be visible by other users.

enter image description here

Upvotes: 3

Tanaike
Tanaike

Reputation: 201613

From your reply, I believe your goal is as follows.

  • You have 3 tables in one sheet in Google Spreadsheet.
  • You want to filter and sort each table using the basic filter to each table.

Issue:

In the current stage, unfortunately, only one basic filter is used in one sheet. And, even when the filter view is used, although the multiple filter views can be created. But, only one filter view can be used by selecting it. And, even when the slicer is used, the slicer cannot sort the rows. And, when one slicer is set to a table as the filter, that affects another table. In these situations, I thought that your goal cannot be directly achieved.

Workaround:

Here, in order to indirectly achieve your goal, I would like to propose the following workaround. The flow of this workaround is as follows.

  1. Separate your 3 tables in a sheet to 3 sheets.
  2. Filtering and sorting each sheet using each basic filter.
  3. Values from 3 filtered sheets are put on another sheet.
    • In this case, I think that you can use the formula.

With this workaround, I thought that your goal can be indirectly achieved.

Upvotes: 6

Related Questions