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.
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.
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"
