Formula foundations – Airtable Support

Formula foundations

A guided course to help you learn Airtable formulas

Getting started with formulas

The essentials of Airtable formulas

Writing formulas in Excel vs Airtable

Formula terminology

Formula writing tips for beginners

Troubleshooting formulas

Common formula errors and how to fix them

Basic calculations

Using logical operators to compare field values

Basic calculations using the formula field

Conditional statements

How to write nested IF statements

Conditional formulas with emoji

Comparing text strings using IF statements

Comparing numeric values using IF

Compare dates using conditional statements

Logical arguments

An alternative to IF statements using SWITCH()

Evaluate arguments using AND() and OR()

Identifying blank values

True and false arguments

Catching errors with logical functions

See all 6 articles

Working with dates

Formulas and date fields

Working with date functions

Calculate the difference between two dates

Supported unit specifiers for DATETIME_DIFF

Supported format specifiers for DATETIME_FORMAT

See all 6 articles

Working with timezones

Timezones and locales

Supported timezones for SET_TIMEZONE

Supported locale modifiers for SET_LOCALE

Record functions

Returning record data

Applications of record functions

Text functions

Guide to REGEX() functions

Joining field values

Changing the look of a text string

Extracting text from a field

Finding and replacing text

See all 6 articles

Numeric functions

Basics of numeric functions