Writing Formulas

Formulas combine column references, functions, and operators to produce a value that Formula Trigga writes to a classic column — triggering any automations watching it.

Formula Syntax Basics

Every formula follows the same pattern: reference columns with curly braces, apply functions, and connect with operators.

IF({Priority} == "High", "Urgent", "Normal")

The formula editor provides:

• Autocomplete — type { to see available columns, start typing a function name to see suggestions
• Function tooltips — hover over a function name for description and parameter info
• Error feedback — validation messages appear below the editor if your formula has issues

Referencing Columns

Use curly braces to reference column values:

{Column Name}

{Status} returns the current status label. {Numbers Column} returns the numeric value.

Status filter syntax: {Status}="Done" returns true if the status matches "Done", false otherwise. This is the canonical syntax shown in autocomplete.

Column renaming is safe. Formulas are stored using internal column IDs, not display names. Renaming a column doesn't break your formulas — the editor always shows the current name.

Using Functions

Functions follow the pattern FUNCTION_NAME(arg1, arg2):

IF({Numbers Column} > 100, "Big", "Small")

CONCATENATE({First Name}, " ", {Last Name})

FORMAT_DATE(ADD_DAYS(TODAY(), 7), "MMMM Do, YYYY")

Formula Trigga supports 57 functions across 5 categories: Date/Time (20), Numeric (16), Text (12), Conditional (6), and Constants (3). See the Function Reference for the full list.

Operators

Operator rewriting: When you use = or <> with a text value, Formula Trigga converts them to EXACT() calls for case-sensitive matching. With numbers, they become == and !=. This happens behind the scenes.

Examples:

{Status} = "Done"         →  EXACT({Status}, "Done")
{Status} <> "Done"        →  not(EXACT({Status}, "Done"))
{Numbers Column} = 100    →  {Numbers Column} == 100

How Formulas Trigger Automations

This is Formula Trigga's core purpose — the reason the product exists.

1. A source column value changes (someone updates a cell, an automation sets a value, etc.)
2. Formula Trigga detects the change and recalculates your formula
3. The result is written to the target column — a classic column that automations can watch
4. monday.com automations fire as if someone had manually updated that column

The 8 target column types that support this: Text, Numbers, Date, Status, People, Long Text, Email, and Dropdown. See Supported Columns for details on what each accepts.

Because Formula Trigga writes to classic columns, every monday.com automation recipe that watches column changes works out of the box: "When status changes to...", "When date arrives...", "When column changes, notify...".

Empty Values

When a column has no value, formulas see a type-specific default — not always what you'd expect.

Guard pattern for Status:

IF({Status} == "Empty", "Not set", {Status})

Type Coercion

When a formula result is written to a target column, Formula Trigga converts the value to fit the column type.

Key things to watch:

• Booleans become text. true → "Yes", false → "No" when targeting a Text column.
• Null clears. If your formula returns nothing, the target column is emptied.
• Dropdown comma splitting. Text with commas is split into multiple dropdown labels. "High Priority" stays one label, but "High, Medium" becomes two.
• Dates need formatting. Without FORMAT_DATE(), a date written to a Text column produces a long UTC string. Always use FORMAT_DATE() for text output.

Enabling and Disabling Formulas

Toggle a formula on or off without deleting it.

• Enabled — the formula recalculates whenever source columns change
• Disabled — the formula stops recalculating, but the configuration is preserved

Disabling is useful during bulk data imports or when temporarily pausing calculations without losing your formula setup.

Batch Calculation

When you add a formula to a board that already has data, existing items won't have calculated values yet — formulas only trigger on column changes.

Use "Set and calculate all items" to apply the formula to every item on the board at once.

• A confirmation modal shows the item count and quota impact before processing
• Progress tracking shows how many items have been calculated
• Useful when deploying a new formula to an existing board or after modifying a formula

Formula Limits

These limits are enforced in the editor and during calculation.

Next Steps

• Supported Columns — target columns, source columns, and column properties
• Recipes and Patterns — ready-to-use formulas for common workflows
• Troubleshooting — health view, common errors, FAQ, and support