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.

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 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 ExampleSum

Description

Example

Notes

Calculate the sum of a series of numbers.

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

Copy ExampleEmpty cells are counted as zeros.

Divide

Average

Description

Example

Notes

Calculate the average of a series of numbers.

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

Copy ExampleEmpty cells are counted as zeros.

Min

Description

Example

Notes

Find the smallest number in a list.

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

Copy ExampleEmpty cells are counted as zeros.

Max

Description

Example

Notes

Find the largest number in a list.

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

Copy ExampleEmpty cells are counted as zeros.

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.

ADD_DAYS

Description

Example

Notes

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_WORKDAYS

Description

Example

Notes

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.

TODAY

DATE

Description

Example

Notes

Create a date based on year, month, and day values.

DATE(2022, 5, 10)

Copy ExampleDAYS

Description

Example

Notes

Calculate the number of days between two dates.

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

Copy ExampleWORKDAYS

Description

Example

Notes

Calculate the number of working days between two dates.

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

Copy ExampleTIMELINE

Description

Example

Notes

Create a timeline between two dates.

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

Copy ExampleThe timeline can be used in other functions.

MONTH

END

Description

Example

Notes

Get the end date of a timeline.

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

Copy ExampleSTART

CONCATENATE

Description

Example

Notes

Concatenate multiple text strings into one.

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

Copy ExampleCOUNT

Description

Example

Notes

Count the number of numerical values.

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

Copy ExampleIF (Value to check Condition Value to compare,

Value 1, Value 2)

RIGHT

Description

Example

Notes

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)

LEFT

Description

Example

Notes

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

LEFT(“Hello world”, 5)

Copy ExampleSEARCH

Description

Example

Notes

Search for a substring in a text string and return its position.

SEARCH(“world”, “Hello world”)

Copy ExampleLEN

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.

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"

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

Connected Boards

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Mirror - Date (Connected to a single board)

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Date

Date, Text

Mirror - Text (Connected to a single board)

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Text, Status

Text, Status

Mirror - People (Connected to a single board)

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

People

People, Text

Mirror - Email (Connected to a single board)

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Text

Mirror - Status (Connected to a single board)

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Status, Text

Status, Text

Mirror - Timeline (Connected to a single board)

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Timeline

Timeline

Mirror - Item ID(Connected to a single board)

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

Phone

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?

Formula

Via a Formula recipe

Via Copy recipe

What can I put in?

Where can I copy this value?