Converting numbers and text in a formula field
- 06 Jul 2022
- 1 Minute to read
- Print
- DarkLight
Converting numbers and text in a formula field
- Updated on 06 Jul 2022
- 1 Minute to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
In addition to using formula functions to convert data types, there are a few alternative options you can implement in your formulas to cause similar conversions.
Number to text string
If you append &""
to a formula working with numbers, then it will convert that value to a string in Airtable. As a reminder, the &
operator is equivalent to the CONCATENATE()
function. This means you can also add "" to a CONCATENATE()
function in order to convert a value to a string.
Examples
{Number field's name} & ""
or
CONCATENATE({Number field's name} , "")
Array to text string
Lookup fields can be appended with &""
or ""
in a CONCATENATE()
function to convert their outputs (arrays) to text for use in text-based functions.
Examples
{Lookup field's name} & ""
or
CONCATENATE({Lookup field's name} , "")
String to a number
- If you append +0 to a function using numeral string from a field in your Airtable base, it will convert the value back to a number and allow number formatting in your formula output.
Example
{Name of the numeral string field that you are referencing} + 0
Was this article helpful?