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
If you manage projects, track inventory, or organize client data in Notion, you often need to connect two separate databases. A relation property lets you link entries from one database to another so that information flows between them without manual copying. This article explains what a relation does, what prerequisites you need, and how to … Read more
When you connect databases in Notion, you can create a relation that links entries from one database to another. However, Notion offers two types of relations: one-way and two-way. A one-way relation displays linked entries only in the source database, while a two-way relation creates a reciprocal connection in the target database. This article explains … Read more
Rollup properties in Notion let you pull data from a related database and display it in your current database. For example, you can show the total project budget from a linked Tasks database or the average rating from a Reviews database. This feature is useful when you need to summarize or calculate values from a … Read more
You added a Rollup property to a Notion database and selected Sum as the calculation. The rollup column shows no value or displays an error instead of a total. This problem usually happens because the source property type or the relation setup does not support numeric aggregation. This article explains the exact causes of a … Read more
When you have a Notion database with relations, you often want to see linked records directly on a page without opening the linked database. By default, a relation property shows the linked page name but not the full content of that page. This article explains how to configure a linked database view inside a page … Read more
Notion offers two ways to display the same database content in multiple places: Linked Database and Synced View. Many users confuse these features because both show data from a source database. However, they work differently and serve distinct purposes. This article explains the core differences between Linked Database and Synced View, including their behavior, editing … Read more
A self-referencing relation in a Notion database lets you link a row to another row inside the same table. This is useful for building dependencies between tasks, showing parent-child relationships in a project hierarchy, or managing employee reporting structures. The feature works by creating a relation column that points back to its own database instead … Read more
Notion databases let you link pages using Relation properties. When you connect two databases, each Relation cell can hold many linked pages. But Notion does not enforce a hard maximum on the number of pages you can link in a single Relation cell. Understanding the practical limits helps you avoid performance slowdowns and sync delays. … Read more