Gallery
Multiple Choice Quiz: Airtable Formula Functions
Share
Explore
Data Tables

Subject Data

Subject Data
1
Function or Operator
Description
Type
Groups
1
>
Greater than
operator
Logical
2
<
Less than
operator
Logical
3
>=
Great than or equal
operator
Logical
4
<=
Less than or equal
operator
Logical
5
=
Equal
operator
Logical
6
!=
Is not equal to
operator
Logical
7
+
Add
operator
Numeric
8
-
Subtract
operator
Numeric
9
*
Multiply
operator
Numeric
10
/
Divide
operator
Numeric
11
&
Concatenate text values
operator
Text
12
ARRAYJOIN()
Join the array of items into a string with a separator.
function
Text
13
CONCATENATE()
Joins together the text arguments into a single text value. To concatenate static text, surround it with double quotation marks. To concatenate double quotation marks, you need to use a backslash (\) as an escape character.
function
Text
14
ENCODE_URL_COMPONENT()
Replaces certain characters with encoded equivalents for use in constructing URLs or URIs. Does not encode the following characters: - _ . ~
function
Text
15
FIND()
Finds an occurrence of one string inside another.
function
Text
16
LEFT()
Extract howMany characters from the beginning of the string.
function
Text
17
LEN()
Returns the length of a string.
function
Text
18
LOWER()
Makes a string lowercase.
function
Text
19
MID()
Extract a substring of count characters starting at whereToStart.
function
Text
20
REPLACE()
Replaces the number of characters beginning with the start character with the replacement text.
function
Text
21
REPT()
Repeats string by the specified number of times.
function
Text
22
RIGHT()
Extract howMany characters from the end of the string.
function
Text
23
SEARCH()
Searches for an occurrence of one string inside another.
function
Text
24
SUBSTITUTE()
Replaces occurrences of old_text with new_text.
function
Text
25
T()
Returns the argument if it is text and blank otherwise.
function
Text
26
TRIM()
Removes whitespace at the beginning and end of string.
function
Text
27
UPPER()
Makes string uppercase.
function
Text
28
AND()
Returns true if all the arguments are true, returns false otherwise.
function
Logical
29
BLANK()
Returns a blank value.
function
Logical
30
ERROR()
Returns the error value.
function
Logical
31
FALSE()
Logical value false. False is represented numerically by a 0.
function
Logical
32
IF()
Returns value1 if the logical expression is true, otherwise it returns value2.
function
Logical
33
ISERROR()
Returns true if the expression causes an error.
function
Logical
34
NOT()
Reverses the logical value of its argument.
function
Logical
35
OR()
Returns true if any one of the arguments is true.
function
Logical
36
SWITCH()
Converts values into new values. For each original value, it matches the other value to use. Mapping
function
Logical
37
TRUE()
Logical value true. The value of true is represented numerically by a 1.
function
Logical
38
XOR()
Returns true if an odd number of arguments are true.
function
Logical
39
ABS()
Returns the absolute value.
function
Numeric
40
AVERAGE()
Returns the average of the numbers.
function
Numeric
41
CEILING()
Always rounds up to next place value determined by user. Defaults precision to 1
function
Numeric
42
COUNT()
Count the number of numeric items.
function
Numeric
43
COUNTA()
Count the number of non-empty values. This function counts both numeric and text values.
function
Numeric
44
COUNTALL()
Count the number of all elements including text and blanks.
function
Numeric
45
EVEN()
Returns the smallest even integer that is greater than or equal to the specified value.
function
Numeric
46
EXP()
Computes Euler's number (e) to the specified power.
function
Numeric
47
FLOOR()
Always rounds number down to place value indicated by user. Defaults precision to 1.
function
Numeric
48
INT()
Returns the greatest integer that is less than or equal to the specified value.
function
Numeric
49
LOG()
Computes the logarithm of the value in provided base. The base defaults to 10 if not specified.
function
Numeric
50
MAX()
Returns the largest of the given numbers.
function
Numeric
51
MIN()
Returns the smallest of the given numbers.
function
Numeric
52
MOD()
Returns the remainder after dividing the first argument by the second.
function
Numeric
53
ODD()
Rounds positive value up the the nearest odd number and negative value down to the nearest odd number.
function
Numeric
54
POWER()
Computes the specified base to the specified power.
function
Numeric
55
ROUND()
Rounds the value to the number of decimal places given by "precision.".
function
Numeric
56
ROUNDDOWN()
Rounds the value to the number of decimal places given by "precision," down. MUST add precision
function
Numeric
57
ROUNDUP()
Rounds the value to the number of decimal places given by "precision," always rounding up, MUST add precision
function
Numeric
58
SQRT()
Returns the square root of a nonnegative number.
function
Numeric
59
SUM()
Sum together the numbers. Equivalent to number1 + number2 + ...
function
Numeric
60
VALUE()
Converts the text string to a number. If string has non numeric characters, result may not be as expected.
function
Numeric
61
CREATED_TIME()
Returns the date and time a given record was created.
function
Date/Time
62
DATEADD()
Adds specified "count" units to a datetime. Specify units (months, days, years etc.)
function
Date/Time
63
DATESTR()
Formats a datetime into a string (YYYY-MM-DD).
function
Date/Time
64
DATETIME_DIFF()
Returns the difference between datetimes in specified units.
function
Date/Time
65
DATETIME_FORMAT()
Formats a datetime into a specified string.
function
Date/Time
66
DATETIME_PARSE()
Turns text string into date object.
function
Date/Time
67
DAY()
Returns the day of the month of a datetime in the form of a number between 1-31.
function
Date/Time
68
HOUR()
Returns the hour of a datetime as a number between 0 (12:00am) and 23 (11:00pm).
function
Date/Time
69
IS_AFTER()
Determines if [date1] is later than [date2]. Returns 1 if yes, 0 if no.
function
Date/Time
70
IS_BEFORE()
Determines if [date1] is earlier than [date2]. Returns 1 if yes, 0 if no.
function
Date/Time
71
IS_SAME()
Compares two dates up to a unit and determines whether they are identical. Returns 1 if yes, 0 if no.
function
Date/Time
72
LAST_MODIFIED_TIME()
Returns date and time of most recent modification to a non computed field in the record
function
Date/Time
73
MINUTE()
Returns the minute of a datetime as an integer between 0 and 59.
function
Date/Time
74
MONTH()
Returns the month of a datetime as a number between 1 (January) and 12 (December).
function
Date/Time
75
NOW()
Returns the current date AND time. NOT updated regularly
function
Date/Time
76
SECOND()
Returns the second of a datetime as an integer between 0 and 59.
function
Date/Time
77
SET_LOCALE()
Sets a specific locale for a datetime. Must be used in conjunction with DATETIME_FORMAT.
function
Date/Time
78
SET_TIMEZONE()
Sets a specific timezone for a datetime. Must be used in conjunction with DATETIME_FORMAT.
function
Date/Time
79
TIMESTR()
Formats a datetime into a time-only string (HH:mm:ss).
function
Date/Time
80
FROMNOW()
Calculates the length of time between given date and now
function
Date/Time
81
TONOW()
Calculates the length of time between given date and now
function
Date/Time
82
TODAY()
Returns the current date with the time of 12:00am GMT. Not updated regularly.
function
Date/Time
83
WEEKDAY()
Returns the day of the week as an integer between 0 and 6.
function
Date/Time
84
WEEKNUM()
Returns the week number in a year.
function
Date/Time
85
WORKDAY()
Returns a date that is numDays working days after startDate.
function
Date/Time
86
WORKDAY_DIFF()
Counts the number of working days between startDate and endDate.
function
Date/Time
87
YEAR()
Returns the four-digit year of a datetime.
function
Date/Time
88
ARRAYCOMPACT()
Removes empty strings and null values from the array. Keeps "false" and strings that contain one or more blank characters.
function
Array
89
ARRAYFLATTEN()
Flattens the array by removing any array nesting. All items become elements of a single array.
function
Array
90
ARRAYJOIN()
Join the array of rollup items into a string with a separator.
function
Array
91
ARRAYUNIQUE()
Returns only unique items in the array.
function
Array
92
CREATED_TIME()
Returns the creation time of the current record.
function
Record
93
RECORD_ID()
Returns the ID of the current record.
function
Record
94
REGEX_MATCH()
Returns whether the input text matches a regular expression.
function
RegEx
Text
95
REGEX_EXTRACT()
Returns the first substring that matches a regular expression.
function
RegEx
Text
96
REGEX_REPLACE()
Substitutes all matching substrings with a replacement string value.
function
RegEx
Text
There are no rows in this table


Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.