Notion formula properties offer two text-related functions that behave very differently: Repeat() and Replace(). The Repeat() function duplicates a string a set number of times, while the Replace() function substitutes specific characters within a string. Many users confuse these two functions because both operate on text, but each solves a distinct problem. This article explains … Read more
When you work with financial data in a Notion database, raw numbers like 1234.5 do not clearly communicate currency values. Without formatting, you risk misreading amounts or confusing your team during budget reviews. Notion formulas do not have a built-in currency format function, but you can combine text functions and number rounding to produce clean … Read more
When you write a formula in a Notion database, you may see the error “Cannot find property” next to a property name you know exists. This error stops the formula from calculating and often appears after renaming a property or switching from a different formula editor. The root cause is that the formula still points … Read more
You need to calculate a project deadline in Notion but the default date property only stores a single date. Notion formulas let you compute future dates based on a start date, task duration, or business days, but the syntax can be confusing for new users. This article explains how to build date formulas for project … Read more
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