Converting numbers and text in Airtable formula fields
  • 19 Dec 2023
  • 1 Minuto para leer
  • Oscuro
    Ligero
  • PDF

Converting numbers and text in Airtable formula fields

  • Oscuro
    Ligero
  • PDF

The content is currently unavailable in Spanish. You are viewing the default English version.
Resumen del artículo

This article covers how to convert numbers and text in formula fields to streamline your team's and organization's work.

Introduction

Plan availability

All plan types

Platform(s)

Web/Browser, Mac app, and Windows app

Related reading

Converting numbers to text strings in Airtable

Converting numbers to text strings

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.

{Number field's name} & ""
CONCATENATE({Number field's name} , "")

Converting arrays to text strings in Airtable

Converting arrays to text strings

Lookup fields can be appended with &""or "" in a CONCATENATE() function to convert their outputs (arrays) to text for use in text-based functions.

{Lookup field's name} & ""
CONCATENATE({Lookup field's name} , "")

Converting strings to numbers in Airtable

Converting strings to numbers

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.

{Name of the numeral string field that you are referencing} + 0


¿Te ha sido útil este artículo?