Function Reference
All 57 Formula Trigga functions — Date and Time, Numeric, Text, Conditional, and Constants — with syntax, return types, and examples.
Formula Trigga supports 57 functions across five categories. The function names and syntax match monday.com's native formula column — if you already know those formulas, you know these.
Summary
| Function | Category | Description |
|---|---|---|
| ADD_DAYS | Date and Time | Adds days to a date |
| ADD_MINUTES | Date and Time | Adds minutes to a date |
| DATE | Date and Time | Creates a date from year, month, day |
| DATEVALUE | Date and Time | Returns Excel serial number of a date |
| DAY | Date and Time | Returns day of month (1-31) |
| DAYS | Date and Time | Returns days between two dates |
| FORMAT_DATE | Date and Time | Formats a date using Moment.js tokens |
| HOUR | Date and Time | Returns hour (0-23, UTC) |
| HOURS_DIFF | Date and Time | Returns difference between two times |
| ISOWEEKNUM | Date and Time | Returns ISO week number |
| MINUTE | Date and Time | Returns minute (0-59, UTC) |
| MONTH | Date and Time | Returns month (1-12) |
| SECOND | Date and Time | Returns second (0-59, UTC) |
| SUBTRACT_DAYS | Date and Time | Subtracts days from a date |
| SUBTRACT_MINUTES | Date and Time | Subtracts minutes from a date |
| TODAY | Date and Time | Returns current date (UTC midnight) |
| WEEKNUM | Date and Time | Returns week number of the year |
| WORKDAY | Date and Time | Adds working days to a date |
| WORKDAYS | Date and Time | Returns working days between two dates |
| YEAR | Date and Time | Returns year from a date |
| ABS | Numeric | Absolute value |
| AVERAGE | Numeric | Average of given numbers |
| COUNT | Numeric | Counts numeric values |
| DIVIDE | Numeric | Divides two numbers |
| LOG | Numeric | Logarithm for a given base |
| MAX | Numeric | Largest value from a set |
| MIN | Numeric | Smallest value from a set |
| MINUS | Numeric | Subtracts two numbers |
| MOD | Numeric | Remainder after division |
| MULTIPLY | Numeric | Multiplies two numbers |
| POWER | Numeric | Raises a number to a power |
| ROUND | Numeric | Rounds to decimal places |
| ROUNDDOWN | Numeric | Rounds down toward zero |
| ROUNDUP | Numeric | Rounds up away from zero |
| SQRT | Numeric | Positive square root |
| SUM | Numeric | Adds all given numbers |
| CONCATENATE | Text | Joins text values |
| LEFT | Text | Extracts characters from the left |
| LEN | Text | Character count |
| LOWER | Text | Converts to lowercase |
| REPLACE | Text | Replaces text by position |
| REPT | Text | Repeats text N times |
| RIGHT | Text | Extracts characters from the right |
| SEARCH | Text | Finds position of text within text |
| SUBSTITUTE | Text | Replaces occurrences of a string |
| TEXT | Text | Formats a number with Excel-style codes |
| TRIM | Text | Removes extra spaces |
| UPPER | Text | Converts to uppercase |
| AND | Conditional | True if all arguments are true |
| EXACT | Conditional | Case-sensitive equality check |
| IF | Conditional | Returns value based on condition |
| OR | Conditional | True if any argument is true |
| SWITCH | Conditional | Matches value against cases |
| XOR | Conditional | True if odd number of arguments are true |
| FALSE | Constants | Returns logical false |
| PI | Constants | Returns pi (3.1415926536) |
| TRUE | Constants | Returns logical true |
Date and Time
20 functions for creating, manipulating, and extracting parts of dates.
All date functions operate in UTC. TODAY() returns the current date at UTC midnight. HOUR(), MINUTE(), and SECOND() return UTC values, not your local timezone.
ADD_DAYS
Adds days to a date.
Syntax: ADD_DAYS(date, days)
Returns: Date
Example:
ADD_DAYS("2026-01-20", 5) → 2026-01-25
ADD_MINUTES
Adds minutes to a date.
Syntax: ADD_MINUTES(date, minutes)
Returns: Date
Example:
ADD_MINUTES(TODAY(), 90) → today's date plus 90 minutes
DATE
Creates a date from year, month, and day values.
Syntax: DATE(year, month, day)
Returns: Date
Month is 1-indexed: 1 = January, 12 = December.
Example:
DATE(2026, 5, 30) → May 30, 2026
DATEVALUE
Returns the Excel serial number of a date (days since January 1, 1900).
Syntax: DATEVALUE(date_string)
Returns: Number
Example:
DATEVALUE("2026-02-08") → 46061
DAY
Returns the day of the month (1-31) from a date.
Syntax: DAY(date)
Returns: Number
Example:
DAY({Date Column}) → 15
DAYS
Returns the number of days between two dates.
Syntax: DAYS(end_date, start_date)
Returns: Number
Example:
DAYS({End Date}, {Start Date}) → number of days between the two dates
FORMAT_DATE
Formats a date using Moment.js format tokens. See Working with Dates for the full list of format codes.
Syntax: FORMAT_DATE(date[, format_string])
Returns: Text
Example:
FORMAT_DATE(TODAY(), "YYYY-MM-DD") → "2026-03-25"
HOUR
Returns the hour (0-23) from a date or time value. Returns UTC hour.
Syntax: HOUR(date)
Returns: Number
Example:
HOUR({Date Column}) → 14
HOURS_DIFF
Returns the difference between two time values as a string in "HH:MM" format. Accepts three input formats: "HH:MM", "YYYY-MM-DD", or "YYYY-MM-DD HH:MM". Empty inputs return "00:00".
Syntax: HOURS_DIFF(end_time, start_time)
Returns: Text (format "HH:MM")
Example:
HOURS_DIFF("23:00", "20:00") → "03:00"
ISOWEEKNUM
Returns the ISO week number of the year. ISO weeks start on Monday, and week 1 is the week containing January 4.
Syntax: ISOWEEKNUM(date)
Returns: Number
Example:
ISOWEEKNUM({Date Column}) → 42
MINUTE
Returns the minute (0-59) from a date or time value. Returns UTC minute.
Syntax: MINUTE(date)
Returns: Number
Example:
MINUTE({Date Column}) → 30
MONTH
Returns the month (1-12) from a date.
Syntax: MONTH(date)
Returns: Number
Example:
MONTH({Date Column}) → 7
SECOND
Returns the second (0-59) from a date or time value. Returns UTC second.
Syntax: SECOND(date)
Returns: Number
Example:
SECOND({Date Column}) → 45
SUBTRACT_DAYS
Subtracts days from a date.
Syntax: SUBTRACT_DAYS(date, days)
Returns: Date
Example:
FORMAT_DATE(SUBTRACT_DAYS("2026-01-20", 5)) → "Jan 15, 2026"
SUBTRACT_MINUTES
Subtracts minutes from a date.
Syntax: SUBTRACT_MINUTES(date, minutes)
Returns: Date
Example:
SUBTRACT_MINUTES(TODAY(), 60) → today's date minus 60 minutes
TODAY
Returns the current date (UTC midnight).
Syntax: TODAY()
Returns: Date
Use FORMAT_DATE(TODAY()) when writing to a Text column to control the output format.
Example:
TODAY() → current date
WEEKNUM
Returns the week number of the year (1-53) for a date.
Syntax: WEEKNUM(date)
Returns: Number
Example:
WEEKNUM({Date Column}) → 42
WORKDAY
Adds working days to a date, skipping non-working days. Respects your account's working days configuration (see Working with Dates).
Syntax: WORKDAY(date, days[, holidays])
Returns: Date
Example:
WORKDAY({Start Date}, 10) → 10 business days after start date
WORKDAYS
Returns the number of working days between two dates. Respects your account's working days configuration.
Syntax: WORKDAYS(end_date, start_date[, holidays])
Returns: Number
Example:
WORKDAYS({End Date}, {Start Date}) → number of working days between the two dates
YEAR
Returns the year from a date.
Syntax: YEAR(date)
Returns: Number
Example:
YEAR({Date Column}) → 2026
Numeric
16 functions for math operations. DIVIDE, MINUS, MULTIPLY, SQRT, and LOG use 10-decimal precision.
ABS
Returns the absolute value of a number.
Syntax: ABS(number)
Returns: Number
Example:
ABS(-7) → 7
AVERAGE
Returns the average of the given numbers.
Syntax: AVERAGE(number1, number2, ...)
Returns: Number
Example:
AVERAGE(10, 20, 30) → 20
COUNT
Counts how many of the given values are numbers.
Syntax: COUNT(value1, value2, ...)
Returns: Number
Example:
COUNT(1, 2, "a") → 2
DIVIDE
Divides one number by another.
Syntax: DIVIDE(numerator, denominator)
Returns: Number
Division by zero throws an error. Guard with IF: IF({Denominator} == 0, 0, DIVIDE({Numerator}, {Denominator})).
Example:
DIVIDE(10, 4) → 2.5
LOG
Returns the logarithm of a number for a given base. Default base is e (natural logarithm). Throws an error if the number is 0 or negative, or if the base is 0, negative, or equal to 1.
Syntax: LOG(number[, base])
Returns: Number
Example:
LOG(16, 2) → 4
MAX
Returns the largest value from a set of numbers.
Syntax: MAX(number1, number2, ...)
Returns: Number
Example:
MAX(1, 3, 5, 9) → 9
MIN
Returns the smallest value from a set of numbers.
Syntax: MIN(number1, number2, ...)
Returns: Number
Example:
MIN(1, 3, 5, 9) → 1
MINUS
Subtracts one number from another.
Syntax: MINUS(number1, number2)
Returns: Number
Example:
MINUS(10, 3) → 7
MOD
Returns the remainder after dividing one number by another.
Syntax: MOD(number, divisor)
Returns: Number
Example:
MOD(10, 3) → 1
MULTIPLY
Multiplies two numbers.
Syntax: MULTIPLY(number1, number2)
Returns: Number
Example:
MULTIPLY(5, 4) → 20
POWER
Raises a number to a power.
Syntax: POWER(base, exponent)
Returns: Number
Example:
POWER(2, 3) → 8
ROUND
Rounds a number to a specified number of decimal places.
Syntax: ROUND(number, decimal_places)
Returns: Number
Example:
ROUND(3.14159, 2) → 3.14
ROUNDDOWN
Rounds a number down (toward zero).
Syntax: ROUNDDOWN(number, decimal_places)
Returns: Number
Example:
ROUNDDOWN(1.9, 0) → 1
ROUNDUP
Rounds a number up (away from zero).
Syntax: ROUNDUP(number, decimal_places)
Returns: Number
Example:
ROUNDUP(1.1, 0) → 2
SQRT
Returns the positive square root of a number. Throws an error for negative numbers.
Syntax: SQRT(number)
Returns: Number
Example:
SQRT(9) → 3
SUM
Adds all the given numbers.
Syntax: SUM(number1, number2, ...)
Returns: Number
Example:
SUM(2, 3, 8) → 13
Text
12 functions for working with text strings.
CONCATENATE
Joins multiple text values into one.
Syntax: CONCATENATE(text1, text2, ...)
Returns: Text
Example:
CONCATENATE("Hello", " ", "World") → "Hello World"
LEFT
Extracts characters from the left side of a text string.
Syntax: LEFT(text, num_chars)
Returns: Text
Example:
LEFT("monday.com", 3) → "mon"
LEN
Returns the number of characters in a text string.
Syntax: LEN(text)
Returns: Number
Example:
LEN("hello") → 5
LOWER
Converts text to lowercase.
Syntax: LOWER(text)
Returns: Text
Example:
LOWER("Some STRING") → "some string"
REPLACE
Replaces part of a text string with different text, by position.
Syntax: REPLACE(text, start_position, num_chars, new_text)
Returns: Text
Example:
REPLACE("Goat", 1, 2, "Fl") → "Flat"
REPT
Repeats a text string a given number of times.
Syntax: REPT(text, times)
Returns: Text
Example:
REPT("Go! ", 3) → "Go! Go! Go! "
RIGHT
Extracts characters from the right side of a text string.
Syntax: RIGHT(text, num_chars)
Returns: Text
Example:
RIGHT("monday", 3) → "day"
SEARCH
Finds the position of one text string within another. Returns 0 if not found.
Syntax: SEARCH(search_text, within_text, start_position)
Returns: Number
Example:
IF(SEARCH("love", "I love monday", 1) > 0, "Found", "Not found") → "Found"
SUBSTITUTE
Replaces occurrences of a text string within another string.
Syntax: SUBSTITUTE(text, old_text, new_text)
Returns: Text
Example:
SUBSTITUTE("goodmorning", "morning", "night") → "goodnight"
TEXT
Formats a number using an Excel-style format code.
Syntax: TEXT(value, format_code)
Returns: Text
Example:
TEXT(8500.6, "$#,##0.00") → "$8,500.60"
TRIM
Removes extra spaces from text, leaving single spaces between words.
Syntax: TRIM(text)
Returns: Text
Example:
TRIM(" I love monday ") → "I love monday"
UPPER
Converts text to uppercase.
Syntax: UPPER(text)
Returns: Text
Example:
UPPER("monday.com") → "MONDAY.COM"
Conditional
6 functions for logic and branching.
AND
Returns true if all arguments are true.
Syntax: AND(condition1, condition2, ...)
Returns: Boolean
Example:
AND(3 > 1, 4 > 2) → true
EXACT
Compares two values for exact equality (case-sensitive for strings).
Syntax: EXACT(value1, value2)
Returns: Boolean
The = operator with strings is automatically rewritten to use EXACT(), so {Status} = "Done" and EXACT({Status}, "Done") behave the same way.
Example:
EXACT("Hello", "hello") → false
IF
Returns one value if a condition is true, another if false.
Syntax: IF(condition, value_if_true, value_if_false)
Returns: Varies
Example:
IF({Numbers Column} > 100, "Big deal", "Small deal")
OR
Returns true if any argument is true.
Syntax: OR(condition1, condition2, ...)
Returns: Boolean
Example:
OR(3 > 10, 4 > 2) → true
SWITCH
Matches a value against a list of cases and returns the corresponding result. Supports an optional default value as the last argument.
Syntax: SWITCH(expression, value1, result1[, value2, result2, ...][, default])
Returns: Varies
Example:
SWITCH({Priority}, "High", 3, "Medium", 2, "Low", 1, 0) → 2 (when Priority is "Medium")
XOR
Returns true if an odd number of arguments are true (exclusive or).
Syntax: XOR(condition1, condition2, ...)
Returns: Boolean
Example:
XOR(3 > 0, 2 > 9) → true
Constants
3 constant functions.
FALSE
Returns the logical value false.
Syntax: FALSE()
Returns: Boolean
Example:
IF(FALSE(), "yes", "no") → "no"
PI
Returns the value of pi (3.1415926536, 10-decimal precision).
Syntax: PI()
Returns: Number
Example:
MULTIPLY(PI(), POWER({Radius}, 2)) → area of a circle
TRUE
Returns the logical value true.
Syntax: TRUE()
Returns: Boolean
Example:
IF(TRUE(), "yes", "no") → "yes"
Next Steps
- Troubleshooting — health view, common errors, FAQ, and support
- Recipes and Patterns — ready-to-use formulas for common workflows