Control Flow

Special functions that control formula execution and projection behavior.

---

IGNORE / SKIP / PASS

Skips formula execution for the current item. The target column is not updated — the item is left unchanged.

Syntax: IGNORE() or SKIP() or PASS()

Use case: Use inside IF() to conditionally skip updates:

IF({item's Status} = "Draft", IGNORE(), {item's Calculated Value})

If Status is "Draft", the formula does not project a value. Otherwise, it projects the calculated value.

---

CLEAR / EMPTY

Clears or empties the target column value. Use when you want to explicitly set the column to empty.

Syntax: CLEAR() or EMPTY()

Use case:

IF({item's Status} = "Archived", CLEAR(), {item's Active Value})

If Status is "Archived", the target column is cleared. Otherwise, the active value is projected.

---

SWITCH

Evaluates an expression and returns the result for the first matching value. Similar to Excel SWITCH.

Syntax: SWITCH(expression, value1, result1, [value2, result2, ...], [default])

Example:

SWITCH({item's Status}, "Done", "Complete", "In Progress", "Active", "Unknown")

Result: "Complete" if Status is "Done"; "Active" if "In Progress"; "Unknown" otherwise.

Example: With default

SWITCH({item's Priority}, 1, "High", 2, "Medium", 3, "Low", "Normal")

Result: Maps 1→High, 2→Medium, 3→Low; any other value → "Normal".

Example: Conditional email (from recipes)

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

Result: Status-specific email strings for an email column; empty string if no match.