Notion Formula Reference
πŸŽ“ 14-Day Formulas Course🧠 Notion BasicsπŸ“‘ Notion Templates
Search…
Formula Reference Introduction
What is a Notion Formula?
Learn Notion's Basics
Formula Basics
Create a Formula Property
The Formula Editor
Notion Formula Syntax
Data Types
Formula Components
Constants
e
pi
true
false
Operators
Functions
Formulas and Databases
Reference Properties in Formulas
Formulas in Database Filters
Grouping Database Views by Formulas
Reference
Operator Precedence and Associativity
Converting Data Types
Fixing Notion Formula Errors
Property Reference Limits
Regular Expressions in Notion Formulas
Return Null/Empty Values in Formulas
Formula Examples
Count Multi-Select Tags
Powered By GitBook
pi
Learn how to use the mathematical constant pi in Notion formulas.
The mathematical constant pi (
ππ
) equals (roughly) 3.1415926559.
1
pi
​
ππ
 is the ratio between the circumference and diameter of a circle. This ratio is shared by all circles, no matter the size.
​
ππ
 can be used to calculate the circumference and area of a circle, volume and surface area of a sphere, and more.
You can learn more about
ππ
 here:
Prehistoric Calculus: Discovering Pi – BetterExplained

1
pi * 10
The above formula will calculate the circumference of a circle with a diameter of 10cm. It uses the simple equation
Ο€dΟ€d
, where
dd
 is the diameter of the circle.
In this case, the circumference would be approximately
31.4159265cm31.4159265cm
.

In this example database, the Formula (num) property calculates the area of a circle with a given radius, set in the Circle Radius (cm) property.

pi
College Info Geek on Notion

1
pi * prop("Circle Radius (cm)") ^ 2
The formula to calculate the area inside a circle is
Ο€r2Ο€r^2
. We can create this equation in a Notion formula using the code above:
  • pi is the Notion constant for
    ππ
    ​
  • prop("Circle Radius (cm)") uses the prop() function to pull in the value of the Circle Radius (cm) Number property
  • ^ 2 squares the radius of the circle
Other formula components used in this example:

1
format(round(prop("Formula (num)") * 100) / 100) + "cmΒ²"
This formula:
  1. 1.
    Intakes the output of the previous formula
  2. 2.
    Rounds it to the nearest hundredth (i.e. two decimal places)
  3. 3.
    Converts the resulting number to a String
  4. 4.
    Appends β€œcm²”
Note that Notion formulas do not support text formatting, so I’m using the actual Β² symbol. You can find this symbol here:
⬛❒▣²³ Square symbol, text box symbol (copy and paste)
To round the decimal to two decimal places, I use the following trick:
1
round(prop("Formula (num)")*100)/100
Notion’s built-in round() function only rounds numbers to the nearest whole integer. But this trick will output a rounded number to two decimals places instead. Learn more about this trick in the round function reference.
Other formula components used in this example:

​
 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.
Previous
e
Next
true
Last modified 21d ago
Copy link
On this page
Example Formula
Example Database
View and Duplicate Database
"Formula (Num)" Property Formula
"Pretty Formula" Property Formula