Currencies & units
Money and quantity fields can each carry their own currency or unit of measure. SheetApps works these out from your sample data and adds the right dropdowns for you — no setup needed. This page shows how a code is spotted, and how several currencies or units sit side by side; the reference covers form shapes, naming, dashboards and print.
How a currency or unit is spotted. SheetApps reads a few signals in your sample rows, so most of the time you declare nothing:
| In your workbook | Looks like | What you get |
|---|---|---|
| A cell formatted as money | $2,000 · €1,800 · £950 | The field becomes a currency amount in that currency. |
| A currency or unit code in the next cell (or column) | 100 USD · 25 CT · 12.5 KGM | The number becomes a currency amount — or a quantity with a unit — using that code. |
| A labelled code cell, when a plain layout would be ambiguous | 1,800 Currency=EUR · 12 Unit=KGM | The same result — the label just makes your intent explicit. |
| A telling field name | price, amount, total → money; quantity, qty → quantity | The type is set from the name alone; the dropdown starts on the app's default currency, or a unit you pick. |
| A currency or unit code in the field name | Asset Value USD, Price (EUR), Amount $, Weight kg | The field is pinned to that currency or unit — shown with its symbol ($, kg) and no picker at all. Codes are recognised in any case (usd or USD). |
USD, EUR, GBP…) and units use standard UNECE codes (KGM kilogram, EA each, CT carat…). Both dropdowns are searchable and show the code with its name — see the currency code and uom standard lists under Field data types.More than one currency or unit. Each distinct code gets exactly one dropdown. The first field that uses a currency creates its dropdown — pre-set to that currency but free to change — and every other field in the same currency shares it. A field in a different currency gets its own dropdown, pre-set to its own code. Units of measure work the same way.
So a form with two dollar amounts and one euro amount ends up with just two currency dropdowns — one shared dollar picker and one euro picker — not three. The most common currency becomes the shared, editable default.
That covers the everyday cases. For required pickers, how a form's shape decides where a picker sits, what the dropdowns are named, and how currencies show on dashboards and in print, see Currency & unit reference.