Notion

Notion Formula 2.0 introduced lambda functions, which let you define reusable logic inside a formula property. Without lambdas, you must repeat calculations or write long nested expressions. This article explains what lambdas are, how to define them with the let() and arrow functions, and how to use them to simplify complex formulas. You will learn … Read more

You want to reference a property value inside a Notion Formula 2.0 expression. The prop() function is the only way to pull data from a database column into a formula. Without prop(), your formula cannot access any property, making it impossible to calculate or transform values. This article explains how prop() works, how to write … Read more

You have a Notion database with a Person column, and you want to reference that person in a formula. However, when you write a formula that tries to read the Person property, Notion returns an error or empty result. This happens because Notion formulas cannot directly access Person, Created By, Last Edited By, or Date … Read more

When working with Notion databases, you often need to display a date as plain text in a formula column. Notion formulas do not have a dedicated TEXT function for dates. Instead, you must use the FORMAT function to convert a date property into a readable string. Many users encounter errors or unexpected output because the … Read more

When you write a formula in a Notion database, the property may show “Undefined” instead of the expected result. This usually happens because the formula references a property that is empty, has no value, or contains incompatible data types. Notion formulas require every referenced property to have a defined value for the calculation to work. … Read more

You want a Notion database cell to display a specific emoji based on the value of another property. For example, a green checkmark when a task is complete and a red X when it is not. Notion formulas do not support emoji characters directly inside the formula editor. The solution is to use the if() … Read more

Notion Formula 2.0 introduced the Map() and Filter() functions, which let you transform and filter arrays directly inside a formula. Before Formula 2.0, you had to rely on rollups or external tools to process lists of values. This article explains how Map() and Filter() work, shows practical examples you can copy and adapt, and covers … Read more

You need a sales tracker that calculates commission, profit margin, and deal stage values automatically. Standard Notion formulas handle one function at a time, but nested formulas let you combine multiple operations inside a single property. This article shows you how to build a complete sales tracker using nested if, prop, round, format, dateBetween, and … Read more