Who can use this feature?
ðŸ‘¤ Available on all plans.
Formulas let you transform and combine existing fields into a new Formula field. For example, you can:
 Concatenate
First name
andLast name
fields into aFull name
Formula field.  Multiply
Price
andUnits
field to get the result in theRevenue
Formula field.
The field will show only in your Stacker app, and won't show up in your Airtable base or Google Sheets.
Create a formula field
 Go to Manage Fields and data > [Table name] > Fields
 Click Add field > Formula
 Type in your formula
 Click Save
Press space in the formula field box to see a list of all available fields and functions.
Fields in formulas
To use a field in a formula, the field needs to be in the table where you're creating the formula field. It also needs to be one of the following data types:
 Text
 Long Text
 Number
 Checkbox
 URL
 Single Select Dropdown
 Percentage
 Currency
 Rich Text
 Date
 Date and Time
 Multiple Select Dropdown
To use a field in a formula, you will need to wrap it in curly brackets. For example, {Price}. If you type in the opening curly bracket, we will suggest all available fields.
List of formulas
Functions work with any valid field data types, while operators work only on number fields. If you use an operator for a nonnumber field, we will try to convert it into a number. If we can't, you'll see an error message.
Type  Name  Description  Syntax  Examples 
Operator  SUM 
Returns the sum of two or more numbers. 
or 
or

Operator  Subtract 
Returns the difference of two numbers. 
 
{Total stock}  {Sold stock} 
Operator  Multiply 
Returns the product of two numbers. 
* 
{Sold} * {Price} 
Operator  Divide 
Returns one number divided by another. 
/ 
{Total sold} / {Price} 
Operator  Average 
Returns the average of the values in two or more fields. 
AVERAGE( , ) 
AVERAGE({Sold},{Not sold}) 
Operator  Not equal to 
Check if one value is not equal to another value. 
!= 

Operator  Equal to 
Compare if one value is equal to another value. 
= 

Operator  Greater than 
Compare if one value is greater than another value. 
> 

Operator  Less than 
Compare if one value is less than another value. 
< 

Operator  Less than or equal to 
Compare if one value is less than, or equal to, another value. 
<= 

Operator  Greater than or equal to 
Compare if one value is greater than, or equal to, another value. 
>= 

Function  CONCAT  Concatenate two values. 
or 
or 
Function  Condition 
Check whether the statement is true. If it is true, then do Action A. If it is false, then do Action B. 
IF(statement, Action A, Action B) 
IF({UserId}, "https://dashboard.com/" + {UserId}, "") 
Function  Expression 
Returns true if all the arguments are true, returns false otherwise. 
AND() 
or 
Function  Expression 
Returns true if any one of the arguments is true. 
OR() 
or 
Function  Expression 
Reverses a true to false. 
NOT() 

Function  string 
Returns the length of a string. 
LEN 

Function  string, regex 
Returns whether the input text matches a regular expression. 
REGEX_MATCH() 

Function  string, regex, replacement 
Substitutes all matching substrings with a replacement string value. 
REGEX_REPLACE() 

Function  string, regex 
Returns the first substring that matches a regular expression. 
REGEX_EXTRACT() 

Function  string 
Removes whitespace at the beginning and end of string. 
TRIM() 

Function  string 
Makes string uppercase. 
UPPER() 

Function  string 
Makes a string lowercase. 
LOWER() 

Function  string, howMany 
Extract howMany characters from the end of the string. 
RIGHT() 

Function 
Compares two dates up to a unit and determines whether they are identical. Returns 1 if yes, 0 if no. 
IS_SAME() 


Function 
Determines if [date1] is earlier than [date2]. Returns 1 if yes, 0 if no. 
IS_BEFORE() 


Function 
Determines if [date1] is later than [date2]. Returns 1 if yes, 0 if no. 
IS_AFTER() 


Function 
Returns the fourdigit year of a datetime. 
YEAR() 


Function 
Returns the month of a datetime as a number between 1 (January) and 12 (December). 
MONTH() 


Function 
Returns the day of the month of a datetime in the form of a number between 131. 
DAY() 


Function 
Returns the hour of a datetime as a number between 0 (12:00am) and 23 (11:00pm). 
HOUR() 


Function 
Returns the minute if datetime as a number. 
MINUTE() 


Function 
Extract how many characters from the beginning of the string. 
LEFT() 


Function 
Calculates the number of the specified periods between two datetime values. 
DATEDIF() 


Function 
Returns the item with the lowest value, or the item with the lowest value in an iterable. 
MIN() 


Function 
Returns the largest item in an iterable. It can also be used to find the largest item between two or more parameters. 
MAX() 


Function 
Returns the absolute value of the given number. If the number is a complex number, abs() returns its magnitude. 
ABS() 


Function 
Adds a time/date interval to a date and then returns the date. 
DATEADD() 


Function 
Returns the current date, but not the current time. 
TODAY(timezone) 


Function 
Returns the current date and time. 
NOW() 


Function 
Returns the string of relative time to now 
TONOW() 


Function 
Rounds to a number of decimal places as specified by precision. E.g. "0", "1", etc 
ROUND(number,precision) 


Function 
Converts text string to a number. 
VALUE(string) 


Function 
Rounds the value to the number of decimal places given by "precision," always rounding up. E.g. "0", "1", etc 
ROUNDUP(number,precision) 

Error messages
If a formula is invalid, you will see an error message that might help you understand what went wrong.
Error  Meaning 
Missing formula function or Unexpected formula function 
Means that you were very creative, but we don't have the formula function yet. 
Function only works with field_type but field is a another_field_type 
Shows when using a field with an incompatible field type. 
In an IF function, field_name and field_name_2 must be of similar
types 
Shows in an IF function when the Action A and Action B are different types. 
Missing keys in formula 'IF' function: else 
Means that there is a missing else (Action B) in the IF function. 