Airtable formula generator
Describe the result you want and get an Airtable formula you can paste into a formula field.
| {First Name} | {Last Name} | fx Formula output |
|---|---|---|
| Alex Morgan |
Tip: Paste this formula into a Formula field in your Airtable table.
How to use this tool
Airtable formulas calculate values across fields in the same record. This generator helps you assemble syntactically correct formulas for text manipulation, date intervals, conditional branching, and math without writing code by hand.
Choose from Text, Date, Logic, or Math. Then pick your desired function (like CONCATENATE, DATEADD, or IF) from the dropdown.
Type your actual Airtable column names (e.g., 'Status' or 'Due Date'). The generator automatically adds curly braces {Field Name} and formats text arguments with proper quotes.
Review the simulated table record below the formula code. You can test sample values directly inside the preview cells to confirm the formula evaluates as expected.
Click 'Copy formula'. In your Airtable base, add a new field, set the type to 'Formula', and paste the generated formula directly into the formula box.
Pro tips for writing Airtable formulas
- Field names with spaces or special characters must always be enclosed in curly braces like {First Name}. Single-word field names don't strictly require them, but keeping braces everywhere prevents accidental errors.
- Literal text strings in formulas must be wrapped in double quotes (e.g., "Active"), while field references use braces.
- Airtable does NOT have an ISBLANK() function. To test if a field is empty, use {Field} = BLANK() or wrap the field in IF({Field}, 'Has Data', 'Empty').
- To avoid division by zero errors (#ERROR!), always check whether your denominator is greater than zero before dividing.
Popular formula examples
CONCATENATE({First Name}, " ", {Last Name})Joins two text fields with a space separator between them.
DATETIME_DIFF({Deadline}, TODAY(), "days")Calculates remaining days between today's date and a project target date.
DATEADD({Start Date}, 7, "days")Calculates a due date by adding a 7-day offset to an existing date field.
IF({Status} = "Done", "✓ Complete", "○ In Progress")Displays custom labels and emoji indicators based on whether a status field is complete.
SWITCH({Priority}, "High", "🔴 Urgent", "Medium", "🟡 Normal", "🟢 Low")Cleaner alternative to nested IF statements when checking a single field against multiple values.
IF({Total} > 0, ROUND(({Completed} / {Total}) * 100, 1) & "%", "0%")Calculates completion percentage safely while preventing division-by-zero errors.
Frequently asked questions
The most common causes of #ERROR! are misspelled field names, missing curly braces {} around column names with spaces, dividing by zero, or passing text data into functions that require numbers or dates.
No. Unlike Microsoft Excel or Google Sheets, Airtable does not have an ISBLANK() function. In Airtable, use {Field} = BLANK() or IF({Field}, 'Filled', 'Empty').
Yes, you can nest IF statements like IF(cond1, val1, IF(cond2, val2, default)). However, if you are checking one field against multiple known values, the SWITCH() function is much cleaner and easier to read.
Use the DATETIME_FORMAT({Date Field}, 'format') function. Common format strings include 'YYYY-MM-DD', 'MM/DD/YYYY', and 'MMMM D, YYYY'.
Function names (like IF, CONCATENATE, DATEADD) are case-insensitive, but field names inside curly braces {} and text comparisons (e.g. {Status} = 'Done') are case-sensitive.