Functions
Learn how to use the built-in functions within Notion formulas.
In programming, a function is a reusable bundle or "chunk" of code. Functions have names which, when called elsewhere in the program, execute the function's code.
Functions can also take in outside data (these are called arguments), and return new data.
In Notion formulas, you cannot define your own functions. However, Notion has provided many built-in functions you can use.
1
length("Monkey D. Luffy") // Output: 15
Here's a list of every function available for use in a Notion formula. Click a function to learn more about how it works and see more examples.
Function | Data Output Type | Example | Output |
|---|---|---|---|
String | concat("Roronoa "," Zoro") | Roronoa Zoro | |
String | join(", ","Luffy ","Zoro","Nami","Chopper") | Luffy, Zoro, Chopper | |
String | slice("Dangerfield",0,6) | Danger | |
Number | length("Monkey D. Luffy") | 15 | |
String | format(4) | 4 (as a string) | |
Number | toNumber("42") | 42 (as a number) | |
Boolean | contains("Monkey D. Luffy", "Luffy") | True | |
String | replace("Pogo","Po","Dog") | Doggo | |
String | replaceAll("Dogs Dogs Dogs","Dogs","Cats") | Cats Cats Cats | |
Boolean | test("Monkey D. Luffy", "Luffy") | True | |
Boolean | empty("") | True | |
Number | abs(-42) | 42 | |
Number | cbrt(64) | 4 | |
Number | ceil(4.2) | 5 | |
Number | exp(2) | 7.389056098931 | |
Number | floor(4.2) | 4 | |
Number | ln(20) | 2.995732273554 | |
Number | log10(1000) | 3 | |
Number | log2(64) | 6 | |
Number | max(3,5,4) | 5 | |
Number | min(4,1,9,-3) | -3 | |
Number | round(4.5) | 5 | |
Number | sign(-5) | -1 | |
Number | sqrt(16) | 4 | |
Date | start(prop("Date")) | August 18, 2022 | |
Date | end(prop("Date")) | August 25, 2022 | |
Date | now() | August 18, 2022 2:10 PM | |
Number | timestamp(now()) | 1660853460000 | |
Date | fromTimestamp(1656012840000) | June 23, 2022 1:34 PM | |
Date | dateAdd(now(),3,"months") | November 18, 2022 2:11 PM | |
Date | dateSubtract(now(),3,"months") | May 18, 2022 2:11 PM | |
Number | dateBetween(now(),prop("Date"),"days") | 9 | |
String | formatDate(now(), "MMMM DD YYYY") | August 18 2022 | |
Number | minute(now()) | 9 | |
Number | hour(now()) | 14 | |
Number | day(now()) | 4 | |
Number | date(now()) | 18 | |
Number | month(now()) | 7 | |
Number | year(now()) | 2022 | |
String | id() | c5d67d15854744869cc4a062fb7b1377 |
Functions can accept other functions as arguments, so long as the inner function outputs the data type that the outer function requires.
Here are a couple examples:
1
slice(format(1932),0,2)
2
// Output: 19
3
4
// Expanded form
5
slice(
6
format(1932),
7
0,
8
2
9
)
10
11
---
12
13
// Get the century name (e.g. "20th") from a year (expressed as a number)
14
concat(format(add(toNumber(slice(format(1932),0,2)),1)),"th")
15
// Output: 20th
16
17
// Expanded form
18
concat(
19
format(
20
add(
21
toNumber(
22
slice(
23
format(1932),
24
0,
25
2
26
)
27
),
28
1
29
)
30
),
31
"th"
32
)
For more examples, see the example databases for most of the functions. The majority in this reference use other functions as arguments in order to do useful things. To start, I'll recommend checking out the format function's example database.
My name is Thomas Frank, and I'm a Notion-certified writer, YouTuber, and template creator. I've been using Notion since 2018 to organize my personal life and to run my business and YouTube channel. In addition to this formula reference, I've created a free Notion course for beginners and several productivity-focused Notion templates. If you'd like to connect, follow me on Twitter.
Last modified 5mo ago