to manage your data most efficiently

Choose your board

Choose your recipe

Choose your formula

**You can now - **

Set the result of a formula column into a native column. Watch the demo

Configure recipes and trigger them on daily basis (Every time period). Watch the demo

Connect a high-level board to multiple other boards and mirror information across them. Watch the demo

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.

If

Description

Example

Notes

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 dates, use: <, >, =, !=

To compare text, use: IS, IS_NOT

Note: You must have an else option

Minus

Description

Example

Notes

Subtracts the second number from the first one.

MINUS({Column 1}, {Column 2})

Copy ExampleInputs: 2 numbers

Output: a number

Sum

Description

Example

Notes

Calculate the sum of a series of numbers.

SUM({Column 1}, {Column 2})

Copy ExampleEmpty cells are counted as zeros.

Inputs are numbers. You can add as many numbers as you want.

Divide

Description

Example

Notes

Divide number 1 by number 2

DIVIDE({Column Number 1}, {Column Number 2})

Copy ExampleInputs: 2 numbers

Output: a number

Average

Description

Example

Notes

Calculate the average of a series of numbers.

AVERAGE({Column 1}, {Column 2})

Copy ExampleEmpty cells are counted as zeros.

Inputs are numbers. You can add as many numbers as you want.

Min

Description

Example

Notes

Find the smallest number in a list.

MIN({Column 1}, {Column 2})

Copy ExampleEmpty cells are counted as zeros.

Inputs are numbers. You can add as many numbers as you want.

Max

Description

Example

Notes

Find the largest number in a list.

MAX({Column 1}, {Column 2})

Copy ExampleEmpty cells are counted as zeros.

Inputs are numbers. You can add as many numbers as you want.

Power

Multiply

Has_Value

Description

Example

Notes

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.

To use it in a formula you should add the IF function.

ADD_DAYS

Description

Example

Notes

Push a date by a number of days.

ADD_DAYS({Column 1}, 7)

Copy ExampleInput is a date or timeline, and a number.

Output is a date or timeline (dependent on the input)

The number can be negative to subtract days.

TODAY

DAYS

Description

Example

Notes

Calculate the number of days between two dates.

DAYS({Column 1}, {Column 2})

Copy ExampleInput: Column 1 is the start date, and Column 2 is the end date.

Output: a number.

TIMELINE

Description

Example

Notes

Create a timeline between two dates.

TIMELINE({Column date 1}, {Column date 2})

Copy ExampleThe start date is {Column date 1}, and the end date is {Column date 2}.

MONTH

Description

Example

Notes

Get the month number of a date.

MONTH({Column 1})

Copy ExampleInput: a date column

Output: a number.

END

Description

Example

Notes

Get the end date of a timeline.

END({Timeline Column})

Copy ExampleInput: a timeline column.

Output: The end date of the timeline.

START

Description

Example

Notes

Get the start date of a timeline.

START({item's timeline})

Copy ExampleInput: a timeline column.

Output: The start date of the timeline.

CONCATENATE

Description

Example

Notes

Concatenate multiple text strings into one.

CONCATENATE(“Hello”, “ ”, {Column 1})

Copy ExampleInputs: Text.

You can concatenate as many texts as you want.

COUNT

Description

Example

Notes

Count the number of numerical values.

COUNT({Column 1}, {Column 2})

Copy ExampleInputs: columns

You can add as many columns as you want.

Output: The number of numbers columns that contains a value.

RIGHT

Description

Example

Notes

Get a specified number of characters from the right side of a text string.

RIGHT(“Hello world”, 5)

Copy ExampleInputs: text and a number

Output: text

LEFT

Description

Example

Notes

Get a specified number of characters from the left side of a text string.

LEFT(“Hello world”, 5)

Copy ExampleInputs: text and a number

Output: text

SEARCH

Description

Example

Notes

Search for a substring in a text string and return true or false.

SEARCH("text to search", "text")

Copy ExampleInput: 2 texts

Output: Number.

Returns the first index of the text to search within the text if it exists, otherwise returns 0.

LEN

Description

Example

Notes

Get the number of characters in a text string.

LEN({Column 1})

Copy ExampleInput: Text

Output: Number

AND

Description

Example

Notes

Checks if all the given logical confitions are true and if so returns true

IF(AND(1 > 0, 3 > 1), “True”, “False”)

Copy ExampleMust be used inside an IF statement

OR

Description

Example

Notes

Checks if one of the given logical confitions are true and if so returns true

IF(OR(1 > 0, 1 > 2),”True”, “False”)

Copy ExampleMust be used inside an IF statement

UNIQUE

Description

Example

Notes

Takes a list of values and returns only the unique occurrences

UNIQUE(1, 1, 2, 3, 3, 4)

Copy ExampleSUBSTITUTE

Description

Example

Notes

Replace text in a given text string by matching

SUBSTITUTE(“Autoboost”, “boost”, “boosting”)

Copy ExampleROUNDUP

ROUNDDOWN

YEAR

SWITCH

Description

Example

Notes

Checks if a condition a specific value is met, if so, returns the result of that value

SWITCH({Column 1}, “High”, 3, “Medium”, 2, “Low”, 1, 0)

Copy ExampleA default value is required

SUBTRACT_DAYS

TRIM

Description

Example

Notes

Removes all spaces from a string except for single spaces between words

TRIM(“ I love Autoboost ”)

Copy ExampleUPPER

LOWER

WEEKNUM

Description

Example

Notes

Returns the yearly week number of a given date

WEEKNUM({Column 1})

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.

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.

You should replace them with your columns by clicking the name of the column at the bottom of the formula window.

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.

1

Write **[subitem.column ID]** in the formula window.

2

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.

3

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"

Mirror columns can now be utilized also when connected to multiple boards!

Item Name

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Text, Date, Status, Free text, Number

Text

Text

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Text, Status, Number, Free text, Date, Email, Dropdown, Number, People, Link

Text, Status

Long Text

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Status

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Text, Status, Number, Free text

Text, Status

Number

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Number

Number, Text

Date

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Date

Date, Text

Timeline

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Timeline

Timeline

People

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

People

People, Text

Email

Via a Formula recipe

Via Copy recipe

What columns can I put in?

What columns can I put in?

Text, People

Link

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Text

Tag

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Text

Connected Boards

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Mirror - Date

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Date

Date, Text

Mirror - Text

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Text, Status

Text, Status

Mirror - People

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

People

People, Text

Mirror - Email

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Text

Mirror - Status

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Status, Text

Status, Text

Mirror - Timeline

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Timeline

Timeline

Mirror - Item ID

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Text, Number

Dropdown

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Text

Item ID

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Text, Number

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Oops! Something went wrong while submitting the form.

Wait for 5 seconds