Overview

Formula Pro extends Excel-compatible formulas with 40+ custom functions designed for monday.com workflows. These functions handle:

• Dates & timelines — monday.com date formats, timeline columns, working days

• Mirror columns — Condition checks across mirrored values from connected items

• Text & regex — Pattern matching, replacement, and formatting

• Control flow — Skip/ignore items, clear values, conditional projection

Function Categories

Category	Functions	Use Case
Date & Time	ADD_DAYS, SUBTRACT_DAYS, WORKDAYS, FORMAT_DATE, HOURS_DIFF, etc.	Date arithmetic, formatting, working-day calculations
Timeline	TIMELINE, TIMELINE_FROM_DATES, START, END, DATES_FROM_TIMELINE	Timeline column parsing and construction
Text	CONTAINS, REGEXREPLACE, REGEXTEST, TEXT	Pattern matching, regex replace, formatting
Math	ADD, MINUS, MULTIPLY, DIVIDE, RAND_BETWEEN, comparison operators	Arithmetic with string concatenation support
Value Checking	COALESCE, HAS_VALUE, VALUE_EXISTS	Null handling, value presence checks
Mirror	ALL_MIRROR_VALUES_MATCH_CONDITION, AT_LEAST_ONE_MIRROR_VALUE_MATCHES_CONDITION, etc.	Mirror column condition evaluation
Control Flow	IGNORE, SKIP, PASS, CLEAR, EMPTY, SWITCH	Skip items, clear values, conditional logic

Naming Conventions

• Functions are case-insensitive — ADD_DAYS and add_days are equivalent

• Most functions follow FUNCTION_NAME style

• Aliases exist for common operations (e.g., PLUS = ADD, MIN_DATE = DATE_MIN)