P

[That-Haus]

H

[Ferrarezi]

If AppSheet’s native partitioning doesn’t meet your needs, the best solution may be to migrate to a relational database or use a tool like BigQuery to manage the data and integrate it into AppSheet.

This not only overcomes the 100K row limit, but also provides flexibility and scalability for your application.

Another suggestion would be to create tabs, history sheets if possible, or migrate to a relational database.

[Steve]

Partitioning isn't intended to be used as you are attempting and won't work that way.