Do Google Sheet Filters Affect the data in AppSheet

If I have filters set in my google sheet will that affect appsheet?

Solved Solved
0 4 208
1 ACCEPTED SOLUTION

If you use the Create a filter choice, that filter will affect AppSheetโ€™s ability to access your data. If instead you use a filter view (Create a new filter view), that filter view will not affect access to your data.

View solution in original post

4 REPLIES 4

Steve
Participant V

3X_7_5_75f9aeef10ff30db08f98eb132a2eca92464e2a1.png

So Filter views needs to be set to no, otherwise it will affect appsheet?

If you use the Create a filter choice, that filter will affect AppSheetโ€™s ability to access your data. If instead you use a filter view (Create a new filter view), that filter view will not affect access to your data.

Iโ€™ve never experienced basic filtering affecting the records that Appsheet reads (records hidden by the filter will still be read by Appsheet).

However, sorting will actually re-arrange the records in the sheet, which will affect the order that Appsheet reads them in, this includes sorting within a filter.

Sorting within a filter view, however, does not actually โ€œphysicallyโ€ rearrange the records in the sheet, so youโ€™re safe there.

Top Labels in this Space