Currencies & units
When your workbook mixes dollars, euros or kilograms, Sheetward keeps track for you. Money and quantity fields each carry their own currency or unit of measure, worked out from your sample data. The right dropdowns are added with no setup on your part. This page shows how a currency or unit is spotted and how several sit side by side; the reference covers form shapes, naming, dashboards and print.
How a currency or unit is spotted. Sheetward reads a few clues in your sample rows, so most of the time you don't have to declare anything:
| 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, for when a plain layout would be ambiguous | 1,800 Currency=EUR · 12 Unit=KGM | The same result — the label spells out what you mean. |
| 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 recognized 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 in the Data type reference.More than one currency or unit. You never end up with a clutter of dropdowns: each distinct code gets exactly one. The first field that uses a currency creates its dropdown, pre-set to that currency but free to change. 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 only 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.