Support
Airtable Support
Learning and resources
Guides
Formula foundations
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