Do Google Sheet Filters Affect the data in AppSheet

[DanielRPaperWor]

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

[Steve]

[DanielRPaperWor]

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

[Steve · 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.

[Marc_Dillon]

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.