A Formula field can join the values of several fields, with your own words in between, into one line of text. Use it for labels, such as a vendor name and a contract number together.
Here is the test: do people read two or three fields together all the time? If yes, join them into one label they can scan, sort and search.
Example: a Contracts table in a vendor risk program. Contract Label joins the vendor name and the contract number: Acme Payroll - CNT-2026-0041. Everyone sees one clear name for each contract in lists and pickers.
The Advanced Editor with a Contract Label formula joining Vendor Name, " - " and Contract Number.
Plan Availability | All plan types. |
Permissions | Administrators and Solution Managers create and change formulas in the solutions they manage. |
Platform | Web |
Related Reading |
Building the formula
Add a Formula field and name it, such as Contract Label.
Turn on Advanced Editor.
Write the formula with one of the two methods below.
Select Add Field.
A formula is built from two kinds of pieces:
A field's value: the field name in square brackets, [Vendor Name].
Your own text: in double quotes, " - ". Spaces inside the quotes are kept.
With the + operator
Put a + between each piece:
[Vendor Name] + " - " + [Contract Number]
With CONCAT
List the pieces inside CONCAT, separated by commas:
CONCAT([Vendor Name], " - ", [Contract Number])
Both give the same result. The pieces join in the order you list them, left to right.
Tip: Put a space inside the quotes when you need one, such as " ". Without it, the values run together: Acme PayrollCNT-2026-0041.
Numbers and dates in text
Join a number or a date with text and the result is text. A finding name with its created date:
[Finding Title] + " - raised " + TEXT([First Created])
Note: If every piece is a number, + adds them instead of joining them. When one piece is text, + joins. That is why "1" + 1 gives 11.
More examples
Four more labels, each ready to copy.
A full name
CONCAT([First Name], " ", [Last Name])
A label with several parts. An asset label from four fields:
CONCAT([Year], " ", [Make], " ", [Model], " ", [Trim])
A value in parentheses
CONCAT("(", [Vendor Tier], ")")
A summary line
CONCAT("Value: ", [Annual Contract Value], " Tier: ", [Vendor Tier])Frequently asked questions
Why does 1 + 1 give 11?
Why does 1 + 1 give 11?
One of the values is text, so + joins them. Use NUMBER() to turn text that holds a number into a number.
Why do my values run together?
Why do my values run together?
Add a space inside quotes between them: [First Name] + " " + [Last Name].
My field does not appear in the Fields list. What do I check?
My field does not appear in the Fields list. What do I check?
The list shows the fields of the current table and filters as you type. Clear the search box. Fields in other tables are reached through a Linked Record field with a dot.
Can I use the label as the record's title?
Can I use the label as the record's title?
Use Auto Generated on the Record Title instead. It joins fields and text without a formula. See Using Auto-Generated Titles.
Last verified 31 Oct 2026.