Structuring your workbookStart here
SheetApps recognises tabs by a name prefix. Use these so it knows what each sheet is for:
| Sheet name prefix | Becomes |
|---|---|
| Form_<Name> | A data-entry form. Each Form_ sheet becomes its own page in a multi-form app. |
| List_ / Master_ / LOV_ | A lookup (master-data) table that backs dropdown fields. |
| Rules_ / Rule_ / Validation_ | Field validation rules (see Rules below). |
| Formula_ / Formulas_ / Logic_ | Calculated fields, computed live: arithmetic ("hotel + meals"), totals ("sum of hotel from LINE ITEMS"), and IF / Boolean logic. Line formulas may use HEADER fields. See Formulas below. |
| Info_ | Free-text notes about the app, shown atop the app's Help guide. |
| Translation_ | Per-language translations of the app's own field labels, dropdown values and validation messages. |
| Report_ / Analytics_ | A dashboard — KPI tiles, charts and a pivot table over the app's records (see Dashboards). |
Header vs. line items: within a Form_ sheet you can model a header section plus repeating line items (e.g. a purchase order with multiple line rows). SheetApps links them automatically and keeps that link in exports/imports via a Record ID column.
Section markers: for document-style layouts, put HEADER or LINE ITEMS on its own row to mark what follows. Under HEADER, rows are label/value pairs — several pairs can sit side by side. Under LINE ITEMS, the next row is the table's column header. A title row above is fine, and the marker text is what the Section column in Rules/Logic sheets refers to. A LINE TOTALS block (document totals) is stored with the header. A form may have at most one HEADER and one LINE ITEMS section — a second of either is a hard error, so the app won't be created until you fix it.
Form name: a heading row above the first marker (e.g. a merged, centered "Travel Expenses" banner) becomes the form's display name. Without one, the name comes from the sheet name after Form_. Add several Form_ sheets and each becomes its own page; the first is the landing page.
About the app (Info_): add a sheet named Info_ with free-text notes — purpose, instructions, contacts. Its content appears at the top of the generated app's Help guide. Each row becomes a line; blank rows are kept as paragraph breaks. Formatting carries over: cell bold / italic (even a few words styled within a cell) become emphasis, and you can write light markdown too — ## headings, - bullets, and [links](https://…). It can also declare the app's region with country:, currency: or locale: rows (e.g. country: DE), which seed the app's regional settings.
Translations (Translation_): to show an app's field labels, dropdown values and validation messages in more than one language, add a Translation_ sheet plus per-language List_ columns. See the Localization topic for the full walkthrough.