Useful formulas
Last updated
Last updated
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.
Check if a value exists
When column changes, apply a formula and set result to column.
IF(HAS_VALUE({item's timeline}) IS "True", "Complete", "Missing timeline")
IF(VALUE_EXISTS({item's timeline}) IS "True", "Complete", "Missing timeline")
Sum numbers
When column changes, apply a formula and set result to column.
SUM({item's number}, {item's number_1}, 100)
Update item name by status
When column changes, apply a formula and set result to item name.
IF({item’s status} IS "Closed", CONCATENATE({item's name}, "_", "closed"), {item's name})
Concatenate text
When column changes, apply a formula and set result to column.
CONCATENATE({item's people}, " is the owner of the task")
Set price by currency
When column changes, apply a formula and set result to column.
IF({item’s currency} IS "USD", MULTIPLY({item’s cost}, 0.29), MULTIPLY({item’s cost}, 1))
Calculate the number of days
When column changes, apply a formula and set the result to column.
DAYS(END({item’s timeline}), START({item’s timeline}))
Assign a person by email
When column changes, apply a formula and set result to column.
{item's email_as_text}