Do Google Sheet Filters Affect the data in AppSheet

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

image

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.

2 Likes

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.

2 Likes