Available functions
Last updated
Last updated
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.
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"
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
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
DATEADD
Adds/subtracts days from date
DATEADD("2023-01-20", 5, "days")
"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
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
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
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())