When you use a Relation property in a Notion database, you might expect to filter the linked records by conditions that combine two or more properties, such as “Status is Done and Priority is High.” However, Notion’s Relation filter only allows a single predicate — a condition based on one property. This limitation applies to … Read more
You want to see which meeting attendees connect to which projects and decisions inside Notion. A relation graph shows these links visually without switching between pages. This article explains how to build a relation graph that maps meeting attendees to their associated meetings, projects, and action items. You will learn the database structure, relation setup, … Read more
You are viewing a Notion database rollup property and the cell displays the word “Calculating” instead of the expected number, date, or text value. This usually means the rollup engine cannot finish processing the formula because of a circular reference, a broken relation, or an excessively large dataset. In this article, you will learn why … Read more
Notion users often need to track events or deadlines that depend on data from another database. A relation property links two databases, but calendar views require a date property to display items on the timeline. By default, a relation property does not carry date values from the related database. You can use a rollup property … Read more
You want to track Objectives and Key Results in Notion but need a single database that shows progress rolled up from individual tasks to key results and then to objectives. Without proper relations, you end up with disconnected tables and manual progress calculations. Notion’s relation and rollup features let you link databases so that a … Read more
You see the error “Cannot calculate aggregation” when a Notion rollup property tries to aggregate values from an empty set of related database items. This happens because Notion rollups require at least one related record to perform functions like sum, average, or count. This article explains why the error occurs and provides a default workaround … Read more
You try to add a Relation property to a Notion database but the source database has a sub-item hierarchy. The Relation option appears grayed out or does not show the expected source database. This happens because Notion restricts Relation properties from pointing to databases that contain sub-items. This article explains the technical limitation and provides … Read more
Tracking vendors, contracts, and invoices in separate Notion databases can lead to duplicate data entry and broken links between records. A Notion Relation property connects two databases so that records in one database can reference records in another. This article explains how to create Relation properties between a Vendor database, a Contract database, and an … Read more
When you create a Rollup property in a Notion database, you can change its name only during the initial setup. After you click anywhere outside the property editor, the name becomes locked and cannot be edited directly. This happens because Notion treats the Rollup property name as a fixed identifier once it is saved, unlike … Read more
When you link two databases in Notion using a Relation property, you often need to display or calculate information from the linked item without manually copying it. The Sub-Item Property Inheritance feature allows a child database item to automatically inherit a property value from its parent item through the relation. This article explains how to … Read more