Airtable Formula Tester
Test and validate Airtable formula syntax with a built-in function reference
Example Formulas
Full name from first and last
CONCATENATE({First Name}, ' ', {Last Name})Days until deadline
DATETIME_DIFF({Deadline}, TODAY(), 'days')Status check with IF
IF({Status} = 'Done', 'Complete', 'In Progress')Uppercase email domain
UPPER(MID({Email}, FIND('@', {Email}) + 1, LEN({Email})))Round to 2 decimal places
ROUND({Amount} * 1.08, 2)Year from date field
YEAR({Created Date})Combined error check
IF(ISERROR({Field}), 'Error', {Field})Months between two dates
DATETIME_DIFF({End Date}, {Start Date}, 'months')Function Reference
Text
CONCATENATECONCATENATE(text1, [text2, ...])Joins several text strings into one string.
FINDFIND(stringToFind, whereToSearch, [startFromPosition])Finds an occurrence of a string within another string.
LEFTLEFT(string, howMany)Returns specified number of characters from the start of a string.
LENLEN(string)Returns the length of a string.
LOWERLOWER(string)Converts all characters to lowercase.
MIDMID(string, whereToStart, count)Returns the middle portion of a string.
REPLACEREPLACE(string, startCharacter, numberOfCharacters, replacement)Replaces part of a string with a different string.
RIGHTRIGHT(string, howMany)Returns specified number of characters from the end of a string.
SUBSTITUTESUBSTITUTE(string, oldText, newText, [index])Replaces occurrences of a substring within a string.
TRIMTRIM(string)Removes leading and trailing whitespace from a string.
UPPERUPPER(string)Converts all characters to uppercase.
Numeric
ABSABS(number)Returns the absolute value of a number.
AVERAGEAVERAGE(number1, [number2, ...])Returns the average of the numbers.
CEILINGCEILING(number, [significance])Rounds a number up to the nearest multiple of significance.
COUNTCOUNT(number1, [number2, ...])Returns the count of numeric items.
FLOORFLOOR(number, [significance])Rounds a number down to the nearest multiple of significance.
INTINT(number)Returns the integer part of a number.
MAXMAX(number1, [number2, ...])Returns the largest of the given numbers.
MINMIN(number1, [number2, ...])Returns the smallest of the given numbers.
MODMOD(number, divisor)Returns the remainder of a number divided by a divisor.
POWERPOWER(base, exponent)Returns the result of raising the base to the given power.
ROUNDROUND(number, [precision])Rounds a number to the given precision.
SQRTSQRT(number)Returns the square root of a number.
SUMSUM(number1, [number2, ...])Sums the given numbers.
Date
CREATED_TIMECREATED_TIME()Returns the date and time a record was created.
DATE_FORMATDATE_FORMAT(date, format)Formats a date according to the given format string.
DATEADDDATEADD(date, number, units)Adds specified units to a date.
DATETIME_DIFFDATETIME_DIFF(date1, date2, units)Returns the difference between two dates in the given units.
DATETIME_FORMATDATETIME_FORMAT(date, [format])Formats a datetime to a string.
NOWNOW()Returns the current date and time.
TODAYTODAY()Returns the current date.
YEARYEAR(date)Returns the year portion of a date.
MONTHMONTH(date)Returns the month portion of a date (1–12).
DAYDAY(date)Returns the day portion of a date (1–31).
Logical
ANDAND(expr1, [expr2, ...])Returns true if all of the expressions are true.
IFIF(condition, valueIfTrue, valueIfFalse)Returns one of two values depending on whether the condition is true or false.
ISERRORISERROR(expr)Returns true if the expression produces an error.
NOTNOT(expr)Reverses the boolean value of an expression.
OROR(expr1, [expr2, ...])Returns true if at least one of the expressions is true.
SWITCHSWITCH(expr, [pattern, result, ...], [default])Evaluates an expression against a list of patterns and returns a matching result.
Record
RECORD_IDRECORD_ID()Returns the ID of the current record.
LOOKUPLOOKUP(linkedRecordField, fieldInLinkedRecord)Looks up values from a linked record field.
ROLLUPROLLUP(linkedRecordField, aggregation)Aggregates values from a linked record field.
Array
ARRAY_JOINARRAY_JOIN(array, [separator])Joins array values into a string with an optional separator.
ARRAY_UNIQUEARRAY_UNIQUE(array)Returns unique values from an array.