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

Function

CONCATENATE

Description

Concatenates text values into a single text value

Example

CONCATENATE("I", " love ", "monday")

Result

"I love monday"

Function

LEFT

Description

Extracts a given number of characters from the left side

Example

LEFT("monday.com", 3)

Result

"mon"

Function

LEN

Description

Returns the number of characters in a given text string

Example

LEN("hello")

Result

5

Function

LOWER

Description

Converts a specified string to lowercase

Example

LOWER("Some STRING")

Result

"some string"

Function

REPLACE

Description

Replaces part of a string with a new string

Example

REPLACE("Goat", 1, 2, "Fl")

Result

"Float"

Function

REPT

Description

Repeats a string a given number of times

Example

REPT("monday", 3)

Result

"mondaymondaymonday"

Function

RIGHT

Description

Extracts characters from the right side of a text string

Example

RIGHT("monday.com", 3)

Result

"com"

Function

SEARCH

Description

Searches for a string within another string

Example

IF(SEARCH("love", "I love monday", 1) > 0, "Exist", "Not")

Result

"Exist"

Function

SUBSTITUTE

Description

Replaces text in a string by matching

Example

SUBSTITUTE("goodmorning", "morning", "night")

Result

"goodnight"

Function

TEXT

Description

Formats the given value based on the given text format

Example

TEXT(8500.6, "$#,##0.00")

Result

"$8,500.60"

Function

TRIM

Description

Removes excess spaces from a string

Example

TRIM(" I love monday ")

Result

"I love monday"

Function

UPPER

Description

Converts a specified string to uppercase

Example

UPPER("monday.com")

Result

"MONDAY.COM"

Function

MID

Description

Returns characters from middle of text

Example

MID("monday", 2, 3)

Result

"ond"

Function

CLEAN

Description

Removes non-printable characters

Example

CLEAN("monday\nJS")

Result

"mondayJS"

Function

CHAR

Description

Returns character for a number

Example

CHAR(65)

Result

"A"

Function

UNICHAR

Description

Returns Unicode character

Example

UNICHAR(128516)

Result

"😄"

Function

T

Description

Returns text referred by value

Example

T("monday")

Result

"monday"

Logical Functions

Function

AND

Description

Checks if all conditions are true

Example

AND(3 > 1, 4 > 2)

Result

true

Function

EXACT

Description

Compares two values for exact match

Example

EXACT("monday", "monday")

Result

true

Function

IF

Description

Performs conditional logic

Example

IF(150 > 100, "big deal", "small deal")

Result

"big deal"

Function

OR

Description

Returns true if any argument is true

Example

OR(3 > 10, 4 > 2)

Result

true

Function

XOR

Description

Returns logical exclusive OR

Example

XOR(3 > 0, 2 > 9)

Result

true

Function

SWITCH

Description

Evaluates expression against values

Example

SWITCH("High", "High", 3, "Medium", 2, "Low", 1, 0)

Result

3

Function

IFERROR

Description

Returns value if error occurs

Example

IFERROR(1/0, "Error occurred")

Result

"Error occurred"

Function

IFNA

Description

Returns value if #N/A occurs

Example

IFNA(null, "Not found")

Result

"Not found"

Function

IFS

Description

Checks multiple conditions

Example

IFS(5>0, "Positive", 5<0, "Negative", TRUE, "Zero")

Result

"Positive"

Function

NOT

Description

Reverses logic

Example

NOT(1 > 2)

Result

true

Math Functions

Function

ABS

Description

Returns absolute value

Example

ABS(-1)

Result

1

Function

AVERAGE

Description

Calculates average

Example

AVERAGE(1, 2, 3)

Result

2

Function

DIVIDE

Description

Divides numbers

Example

DIVIDE(10, 5)

Result

2

Function

COUNT

Description

Counts numerical items

Example

COUNT(1, 2, "a")

Result

2

Function

LOG

Description

Calculates logarithm

Example

LOG(16, 2)

Result

4

Function

MAX

Description

Finds largest value

Example

MAX(1, 3, 5, 9)

Result

9

Function

MIN

Description

Finds smallest value

Example

MIN(1, 3, 5, 9)

