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

Question

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

Any help would be appreciated (I'm OK using Apps Script or Python if needed)

Thanks

Answer 1

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.