Formulas and use cases to solve common problems and get inspiration from

Formulas in this page include standard column references (i.e.

`{item.date}`

).Replace them with the text that appears when you click on the corresponding column button at the bottom of the formula composer.

monday.com recently changed how columns are referred to inside the formula field.

When clicking on column button at the bottom of formula field, the column name is now inserted (i.e.

`{item's Due Date}`

).Old method to refer to columns by ID still works, so you don't need to update your integration if you are using

`{item.date}`

.
From date to date

**Scenario:** when you set a date, set a due date after the number of working days set in another column

**Requirements:** two date columns

**Integration:** When any column changes, perform **formula** and cast result to **column**

**Functions:**

**TEXT:**trasforms a date into`YYYY-MM-DD`

format;**WORKDAY:**adds working days to a date;**DATEVALUE:**converts a column value into a valid date, you can then add or subtract days a simple math operation.

From date to timeline

**Scenario:** when you set a date, set a timeline starting 7 days after and ending 21 days after

**Requirements:** one date column and one timeline column

**Integration:** When **column** changes, perform **formula** and cast result to **column**

**Functions:**

**CONCATENATE:**creates`from_date+to_date`

string accepted by Timeline column;**TEXT:**trasforms a date into`YYYY-MM-DD`

format;**DATEVALUE:**converts a column value into a valid date, you can then add or subtract days a simple math operation.

From timeline to timeline

**Scenario:** when you set a timeline, set another timeline shifted 14 days in the future

**Requirements:** two timeline columns

**Integration:** When **column** changes, perform **formula** and cast result to **column**

**Functions:**

**CONCATENATE:**creates`from_date+to_date`

string accepted by Timeline column;**TEXT:**trasforms a date into`YYYY-MM-DD`

format;**DATEVALUE:**converts a column value into a valid date, you can then add or subtract days a simple math operation.**LEFT:**picks`from_date`

from the`from_date+to_date`

string;**RIGHT:**picks`to_date`

from the`from_date+to_date`

string.

From number to rating

**Scenario:** add a rating based on budget amount

**Requirements:** one number column and one rating column

**Integration:** When **column** changes, perform **formula** and cast result to **column**

**Functions:**

**IF:**if first statement is true, returns second value, third otherwise.

From status to email

**Scenario:** set a clickable email address based on item's status

**Requirements:** one status column with "Tim" and "Jeff" values and one email column

**Integration:** When **column** changes, perform **formula** and cast result to **column**

**Functions:**

**SWITCH:**if first expression is equal to second value, returns thirds. If it's equal to fourths, returns fifths. Sixths otherwise.

From location to text

**Scenario:** retrieve address as text from location

**Requirements:** one location column and one text column

**Integration:** When **column** changes, perform **formula** and cast result to **column**

**Functions:**

**RIGHT:**gets*n*chars of text starting from end;**LEN:**gets length of text;**FIND:**finds position of first occurrence of char in text.

More than **6,272,000** operations performed by over **1,500** users. And counting...