Recipe Examples

Real-world formula examples from Formula Pro recipes, with explanations and expected results.

---

Due-Date Automation: Project Working-Day Offsets

Recipe: When column changes, execute formula and project the result to column

Use case: Set a due date based on working-day offsets (e.g., add 5 business days).

Formula:

TEXT(WORKDAY(DATEVALUE({item's Date}), {item's Number}), "YYYY-MM-DD")

Explanation:

• DATEVALUE({item's Date}) — Parse the date string into a date object

• WORKDAY(start, days) — Add N business days (Mon–Fri), skipping weekends

• TEXT(date, "YYYY-MM-DD") — Format as ISO date for monday.com Date column

Example: Date = "2025-03-09", Number = 5 → Result: "2025-03-16" (5 weekdays later)

---

Timeline Shift: Add 14-Day Offset

Recipe: When column changes, execute formula and project the result to column (Timeline column)

Formula:

CONCATENATE(
  TEXT(DATEVALUE({item's Date})+7, "YYYY-MM-DD"),
  "+",
  TEXT(DATEVALUE({item's Date})+21, "YYYY-MM-DD")
)

Explanation: Creates a timeline 7 days after start and 21 days after start (14-day span). Adjust the +7 and +21 for different offsets.

For existing Timeline column:

CONCATENATE(
  TEXT(DATEVALUE(LEFT({item's Timeline}, 10)) + 14, "YYYY-MM-DD"),
  "+",
  TEXT(DATEVALUE(RIGHT({item's Timeline}, 10)) + 14, "YYYY-MM-DD")
)

---

Work-Hour Calculator: Business-Hour Difference

Recipe: When column changes, execute formula and project the result to column

Use case: Calculate working hours between two datetime columns (e.g., 9 AM–6 PM business hours).

Formula: (Simplified; full formula uses NETWORKDAYS, TIMEVALUE, MEDIAN for partial-day handling)

((NETWORKDAYS(DATEVALUE({item's From DateTime}), DATEVALUE({item's To DateTime})) - 1) * (TIMEVALUE("18:00") - TIMEVALUE("09:00")) + ...) * 24

Result: Number of business hours between From and To datetimes.

---

Location Extractor: Pull Address from Map Column

Recipe: When column changes, execute formula and project the result to column

Formula:

RIGHT({item's Location}, LEN({item's Location}) - FIND(":", {item's Location}, FIND(":", {item's Location}) + 1))

Explanation: Extracts the address portion after the second colon in monday.com Location column format.

---

WhatsApp Link Generator

Recipe: When column changes, execute formula and project the result to column (Link column)

Formula:

CONCATENATE("http://wa.me/", LEFT({item's Phone}, FIND(":", {item's Phone}) - 1), ":WhatsApp")

Explanation: Builds http://wa.me/PHONENUMBER:WhatsApp from a phone column. Assumes format PHONENUMBER:Label.

Result: http://wa.me/15551234567:WhatsApp

---

Conditionally Project Email Based on Status

Recipe: When column changes, execute formula and project the result to column (Email column)

Formula:

SWITCH({item's Status}, "Tim", "[email protected]:Tim Apple", "Jeff", "[email protected]:Jeff Amazon", "")

Explanation: Maps status values to email addresses. monday.com Email column format: email:Display Name.

Result: Status "Tim" → [email protected]:Tim Apple; "Jeff" → [email protected]:Jeff Amazon; else empty.

---

Timeline Propagation: Sync Shifted Timelines

Recipe: When column changes, execute formula and project the result to column

Formula:

CONCATENATE(
  TEXT(DATEVALUE(LEFT({item's Timeline}, 10)) + 14, "YYYY-MM-DD"),
  "+",
  TEXT(DATEVALUE(RIGHT({item's Timeline}, 10)) + 14, "YYYY-MM-DD")
)

Result: New timeline with start and end dates shifted by 14 days.

---

Workday Count From Timeline

Recipe: When column changes, execute formula and project the result to column (Number column)

Formula:

NETWORKDAYS(DATEVALUE(LEFT({item's Timeline}, 10)), DATEVALUE(RIGHT({item's Timeline}, 10)))

Result: Number of working days between timeline start and end.

---

Project Formula Column to Parent Item

Recipe: When subitem is created (or formula column changes), project formula column result to parent item column

Use case: Subitem has a formula column; parent needs the aggregated or selected result.

Configure: Source = subitem formula column, Destination = parent text/number column.

---

Project From Subitem Formula to Parent

Recipe: Project formula column in subitem to text column in parent item

Same concept as above — use the "Project formula column to parent" recipe and select the subitem formula column and parent destination column.