Example of partitioning across worksheets
This app demonstrates having a single table read from multiple sheets. Open the Settings in the app's menu to select the worksheet.
Also see: tablet mode & fullscreen mode
How we built this app
This is done using table partitioning. The app uses the USERSETTINGS("Sheet Choice") formula to pick between the two sheets.
This is a preview of the data sets used in the app.
This is a high-level model of both the data entities and the UI elements in the app.