Formulas allow you to create custom calculations in any table—ranging from simple math to complex logic. These calculations update automatically, based on other fields in your base.
Formula fields will feel familiar to you if you’ve spent a lot of time in Excel, Google Sheets, or other spreadsheet applications(though the technical underpinnings work slightly differently).
Formula fields use both operators (think your basic mathematical symbols like + or *) and functions (more advanced calculations, such as parsing dates and times, figuring out averages, and rounding).
The formula field supports 98 different functions and operators—and there are almost boundless possibilities for how you can use them.
Here are a few examples of how teams use formulas to create more efficient workflows:
Use numerical operators and functions to calculate remaining budget based on individual line items, using multiplication and division.
Use text operators to combine the text from multiple fields.
Use logical operators to compare field values, and auto-generate a status.
Use date and time functions to figure out how many days until a project is due.
Want to see all supported formulas?
Explore them all here
Let's explore three popular function-based formulas, so you can start using them in your workflow right away.
The concatenate function allows you to combine multiple instances of text into a single, unique output.
If you had gathered the first and last names of survey respondents in separate fields, you could use the concatenate function to combine them.
The CONCATENATE() function is frequently used for populating the primary fields, since it allows you to easily create unique identifiers. We even use it to track production for writing each article for these guides!
The IF function compares two fields, and creates an output based on what they contain.
If you’re tracking your company’s invoicing, you can set up an IF command to mark an invoice as “paid” if it has a recorded payment date. However, if no record payment date has been logged, the output would be marked as “unpaid.”
The DATETIME_DIFF function is best for when you want to compare dates tracked across multiple fields in your table.
If you need to calculate the time between when something is assigned and when it’s due, or how long you have until starting the next project, DATETIME_DIFF() can calculate that for you.
Now that you’re familiar with using advanced formulas in Airtable, it’s your turn!
To get started, decide which function best suits your needs—do you need to make calculations based on dates? Combine text fields? Create a logic argument based on how a field is populated?
Add a new formula field, and use the function that works best for you.