Result

1

Function

MINUS

Description

Subtracts numbers

Example

MINUS(5, 3)

Result

2

Function

MULTIPLY

Description

Multiplies numbers

Example

MULTIPLY(5, 2)

Result

10

Function

MOD

Description

Calculates remainder

Example

MOD(10, 3)

Result

1

Function

ROUND

Description

Rounds to specified digits

Example

ROUND(1.123456, 2)

Result

1.12

Function

ROUNDUP

Description

Rounds up

Example

ROUNDUP(1.1, 0)

Result

2

Function

ROUNDDOWN

Description

Rounds down

Example

ROUNDDOWN(1.1, 0)

Result

1

Function

SQRT

Description

Calculates square root

Example

SQRT(9)

Result

3

Function

SUM

Description

Adds numbers

Example

SUM(2, 3, 8)

Result

13

Function

POWER

Description

Raises to power

Example

POWER(2, 3)

Result

8

Function

SUMIF

Description

Conditional sum

Example

SUMIF([1,2,3,4], ">2")

Result

7

Function

SUMIFS

Description

Multiple criteria sum

Example

SUMIFS([1,2,3,4], [">2", "<4"])

Result

3

Function

PRODUCT

Description

Multiplies numbers

Example

PRODUCT(2, 3, 4)

Result

24

Function

QUOTIENT

Description

Integer division

Example

QUOTIENT(5, 2)

Result

2

Function

RANDBETWEEN

Description

Random integer in range

Example

RANDBETWEEN(1, 10)

Result

[random 1-10]

Function

CEILING

Description

Rounds up to multiple

Example

CEILING(4.3, 1)

Result

5

Function

FLOOR

Description

Rounds down to multiple

Example

FLOOR(4.3, 1)

Result

4

Function

INT

Description

Rounds down to integer

Example

INT(8.9)

Result

8

Date Functions

Function

ADD_DAYS

Description

Adds/subtracts days from date

Example

ADD_DAYS("2023-01-20", 5)

Result

"2023-01-25"

Function

DATE

Description

Creates date from components

Example

DATE(2023, 5, 30)

Result

"2023-05-30"

Function

DAY

Description

Extracts day from date

Example

DAY("2023-05-15")

Result

15

Function

NETWORKDAYS

Description

Counts workdays between dates

Example

NETWORKDAYS("2023-01-01", "2023-01-10")

Result

7

Function

FORMAT_DATE

Description

Formats date

Example

FORMAT_DATE(DATE(2023, 5, 15), "YYYY-MM-DD") => "2023-05-15" FORMAT_DATE(ADD_DAYS("2023-05-18", 4) ,"MM-DD") => 05-22

Result

"2023-05-15"

Function

HOUR

Description

Extracts hour

Example

HOUR("2023-05-15 14:30:00")

Result

14

Function

HOURS_DIFF

Description

Calculates hours between times

Example

HOURS_DIFF("2023-05-15 14:30", "2023-05-15 16:30")

Result

2

Function

WORKDAYS

Description

Counts working days

Example

WORKDAYS("2023-01-01", "2023-01-10")

Result

7

Function

WORKDAY

Description

Adds workdays to date

Example

WORKDAY("2023-01-01", 5)

Result

"2023-01-06"

Function

MINUTE

Description

Extracts minute

Example

MINUTE("2023-05-15 14:30:00")

Result

30

Function

MONTH

Description

Extracts month

Example

MONTH("2023-05-15")

Result

5

Function

SECOND

Description

Extracts second

Example

SECOND("2023-05-15 14:30:45")

Result

45

Function

TODAY

Description

Returns current date

Example

TODAY()

Result

[current date]

Function

WEEKNUM

Description

Gets week number

Example

WEEKNUM("2023-05-15")

Result

20

Function

ISOWEEKNUM

Description

Gets ISO week number

Example

ISOWEEKNUM("2023-05-15")

Result

20

Function

YEAR

Description

Extracts year

Example

YEAR("2023-05-15")

Result

2023

Function

DATEDIF

Description

Date difference

Example

DATEDIF("2023-01-01", "2024-01-01", "Y")

Result

1

Function

