Welcome to a reference guide to Notion Formulas. Hopefully you find this useful and please feel free to comment (Notion account needed) to make suggestions, updates or fixes needed.

<aside> 💡 Comment on this line to make requests (or anything else really)!

You can also email me at [email protected]

</aside>

Properties

To refer to a different field property, use the prop("Field Name") syntax.

prop("Name")

This will return, My Entry as shown in the example above.

Constants

There are a few available constants within the formulas:

e

The base of the natural logarithm. This is also known as Eulers Number or Napier's Constant. The value is 2.718281828459045.

So when would we use something like this?

• Compound Interest

pi

The ratio of a circle's circumference to its diameter.

true

A simple, always true, variable.

false

A simple, always false, variable.

Operators

Logic

• if

Number

• add
• divide
• mod
• multiply
• pow
• subtract
• unaryMinus
• unaryPlus

Conditional

• and
• equal
• larger
• largerEq
• not
• or
• smaller
• smallerEq
• unequal

Functions

String

• concat
• contains
• format
• join
• length
• replace
• replaceAll
• slice
• test

Date

• date
• dateAdd
• dateBetween
• dateSubtract
• day
• end
• formatDate
• fromTimestamp
• hour
• minute
• month
• now
• start
• timestamp
• year

Moment.JS Date Formats