A Currency field holds a money amount in the currency you choose. Think of a price tag that always shows the symbol, the separators and the cents the same way.
Here is the test: is the answer an amount of money? If yes, you want a Currency field. For a count or a score, use a Number field; for a share, use a Percent field.
Example: a Contracts table with a field called Annual Contract Value. Each contract shows its yearly value in US dollars. A Rollup on the vendor adds the values of its contracts, so Procurement sees the spend per vendor.
The Annual Contract Value field in a contract record, showing $120,000.00 with the currency shown at the right of the input.
Plan Availability | All plan types. |
Permissions | Solution Managers and Workspace Administrators can create, modify and manage Currency fields; members with edit access to the record enter values. |
Platform | Web |
Related Reading |
Adding a Currency Field Type
In Grid View, select the + at the right end of the column headers. From an open record, select + Add new field to this Table at the bottom instead.
Select Currency. You can type to search the list of field types.
Name the field. In this article it is Annual Contract Value. A field name can hold up to 50 characters, and there is no restriction on the characters it can contain.
The field settings panel opens. It has three tabs: Settings, Defaults and Help Text. There is no AI Field Agent tab. The rest of this article takes them in that order. Save at any point with Add Field (or Update Field on a field that already exists) and come back to the other tabs later.
The field settings panel, Settings tab, with Currency Selection, Display Format, Precision, the separators, Large number abbreviation and the Options switches.
Settings
The Settings tab holds the currency, how the amount is shown and the rules around it. Top to bottom: Display Format, Currency Selection, Precision, Thousands and decimal separators, Large number abbreviation and Options.
Display Format
A preview of a sample amount, such as $1,000.00, in the current settings. There is nothing to choose; it updates as you change the settings below it.
Currency Selection
The currency every value in the field is formatted in. A new field starts with the currency of your locale, such as $ - USD, United States Dollar. Open the dropdown and search by code or name; each row shows the symbol and code on the left and the name on the right. The list holds 111 currencies. Annual Contract Value uses USD.
Note: One field, one currency. Every value in the field is formatted in the currency chosen here. For contracts in a second currency, add a second Currency field.
The Currency Selection dropdown open, with the search box and rows showing the symbol, code and name.
Precision
How many decimal places are shown. The default is $1.00, two decimals. The options run from $1 (none) to $1.000000 (six). Annual Contract Value keeps two, so cents show on invoices that are matched against it.
Thousands and decimal separators
Which characters separate thousands and decimals. The default is Depends on Member's Locale, so each person sees the separators of their own locale. The fixed choices are Comma, period (1,000,000.00), Period, comma (1.000.000,00), Space, comma (1 000 000,00) and Space, period (1 000 000.00). Keep the default for a workspace that spans countries; fix the format when a view feeds a document that must look the same for everyone.
Large number abbreviation
How large amounts are shortened. None (the default) shows the full amount. Thousand (K), Million (M) and Billion (B) shorten it, so $1,000,000.00 reads as $1M.
Tip: Turn on K or M for a dashboard or a crowded grid, where $1.2M reads faster than $1,200,000.00. Keep None where cents matter, such as a field matched against invoices.
Options
Three switches. Each one is a rule for the people who fill in records.
Allow negative numbers. Off by default. On, an amount below zero can be entered. Leave it off for Annual Contract Value. Turn it on for refunds, credits, losses and adjustments.
Display thousands separator. On by default. Off, $120,000.00 shows as $120000.00.
Require an entry in this field. Off by default. On, a record cannot be saved until an amount is typed. Turn it on when a blank means something is missing. A contract with no value is a contract nobody has read.
Defaults
Default Value is the amount every new record starts with, typed in the field's currency; the box shows the symbol and the code beside it.
Note: Defaults apply to new records only. Records that already exist do not change when you set or change a default.
Annual Contract Value has no default. Every contract's value is its own, so the field stays blank until it is typed.
Help Text
A note for the person filling in the record, up to 800 characters. Help Text Appearance shows it As A Tooltip (the default, behind an info icon next to the field name) or Below The Field Name (always visible).
Write it for someone who has never seen the field. For Annual Contract Value: "The contract's value for one year, in US dollars, before tax. For a multi-year contract, divide the total by the number of years."
Permissions
Field Permissions. Every field can carry its own permissions, which control who can see the field and who can edit it. Open the column menu and select Edit Field Permissions. Let Procurement edit Annual Contract Value while the risk team reads it, or hide it from a vendor portal. See Field Permissions.
Dynamic Record Permissions. A Currency field can also drive record-level rules: who can see or edit a record based on the value it holds. Every field type except Button can drive a rule. See Dynamic Record Permissions.
Using the field in views and records
In a record, the field is one box showing the amount with the currency code and symbol at its right, such as USD - $. In Grid View, double-click the cell to open the editor, with the same currency label and up and down arrows, type the amount and press Enter. Typing into a cell that is not in edit mode stores nothing. The value shows right-aligned, such as $120,000.00.
Filtering
The operators include equal to, greater than, less than, is empty and is not empty. A view of the contracts whose Annual Contract Value is above 100,000 is the list that needs executive sign-off.
Grouping
Group a view by the field and each distinct amount becomes a group. Amounts rarely repeat, so group by a Formula that bands them instead, such as Under 10K, 10K to 100K and Over 100K.
Sorting
Sort 1 → 9 or 9 → 1 from the column menu. Sort 9 → 1 puts the largest contracts first.
Counting and rolling up
A Rollup on the Vendors table with SUM totals Annual Contract Value across a vendor's linked contracts, and updates as contracts change. The field also works in Lookup fields, on Linked Record cards, in Auto-Generated Titles and in the filters of Count fields. Spotlight can color the cells above a threshold, and Find searches the values. See Rollup Field.
Formulas
A formula reads the amount as a number. To apply a discount held in a Percent field, add a Formula field called Discounted Value with the formula [Annual Contract Value] * (1 - [Discount]). A Percent of 10% is stored as 0.1, so a value of 120,000 returns 108,000. Format the result as currency in the formula's Formatting tab. See Formula Field.
Automations
An Update records or Create a record action can write the field. It can set an amount, or add, subtract, multiply or divide the current one. See Automation Actions explained.
Forms
A Currency field can be placed on a form. See Form View.
Editing a Currency field
Change a value. Open the record, or double-click the grid cell, type the amount and press Enter.
Change the currency. Open Modify Field Settings, pick another currency under Currency Selection, then Update Field. Only the symbol and the format change. The stored amounts are not converted: 12.5 stays 12.5 when USD changes to EUR.
Change the precision or abbreviation. Pick another Precision or Large number abbreviation, then Update Field. The stored amounts do not change; only how they show.
Allow negative amounts. Turn on Allow negative numbers under Options, then Update Field.
Delete the field. Open the column menu and select Delete Field. The values go with it. Deleted fields sit in the Recycle Bin for 30 days.
Frequently asked questions
How do I multiply a Currency field by a Percent field?
How do I multiply a Currency field by a Percent field?
Add a Formula field and multiply the two, for example [Annual Contract Value] * [Discount]. The Percent is stored as a decimal, so 10% is 0.1.
How do I total the values of linked records?
How do I total the values of linked records?
Add a Rollup field on the table that holds the link, point it at the Currency field and choose SUM.
Can a Currency field hold a negative amount?
Can a Currency field hold a negative amount?
Only when Allow negative numbers is on. Turn it on for expense, refund or adjustment fields.
Why does the value show as $1K?
Why does the value show as $1K?
Large number abbreviation is set to K. Set it to None to show the full amount.
Can one field hold several currencies?
Can one field hold several currencies?
No. A field formats every value in one currency. Add a second Currency field for a second currency.
Need more help? Ask the SmartSuite Community, where builders, administrators and the SmartSuite team answer questions about building on SmartSuite. For your account, billing or data, select the chat button in the lower-right corner of SmartSuite to reach support.
Last verified 1 Nov 2026.