EDATE

Description

Add/subtract months

Example

EDATE("2023-01-01", 1)

Result

"2023-02-01"

Function

EOMONTH

Description

End of month

Example

EOMONTH("2023-01-01", 0)

Result

"2023-01-31"

Function

WEEKDAY

Description

Day of week

Example

WEEKDAY("2023-01-01")

Result

7

Statistical Functions

Function

AVEDEV

Description

Average absolute deviation

Example

AVEDEV(2, 4, 8, 16)

Result

5

Function

AVERAGE

Description

Arithmetic mean

Example

AVERAGE(2, 4, 6, 8)

Result

5

Function

AVERAGEA

Description

Average including text/logical

Example

AVERAGEA(2, 4, TRUE, "6")

Result

2.33

Function

AVERAGEIF

Description

Conditional average

Example

AVERAGEIF([1,2,3,4], ">2")

Result

3.5

Function

CORREL

Description

Correlation coefficient

Example

CORREL([1,2,3], [2,4,6])

Result

1

Function

COUNT

Description

Count numbers

Example

COUNT(1, 2, "3", TRUE)

Result

2

Function

COUNTA

Description

Count non-empty values

Example

COUNTA(1, "", "3", TRUE)

Result

3

Function

COUNTBLANK

Description

Count empty values

Example

COUNTBLANK(["", 1, "", 2])

Result

2

Function

COUNTIF

Description

Count values meeting criteria

Example

COUNTIF([1,2,3,4], ">2")

Result

2

Function

MEDIAN

Description

Middle value

Example

MEDIAN(1, 2, 3, 4, 5)

Result

3

Function

MODE

Description

Most frequent value

Example

MODE(1, 2, 2, 3, 4)

Result

2

Function

STDEV

Description

Standard deviation

Example

STDEV(1, 2, 3, 4, 5)

Result

1.58

Function

VAR

Description

Variance

Example

VAR(1, 2, 3, 4, 5)

Result

2.5

Information Functions

Function

ISBLANK

Description

Tests for blank value

Example

ISBLANK("")

Result

true

Function

ISERR

Description

Tests for error (except #N/A)

Example

ISERR(1/0)

Result

true

Function

ISERROR

Description

Tests for any error

Example

ISERROR(1/0)

Result

true

Function

ISEVEN

Description

Tests for even number

Example

ISEVEN(4)

Result

true

Function

ISLOGICAL

Description

Tests for logical value

Example

ISLOGICAL(TRUE)

Result

true

Function

ISNA

Description

Tests for #N/A

Example

ISNA(null)

Result

true

Function

ISNONTEXT

Description

Tests for non-text

Example

ISNONTEXT(123)

Result

true

Function

ISNUMBER

Description

Tests for number

Example

ISNUMBER(123)

Result

true

Function

ISODD

Description

Tests for odd number

Example

ISODD(3)

Result

true

Function

ISTEXT

Description

Tests for text

Example

ISTEXT("monday")

Result

true

Function

N

Description

Converts to number

Example

N(TRUE)

Result

1

Function

TYPE

Description

Returns value type

Example

TYPE(123)

Result

1

Additional Custom Functions

Function

CONTAINS

Description

Checks for substring

Example

CONTAINS("monday", "I love monday")

Result

true

Function

VALUE_EXISTS

Description

Checks if value exists

Example

VALUE_EXISTS("something")

Result

true

Function

HAS_VALUE

Description

Alternative to VALUE_EXISTS

Example

HAS_VALUE("something")

Result

true

Function

IS

Description

Equality check

Example

IS(5, 5)

Result

true

Function

START

Description

Gets start date from range

Example

START("2023-06-19+2023-08-04")

Result

"2023-06-19"

Function

END

Description

Gets end date from range

Example

END("2023-06-19+2023-08-04")

Result

"2023-08-04"

Function

ADD_DAYS

Description

Adds days to date

Example

ADD_DAYS("2019-01-20", 5)

Result

"2019-01-25"

Function

IGNORE

Description

Used to ignore or skip execution of an operation on a column

Example

IF(SEARCH("hello", "I love monday", 1) > 0, "Exist", IGNORE())

Result