Ideas

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...
General Caster
General Caster is a monday.com app
© 2021 Omnidea S.r.l.