General Caster v2.2 is now available. Four new integrations to cast formula results into item name and auto-increment a Number column. 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.
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 with 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 with 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 with 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 any subitems column type

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.
From timeline to working days

Scenario: get working dates between two dates

Requirements: one timeline column and one number column

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

Functions:

  • NETWORKDAYS: calculates working days between two dates;
  • DATEVALUE: converts a column value into a valid date, you can then add or subtract days with 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 dates to working hours

Scenario: get working hours between two dates with times in a 09:00-18:00 (9AM-6PM) work schedule

Requirements: two dates column with time and one number column

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

Functions:

  • NETWORKDAYS: calculates working days between two dates;
  • DATEVALUE: converts a column value into a valid date, you can then add or subtract days with a simple math operation;
  • TIMEVALUE: converts a column value into a valid time in a base-24 format;
  • IF: if first statement is true, returns second value, third otherwise;
  • MEDIAN: gets the median in a set of numbers;
  • MOD: gets the remainder of a division.
More than 8,627,000 operations performed by over 1,500 users. And counting...
General Caster
General Caster is a monday.com app
© 2021 Omnidea S.r.l.