
How to Fix Notion Rollup Showing Empty Despite Related Database Entries

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
| Feature | Native Rollup Property | Formula 2.0 (Modern Best Practice) |
|---|---|---|
| Speed & Refresh Rate | Cached (Can delay up to 10s) | Instant Real-Time Evaluation |
| Empty Cell Filtering | Shows blank or 0 | Custom filter() removes empty entries |
| Multiple Criteria | Single property only | Can chain .map() and .reduce() seamlessly |
← Swipe horizontally to view full table →
Still Not Working? Check These Edge Cases
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.