Top 10 Most Used Airtable Formulas in 2023

Airtable is a powerful and flexible platform that allows you to organize and manage data in a user-friendly way. One of the key features that make Airtable so versatile is its ability to use formulas. In this article, we'll explore the top 10 most-used Airtable formulas in 2023 that can help you streamline your workflows and enhance data management.

‍
1. IF Function

Formula: IF(condition, value_if_true, value_if_false)

This formula checks if a condition is met, and returns one value if 1true and another if false.

Step-by-step instructions:

a. Click on an empty cell in the formula field or create a new formula field.

b. Enter the formula: IF({Field} = "Value", "True Result", "False Result")

c. Replace {Field}, "Value", "True Result", and "False Result" with your desired inputs.

2. AND & OR Functions

Formula: AND(condition1, condition2) / OR(condition1, condition2)

These formulas return true if all (AND) or at least one (OR) of the conditions are met.

Step-by-step instructions:

a. Click on an empty cell in the formula field or create a new formula field.

b. Enter the formula: AND({Field1} = "Value1", {Field2} = "Value2") or OR({Field1} = "Value1", {Field2} = "Value2")

c. Replace {Field1}, {Field2}, "Value1", and "Value2" with your desired inputs.

3. CONCATENATE Function

Formula: CONCATENATE(value1, value2)

This formula combines two or more text strings.

Step-by-step instructions:

a. Click on an empty cell in the formula field or create a new formula field.

b. Enter the formula: CONCATENATE({Field1}, " ", {Field2})

c. Replace {Field1} and {Field2} with your desired inputs.

4. DATEADD Function

Formula: DATEADD(date, number, unit)

This formula helps you add time to a date.

Step-by-step instructions:

a. Click on an empty cell in the formula field or create a new formula field.

b. Enter the formula: DATEADD({Date Field}, Number, "Unit")

c. Replace {Date Field}, Number, and "Unit" with your desired inputs.

5. DATETIME_FORMAT Function

Formula: DATETIME_FORMAT(date, format)

This formula formats a date according to a specific format.

Step-by-step instructions:

a. Click on an empty cell in the formula field or create a new formula field.

b. Enter the formula: DATETIME_FORMAT({Date Field}, "Format")

c. Replace {Date Field} and "Format" with your desired inputs.

6. LEFT Function

Formula: LEFT(string, number)

This formula extracts the leftmost characters from a text string.

Step-by-step instructions:

a. Click on an empty cell in the formula field or create a new formula field.

b. Enter the formula: LEFT({Text Field}, Number)

c. Replace {Text Field} and Number with your desired inputs.

7. RIGHT Function

Formula: RIGHT(string, number)

This formula extracts the rightmost characters from a text string.

Step-by-step instructions:

a. Click on an empty cell in the formula field or create a new formula field./

b. Enter the formula: RIGHT({Text Field}, Number)

c. Replace {Text Field} and Number with your desired inputs.

8. UPPER & 9. LOWER Functions

Formula: UPPER(string) / LOWER(string)

These formulas convert text to uppercase (UPPER) or lowercase (LOWER).

Step-by-step instructions:

a. Click on an empty cell in the formula field or create a new formula field.

b. Enter the formula: UPPER({Text Field}) or LOWER({Text Field

10. LEN: Return the length of a text string

For example, if you have a field called "Email Address" and you want to validate that it's over a certain length:

=LEN({Email Address}) > 10
‍