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