#### This is your sign to try let() and lets()

Two notable functions within Notion's formula ecosystem are let() and lets(). These functions enable users to simplify their calculations and make complex formulas more manageable. In this blog post, we will explore the structure of both functions, break down how they work, and provide examples to illustrate their usage.

For this guide, I referenced the Notion Formula documentation and added my own examples and explanations.

#### Summary

Name | Syntax | Description | Example |

let() | let(variable, value, expression) | Designed to define a temporary variable within a formula. | let(price, 150, price * 1.1) → this will output 165 (which is basically 150 x 1.1) |

lets() | lets(variable1, value1, variable2, value2, ..., expression) | Designed to define multiple temporary variables within a formula. | lets(test1, 85, test2, 90, test3, 95, (test1 + test2 + test3) / 3) → this will output 90. |

### let() Formula

#### How let() works

The let() function is designed to define a temporary variable within a formula. Its syntax allows you to create a single variable that can be used in subsequent calculations or expressions.

Here's how you would write the formula statement in Notion:

let(variable, value, expression)

Notion Formula

복사

Breaking it down

•

variable: The name of the variable you're defining. (Do not enclose this in a quotation mark).

•

value: The value you want to assign to that variable.

•

expression: The formula or calculation that utilizes the defined variable.

#### Example of let()

formula

Search

### lets() Formula

#### How lets() works

The lets() function, on the other hand, is used for defining multiple variables at once. This is particularly useful for complex formulas where you need to refer to several intermediate values.

The general structure of lets() is:

lets(
variable1, value1,
variable2, value2,
...,
variablen, valuen,
...,
expression
)

Notion Formula

복사

Breaking it down

•

variable1, variable2, ...: Names of the variables you are defining. (Do not enclose this in a quotation mark).

•

value1, value2, ...: The corresponding values assigned to those variables.

•

expression: The final formula or calculation that uses the defined variables.

#### Example of formula

formula

Search

### Conclusion

The let() and lets() functions make formulas cleaner and easier to understand. If you have a repetitive calculation or value in the formula, be sure to use these functions.

Thank you for reading this tutorial! If you found it helpful, be sure to check out shop for my beautiful templates, which I am confident enough to say are a game-changer Subscribe to my newsletter and feel free to follow me on my social media for updates!

Happy Notion(ing)!

links

Search