Available functions
Built-in Functions and Support for Excel & Native monday.com Functions
Formula PRO is designed to give users unparalleled flexibility in performing calculations and automations within monday.com. With built-in functions, support for widely-used EXCEL functions, and full compatibility with native monday.com functions, you can easily implement advanced business logic. More functions can be found here and here.
Complete Formula PRO Functions Reference
Text Functions
CONCATENATE
Concatenates text values into a single text value
CONCATENATE("I", " love ", "monday")
"I love monday"
LEFT
Extracts a given number of characters from the left side
LEFT("monday.com", 3)
"mon"
LEN
Returns the number of characters in a given text string
LEN("hello")
5
LOWER
Converts a specified string to lowercase
LOWER("Some STRING")
"some string"
REPLACE
Replaces part of a string with a new string
REPLACE("Goat", 1, 2, "Fl")
"Float"
REPT
Repeats a string a given number of times
REPT("monday", 3)
"mondaymondaymonday"
RIGHT
Extracts characters from the right side of a text string
RIGHT("monday.com", 3)
"com"
SEARCH
Searches for a string within another string
IF(SEARCH("love", "I love monday", 1) > 0, "Exist", "Not")
"Exist"
SUBSTITUTE
Replaces text in a string by matching
SUBSTITUTE("goodmorning", "morning", "night")
"goodnight"
TEXT
Formats the given value based on the given text format
TEXT(8500.6, "$#,##0.00")
"$8,500.60"
TRIM
Removes excess spaces from a string
TRIM(" I love monday ")
"I love monday"
UPPER
Converts a specified string to uppercase
UPPER("monday.com")
"MONDAY.COM"
MID
Returns characters from middle of text
MID("monday", 2, 3)
"ond"
CLEAN
Removes non-printable characters
CLEAN("monday\nJS")
"mondayJS"
CHAR
Returns character for a number
CHAR(65)
"A"
UNICHAR
Returns Unicode character
UNICHAR(128516)
"😄"
T
Returns text referred by value
T("monday")
"monday"
Logical Functions
AND
Checks if all conditions are true
AND(3 > 1, 4 > 2)
true
EXACT
Compares two values for exact match
EXACT("monday", "monday")
true
IF
Performs conditional logic
IF(150 > 100, "big deal", "small deal")
"big deal"
OR
Returns true if any argument is true
OR(3 > 10, 4 > 2)
true
XOR
Returns logical exclusive OR
XOR(3 > 0, 2 > 9)
true
SWITCH
Evaluates expression against values
SWITCH("High", "High", 3, "Medium", 2, "Low", 1, 0)
3
IFERROR
Returns value if error occurs
IFERROR(1/0, "Error occurred")
"Error occurred"
IFNA
Returns value if #N/A occurs
IFNA(null, "Not found")
"Not found"
IFS
Checks multiple conditions
IFS(5>0, "Positive", 5<0, "Negative", TRUE, "Zero")
"Positive"
NOT
Reverses logic
NOT(1 > 2)
true
Math Functions
ABS
Returns absolute value
ABS(-1)
1
AVERAGE
Calculates average
AVERAGE(1, 2, 3)
2
DIVIDE
Divides numbers
DIVIDE(10, 5)
2
COUNT
Counts numerical items
COUNT(1, 2, "a")
2
LOG
Calculates logarithm
LOG(16, 2)
4
MAX
Finds largest value
MAX(1, 3, 5, 9)
9
MIN
Finds smallest value
MIN(1, 3, 5, 9)
1
MINUS
Subtracts numbers
MINUS(5, 3)
2
MULTIPLY
Multiplies numbers
MULTIPLY(5, 2)
10
MOD
Calculates remainder
MOD(10, 3)
1
ROUND
Rounds to specified digits
ROUND(1.123456, 2)
1.12
ROUNDUP
Rounds up
ROUNDUP(1.1, 0)
2
ROUNDDOWN
Rounds down
ROUNDDOWN(1.1, 0)
1
SQRT
Calculates square root
SQRT(9)
3
SUM
Adds numbers
SUM(2, 3, 8)
13
POWER
Raises to power
POWER(2, 3)
8
SUMIF
Conditional sum
SUMIF([1,2,3,4], ">2")
7
SUMIFS
Multiple criteria sum
SUMIFS([1,2,3,4], [">2", "<4"])
3
PRODUCT
Multiplies numbers
PRODUCT(2, 3, 4)
24
QUOTIENT
Integer division
QUOTIENT(5, 2)
2
RANDBETWEEN
Random integer in range
RANDBETWEEN(1, 10)
[random 1-10]
CEILING
Rounds up to multiple
CEILING(4.3, 1)
5
FLOOR
Rounds down to multiple
FLOOR(4.3, 1)
4
INT
Rounds down to integer
INT(8.9)
8
Date Functions
ADD_DAYS
Adds/subtracts days from date
ADD_DAYS("2023-01-20", 5)
"2023-01-25"
DATE
Creates date from components
DATE(2023, 5, 30)
"2023-05-30"
DAY
Extracts day from date
DAY("2023-05-15")
15
NETWORKDAYS
Counts workdays between dates
NETWORKDAYS("2023-01-01", "2023-01-10")
7
FORMAT_DATE
Formats date
FORMAT_DATE(DATE(2023, 5, 15), "YYYY-MM-DD") => "2023-05-15"
FORMAT_DATE(ADD_DAYS("2023-05-18", 4) ,"MM-DD") => 05-22
"2023-05-15"
HOUR
Extracts hour
HOUR("2023-05-15 14:30:00")
14
HOURS_DIFF
Calculates hours between times
HOURS_DIFF("2023-05-15 14:30", "2023-05-15 16:30")
2
WORKDAYS
Counts working days
WORKDAYS("2023-01-01", "2023-01-10")
7
WORKDAY
Adds workdays to date
WORKDAY("2023-01-01", 5)
"2023-01-06"
MINUTE
Extracts minute
MINUTE("2023-05-15 14:30:00")
30
MONTH
Extracts month
MONTH("2023-05-15")
5
SECOND
Extracts second
SECOND("2023-05-15 14:30:45")
45
TODAY
Returns current date
TODAY()
[current date]
WEEKNUM
Gets week number
WEEKNUM("2023-05-15")
20
ISOWEEKNUM
Gets ISO week number
ISOWEEKNUM("2023-05-15")
20
YEAR
Extracts year
YEAR("2023-05-15")
2023
DATEDIF
Date difference
DATEDIF("2023-01-01", "2024-01-01", "Y")
1
EDATE
Add/subtract months
EDATE("2023-01-01", 1)
"2023-02-01"
EOMONTH
End of month
EOMONTH("2023-01-01", 0)
"2023-01-31"
WEEKDAY
Day of week
WEEKDAY("2023-01-01")
7
Statistical Functions
AVEDEV
Average absolute deviation
AVEDEV(2, 4, 8, 16)
5
AVERAGE
Arithmetic mean
AVERAGE(2, 4, 6, 8)
5
AVERAGEA
Average including text/logical
AVERAGEA(2, 4, TRUE, "6")
2.33
AVERAGEIF
Conditional average
AVERAGEIF([1,2,3,4], ">2")
3.5
CORREL
Correlation coefficient
CORREL([1,2,3], [2,4,6])
1
COUNT
Count numbers
COUNT(1, 2, "3", TRUE)
2
COUNTA
Count non-empty values
COUNTA(1, "", "3", TRUE)
3
COUNTBLANK
Count empty values
COUNTBLANK(["", 1, "", 2])
2
COUNTIF
Count values meeting criteria
COUNTIF([1,2,3,4], ">2")
2
MEDIAN
Middle value
MEDIAN(1, 2, 3, 4, 5)
3
MODE
Most frequent value
MODE(1, 2, 2, 3, 4)
2
STDEV
Standard deviation
STDEV(1, 2, 3, 4, 5)
1.58
VAR
Variance
VAR(1, 2, 3, 4, 5)
2.5
Information Functions
ISBLANK
Tests for blank value
ISBLANK("")
true
ISERR
Tests for error (except #N/A)
ISERR(1/0)
true
ISERROR
Tests for any error
ISERROR(1/0)
true
ISEVEN
Tests for even number
ISEVEN(4)
true
ISLOGICAL
Tests for logical value
ISLOGICAL(TRUE)
true
ISNA
Tests for #N/A
ISNA(null)
true
ISNONTEXT
Tests for non-text
ISNONTEXT(123)
true
ISNUMBER
Tests for number
ISNUMBER(123)
true
ISODD
Tests for odd number
ISODD(3)
true
ISTEXT
Tests for text
ISTEXT("monday")
true
N
Converts to number
N(TRUE)
1
TYPE
Returns value type
TYPE(123)
1
Additional Custom Functions
CONTAINS
Checks for substring
CONTAINS("monday", "I love monday")
true
VALUE_EXISTS
Checks if value exists
VALUE_EXISTS("something")
true
HAS_VALUE
Alternative to VALUE_EXISTS
HAS_VALUE("something")
true
IS
Equality check
IS(5, 5)
true
START
Gets start date from range
START("2023-06-19+2023-08-04")
"2023-06-19"
END
Gets end date from range
END("2023-06-19+2023-08-04")
"2023-08-04"
ADD_DAYS
Adds days to date
ADD_DAYS("2019-01-20", 5)
"2019-01-25"
IGNORE
Used to ignore or skip execution of an operation on a column
IF(SEARCH("hello", "I love monday", 1) > 0, "Exist", IGNORE())
Last updated