Useful formulas

A collection of commonly used useful formulas that can enhance your workflows within the monday.com platform. These formulas are designed to help users automate calculations, streamline processes, and derive valuable insights from their data.

Action

Check if a value exists

Recipe

When column changes, apply a formula and set result to column.

Example

IF(HAS_VALUE({item's timeline}) IS "True", "Complete", "Missing timeline") IF(VALUE_EXISTS({item's timeline}) IS "True", "Complete", "Missing timeline")

Action

Sum numbers

Recipe

When column changes, apply a formula and set result to column.

Example

SUM({item's number}, {item's number_1}, 100)

Action

Update item name by status

Recipe

When column changes, apply a formula and set result to item name.

Example

IF({item’s status} IS "Closed", CONCATENATE({item's name}, "_", "closed"), {item's name})

Action

Concatenate text

Recipe

When column changes, apply a formula and set result to column.

Example

CONCATENATE({item's people}, " is the owner of the task")

Action

Set price by currency

Recipe

When column changes, apply a formula and set result to column.

Example

IF({item’s currency} IS "USD", MULTIPLY({item’s cost}, 0.29), MULTIPLY({item’s cost}, 1))

Action

Calculate the number of days

Recipe

When column changes, apply a formula and set the result to column.

Example

DAYS(END({item’s timeline}), START({item’s timeline}))

Action

Assign a person by email

Recipe

When column changes, apply a formula and set result to column.

Example

{item's email_as_text}