WorkToolFix
How to Fix Notion Rollup Showing Empty Despite Related Database Entries
Lab Recreated & Tested on 2026 Releases
NotionVerified for: Notion 2026 Desktop & Web, Formula 2.0

How to Fix Notion Rollup Showing Empty Despite Related Database Entries

Marcus Vance
Marcus Vance(Lead Workspace Systems Engineer)
Updated: 2026-11-18
5 min read
30-Second Quick Fix
Instant Solution

A Notion Rollup displays empty when the selected Target Property is set to a property with empty cells in the linked entries, or when the Relation is configured as one-way without reciprocal linking.

prop("Related Items").map(current.prop("Target Value")).filter(!empty(current))

Why Does This Error Happen?

With Notion Formula 2.0, standard rollups ignore rows where target relations are filtered out by view rules or when rollup calculations attempt to perform numerical operations on text strings.

Step-by-Step Diagnostic & Resolution Walkthrough

1Step 1: Verify the Underlying Relation Property

Open the database item. Check the Relation property to confirm at least one item is explicitly selected and linked in the relationship cell.

2Step 2: Check the Rollup Target Property Type

Click the Rollup column header > Edit Property. Verify the 'Relation' points to the correct database, and 'Property' selects an attribute that actually contains non-empty values.

3Step 3: Upgrade to Notion Formula 2.0 Syntax

If rollups remain buggy, replace the Rollup property with a Formula property using modern array methods for 100% reliability.

prop("Tasks").map(current.prop("Status")).unique()

Troubleshooting Matrix & Configuration Rules

Native Notion Rollup vs Formula 2.0 Rollup
FeatureNative Rollup PropertyFormula 2.0 (Modern Best Practice)
Speed & Refresh RateCached (Can delay up to 10s)Instant Real-Time Evaluation
Empty Cell FilteringShows blank or 0Custom filter() removes empty entries
Multiple CriteriaSingle property onlyCan chain .map() and .reduce() seamlessly

← Swipe horizontally to view full table →

Still Not Working? Check These Edge Cases

Scenario: Rollup calculating sum shows 0 instead of true total

Fix: The source property is formatted as text rather than a number. Convert the source property type to Number in the foreign database.

Frequently Asked Questions

Can a Notion rollup reference another rollup?

Yes, Notion supports rolling up properties that are themselves rollups, provided no circular dependency is created.