Formula Editor and Syntax

The Notion formula editor supports multi-line input, indentation, and comments. For complex formulas, multi-line formatting is usually easier to maintain.

lets(  originalPrice, prop("Original Price"),  discountRate, prop("Discount Rate"),  discountedPrice, originalPrice * (1 - discountRate),  round(discountedPrice, 2))

Comment syntax:

Notion formulas commonly use two syntax styles:

length(prop("Title"))

prop("Title").length()

Many functions can be written with dot-chained syntax. This is especially common with list functions:

prop("Tasks").filter(current.prop("Status") == "Completed").length()

If a dot-chained version does not work in your workspace, follow the syntax suggested by the formula editor.

In traversal functions such as map(), filter(), some(), every(), find(), and findIndex():

• current means the list item currently being processed.
• index means the current item's position, starting from 0.

prop("Tasks").filter(current.prop("Status") == "Completed")

prop("Tags").map(format(index + 1) + ". " + current)

let() defines one variable:

let(  discountedPrice,  prop("Original Price") * 0.8,  round(discountedPrice, 2))

lets() defines multiple variables:

lets(  originalPrice, prop("Original Price"),  discountRate, prop("Discount Rate"),  discountedPrice, originalPrice * (1 - discountRate),  round(discountedPrice, 2))

Variables are useful for reducing repetition and improving readability. For complex formulas, prefer lets().