Support
Airtable - Support
Fields
Formulas
Formulas
Getting started with formulas
Formula field reference
Formulas vs other computed fields
Array functions
Formula field overview
Formula writing tips for beginners
See all 8 articles
Basic calculations
Using logical operators to compare field values
Basic calculations using the formula field
Conditional statements
Compare dates using conditional statements
Comparing numeric values using IF
How to write nested IF statements
Conditional formulas with emoji
Comparing text strings using IF statements
Logical arguments
An alternative to IF statements using SWITCH()
Working with dates
Using DATETIME_PARSE() formula
Calculate the difference between two dates
Formulas and date fields
Supported format specifiers for DATETIME_FORMAT
Supported unit specifiers for DATETIME_DIFF
Working with timezones
Supported timezones for SET_TIMEZONE
Supported locale modifiers for SET_LOCALE
Common solutions: beginner
Convert a serial date from Excel to a readable date
Extract the file name from attachments
Convert unix / epoch time to current date
Using a formula in the primary field
Using checkbox fields in formulas
Common solutions: intermediate
Find the sum of an entire field
Word and character counts
How can I count the number of linked records in a linked record field (column)?
Can I use a formula to count the number of selected options in a multi-select field?
Common solutions: advanced
How to conditionally display missing field values
Add a line break using \n
Build a custom form URL filler using ENCODE_URL_COMPONENT
Displaying quarters in a fiscal year