Name
1
&
2
CONCATENATE()
3
TRIM()
4
SEARCH()
5
ENCODE_URL_COMPONENT()
6
SUBSTITUTE()
7
FIND()
8
LOWER()
9
UPPER()
10
REPT()
11
MID()
12
T()
13
RIGHT()
14
LEFT()
15
LEN()
16
' '
17
“”
18
MID()
19
REPLACE()
20
>
21
=
Drag to adjust the number of frozen columns
Formula Data Type
Description
Technical Function Usage
Example Function Usage
✏️ Text operators and functions

Concatenate text values into a single text value.

&
✏️ Text operators and functions

Joins together the text arguments into a single text value.

CONCATENATE(text1, [text2, ...])
✏️ Text operators and functions

Removes whitespace at the beginning and end of string.

TRIM(string)
✏️ Text operators and functions

Searches for an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition. (startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be empty.

SEARCH(stringToFind, whereToSearch,[startFromPosition])
✏️ Text operators and functions

Replaces certain characters with encoded equivalents for use in constructing URLs or URIs. Does not encode the following characters: - _ . ~

ENCODE_URL_COMPONENT(component_string)
✏️ Text operators and functions

Replaces occurrences of old_text with new_text.

SUBSTITUTE(string, old_text, new_text, [index])
✏️ Text operators and functions

Finds an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition.(startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be 0.

FIND(stringToFind, whereToSearch,[startFromPosition])
✏️ Text operators and functions

Makes a string lowercase.

LOWER(string)
✏️ Text operators and functions

Makes string uppercase.

UPPER(string)
✏️ Text operators and functions

Repeats string by the specified number of times.

REPT(string, number)
✏️ Text operators and functions

Extract a substring of count characters starting at whereToStart.

MID(string, whereToStart, count)
✏️ Text operators and functions

Returns the argument if it is text and blank otherwise.

T(value1)
✏️ Text operators and functions

Extract howMany characters from the end of the string.

RIGHT(string, howMany)
✏️ Text operators and functions

Extract how many characters from the beginning of the string.

LEFT(string, howMany)
✏️ Text operators and functions

Returns the length of a string.

LEN(string)
✏️ Text operators and functions

Create a line break when inserted between other text in a formula.

'\n'
✏️ Text operators and functions

Smart quotes (“”) appear curved and will cause an error in Airtable. Instead, use only straight-lined quotes within formulas.

""
✏️ Text operators and functions

Extract a substring of count characters starting at whereToStart.

MID(string, whereToStart, count)
✏️ Text operators and functions

Replaces the number of characters beginning with the start character with the replacement text.

REPLACE(string, start_character, number_of_characters, replacement)
❓ Logical operators and functions

Compare if one value is greater than another value.

>
❓ Logical operators and functions

Compare if one value is equal to another value.

=
98 records
Extensions

Alert

Lorem ipsum
Okay