Formula Components

Formulas and Databases

Reference

Formula Examples

min

Learn how to use the min function in Notion formulas.

1

min(number)

2

min(number, number)

3

min(number, number, ...)

1

min(4,1,9,-3) // Output: -3

2

β

3

// Assume prop("Num") contains 3

4

max(prop("Num"),13,5) // Output: 3

5

β

6

// Other data types must be converted to number

7

min(3,8,+false) // Output: 0

8

// Here, the + operator (unaryPlus) is used to convert

9

// false to a number (0)

`min()`

and max are useful for finding maximum and minimum values across multiple For that, you'll want to associate the rows to another common row via a Relation, then use a Rollup to calculate the max value among them. Here's a small example database.

This approach still has limitations, but since Notion hasn't provided a true query language for its database feature, it's the best we can currently do (unless you create an external tool via the official API).

The example database below contains quarterly sales data for a fictional company. The **Min** property displays the dollar amount from the worst quarter, while the **Worst Quarter** property displays which quarter had the worst performance.

min

College Info Geek on Notion

1

min(prop("Q1"), prop("Q2"), prop("Q3"), prop("Q4"))

`min()`

accepts numbers or number properties.Here, we simply pass each quarterβs property to the

`min()`

function in order to find the minimum quarterly sales value.1

// Compressed

2

if(prop("Q1") == prop("Min"), "Q1", if(prop("Q2") == prop("Min"), "Q2", if(prop("Q3") == prop("Min"), "Q3", "Q4")))

3

β

4

// Expanded

5

if(

6

prop("Q1") == prop("Min"),

7

"Q1",

8

if(

9

prop("Q2") == prop("Min"),

10

"Q2",

11

if(

12

prop("Q3") == prop("Min"),

13

"Q3",

14

"Q4"

15

)

16

)

17

)

Hereβs an example of how we can make

`min()`

more useful.Using a nested if statement, we compare the numeric value of each quarter property to that of the **Min** property.

If a quarterβs value matches that of the Min property, we output that quarterβs name.

β 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 21d ago

Copy link

On this page

Example Formulas

Example Database

View and Duplicate Database

βMinβ Property Formula

βWorst Quarterβ Property Formula