General Caster v2 is now available. By popular demand we have introduced new triggers and new actions. Try it now!

Ideas

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


Formulas in this page include standard column references (i.e. {item's 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 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.
Occurences in subitems
4

Scenario: count occurences of "Apple" in subitems

Requirements: one subitems summary column (to hide) and one number column

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

Functions:

  • LEN: gets length of text;
  • SUBSTITUTE: replaces text with other text.
From phone to WhatsApp

Scenario: create a link to send a WhatsApp message

Requirements: one phone column and one link column

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

Functions:

  • LEFT: gets n chars of text starting from beginning;
  • FIND: finds position of first occurrence of char in text;
  • CONCATENATE: creates the URL:title string to be casted into link column.
More than 7,318,000 operations performed by over 1,500 users. And counting...
General Caster
General Caster is a monday.com app
© 2021 Omnidea S.r.l.