Airtable Formula Basics: Getting Started Guide
2026-03-18
Basic Math
Airtable formulas reference fields with curly braces. Multiply price by quantity:
{Price} * {Quantity}Conditional Logic
Use IF to set status based on a value:
IF({Amount} > 1000, "High Value", "Standard")Combine Text Fields
Join first name and last name:
CONCATENATE({First Name}, " ", {Last Name})Date Calculation
Add 30 days to a date field:
DATEADD({Start Date}, 30, 'days')Rounding Numbers
Round a calculated value to 2 decimal places:
ROUND({Price} * {Quantity} * 1.085, 2)Generate formulas instantly
Describe what you need in plain English. Get the formula for Excel, Google Sheets, or Airtable.
Try FormulaWiz Free