to manage your data most efficiently
Choose your board
Choose your recipe
Choose your formula
Examples on this page include column references (e.g. {item's Status}).
You should replace them with your columns by clicking the name of the column at the bottom of the formula window.
Check if a condition is met. If so, return the first value; otherwise, return the second value.
IF({Column 1} > 5, “Greater than 5“, “Less than or equal to 5“)
Copy ExampleThe condition must be a logical statement that evaluates to true or false.
To compare numbers, use: <, >, =, !=
To compare text, use: IS, IS_NOT
Note: You must have an else option
Subtracts the second number from the first one.
MINUS({Column 1}, {Column 2})
Copy ExampleCalculate the sum of a series of numbers.
SUM({Column 1}, {Column 2})
Copy ExampleEmpty cells are counted as zeros.
Calculate the average of a series of numbers.
AVERAGE({Column 1}, {Column 2})
Copy ExampleEmpty cells are counted as zeros.
Find the smallest number in a list.
MIN({Column 1}, {Column 2})
Copy ExampleEmpty cells are counted as zeros.
Find the largest number in a list.
MAX({Column 1}, {Column 2})
Copy ExampleEmpty cells are counted as zeros.
Check if a column has any values.
HAS_VALUE({Column 1})
Copy ExampleReturns "True" or "False" depending on whether a column has any values in it.
Push a date by a number of days.
ADD_DAYS({Column 1}, 7)
Copy ExampleOutputted into date or timeline.
The number can be negative to subtract days.
Add a specified number of working days to a date.
ADD_WORKDAYS({Column 1}, 5)
Copy ExampleOutputted into date or timeline.
The number can be negative to subtract days.
Create a date based on year, month, and day values.
DATE(2022, 5, 10)
Copy ExampleCalculate the number of days between two dates.
DAYS({Column 1}, {Column 2})
Copy ExampleCalculate the number of working days between two dates.
WORKDAYS({Column 1}, {Column 2})
Copy ExampleCreate a timeline between two dates.
TIMELINE({Column 1}, {Column 2})
Copy ExampleThe timeline can be used in other functions.
Get the end date of a timeline.
END(TIMELINE({Column 1}, {Column 2}))
Copy ExampleConcatenate multiple text strings into one.
CONCATENATE(“Hello”, “ ”, {Column 1})
Copy ExampleCount the number of numerical values.
COUNT({Column 1}, {Column 2})
Copy ExampleIF (Value to check Condition Value to compare,
Value 1, Value 2)
Get a specified number of characters from the right side of a text string.
RIGHT(“Hello world”, 5)
Copy ExampleIF (Value to check Condition Value to compare,
Value 1, Value 2)
Get a specified number of characters from the left side of a text string.
LEFT(“Hello world”, 5)
Copy ExampleSearch for a substring in a text string and return its position.
SEARCH(“world”, “Hello world”)
Copy ExampleExamples on this page include column references (e.g. {item's Status}).
You should replace them with your columns by clicking the name of the column at the bottom of the formula window.
Recipe: when column changes, apply a formula and set result to column.
Formula: IF(HAS_VALUE({item's file}) IS “True“, “Complete“, “Missing file“)
Note: If the output doesn't exists, the output of HAS_VALUE is “False“
Recipe: when column changes, apply a formula and set result to column.
Formula: SUM({item's number}, {item's number_1}, 100)
Note: To ensure the result is always updated, add two recipes.
In the trigger - when column changes, choose different columns each time.
Recipe: when column changes, apply a formula and set result to item name.
Formula: IF({item’s status} IS “Closed”, CONCATENATE({item's name}, “_”, “closed”),{item's name})
Recipe: when column changes, apply a formula and set result to column.
Formula: CONCATENATE({item's people}, ” is the owner of the task”)
Note: You can concatenate every column that can be converted to text.
Recipe: when column changes, apply a formula and set result to column.
Formula: IF({item’s currency} IS “USD”, MULTIPLY({item’s cost}, 0.29),
MULTIPLY({item’s cost}, 1))
Note: Update the formula when the currency rate changes.
Recipe: when column changes, apply a formula and set the result to column.
Formula: DAYS(END({item’s timeline}), START({item’s timeline}))
Recipe: when mirror column changes, apply a formula and set result to column.
Formula: {item's email_mirror}
Note: Set the result to a text column. All the email automation support text columns.
Recipe: when column changes, apply a formula and set result to column.
Formula: {item's email_as_text}
Note: Store the email in a text column, and set the result to a people column.
Write [subitem.column ID] in the formula window.
How to find subitems column IDs:
- If this is your first time, activate the developer mode in your monday.com account
(See guidelines below).
- Open your monday.com board in another tab.
- Click the three dots next to the column name.
- Copy the column ID.
Open an Autoboost recipe with a formula.
- In the formula window, write [subitem.column ID],
- Replace the "column ID" with the column ID from your board.
Go to your Avatar
Choose monday.labs
Search and activate "Developer mode"
Text, Date, Status, Free text, Number
Text
Text, Status, Number, Free text, Date, Email, Dropdown, Number, People, Link
Text, Status
Text, Status, Number, Free text
Text, Status
Number
Number, Text
Date
Date, Text
Timeline
Timeline
People
People, Text
Text, People
Text
Date
Date, Text
Text, Status
Text, Status
People
People, Text
Text
Status, Text
Status, Text
Timeline
Timeline
Text, Number
Text
Text, Number