You have a Notion database with a relation column linked to another database, and you added a rollup to pull a property from the related page. The rollup column shows nothing — it is blank or empty — even though the related page clearly has the target property filled in. This happens because Notion rollups depend on a specific chain of database settings and property types that must match exactly. This article explains the technical cause of empty rollups and provides step-by-step fixes to restore the data.
Key Takeaways: Fixing an Empty Notion Rollup
- Relation column must point to the correct database: If the relation links to the wrong database or no database, the rollup has no source to read from.
- Rollup must reference a property that exists in the related database: A rollup cannot pull from a property that was renamed, deleted, or is of an unsupported type.
- Rollup property type must match the source property type: Using a number rollup on a text property or vice versa causes the rollup to remain empty.
Why a Notion Rollup Returns Empty
A Notion rollup works by reading a property from a page that is linked through a relation column. The rollup does not store its own data; it displays data already stored in the related database. If the rollup returns empty, one of these three conditions is broken: the relation column does not connect to the correct database, the target property does not exist or is unsupported, or the rollup property type is incompatible with the source property type.
Notion supports rollups for text, number, date, select, multi-select, checkbox, email, phone, URL, formula, and rollup properties. Properties like files and media, people, or created time are not supported as rollup targets. If you try to roll up an unsupported property, the rollup column stays blank without an error message.
Another common cause is that the relation column uses a filter that excludes the page you expect to see. When a relation is filtered, only pages matching that filter appear in the relation. If the related page is excluded by the filter, the rollup has no page to read from and returns empty.
Steps to Fix an Empty Rollup in Notion
Follow these steps in order. After each step, check if the rollup populates. If it does, you can stop.
- Verify the relation column links to the correct database
Open the database that contains the rollup column. Click the relation column header and select Edit property. In the Relation field, confirm that the linked database is the one that contains the source property. If it is wrong, click the current database name and select the correct one from the list. Click Save. - Check that the target property exists and is spelled correctly
Go to the related database. Look at its column headers and confirm that the property you want to roll up exists with the exact same name. If the property was renamed after the rollup was created, the rollup still looks for the old name and returns empty. Rename the property back or recreate the rollup with the new name. - Ensure the target property type is supported by rollups
Supported types: text, number, date, select, multi-select, checkbox, email, phone, URL, formula, and rollup. Unsupported types: files and media, people, created time, last edited time, created by, last edited by, and relation. If the target property is unsupported, create a formula property in the related database that copies the value into a supported format, then roll up that formula. - Match the rollup property type to the source property type
Click the rollup column header and select Edit property. In the Property field, confirm that the rollup type (shown below the property name) matches the source property type. For example, if the source is a number, the rollup must be set to number. If the source is text, the rollup must be text. If they do not match, change the rollup type by clicking the type dropdown and selecting the correct one. Click Save. - Remove any filter on the relation column
Click the relation column header and select Edit property. Scroll to the Filter section. If a filter is active, click Remove filter. Click Save. A filtered relation can exclude the page that contains the data you expect to see. - Recreate the rollup column from scratch
If the previous steps do not work, delete the rollup column. Click the column header, select Delete property, and confirm. Add a new rollup column by clicking the + icon at the right edge of the database header, selecting Rollup, naming it, choosing the relation column, and selecting the target property.
If Notion Still Shows Empty Rollup After the Main Fix
Rollup shows empty only for some rows
Open the page that has an empty rollup. Look at the relation column on that page. If the relation column is blank, the rollup has no linked page to read from. Click into the relation column and select the correct related page. The rollup should populate immediately.
Rollup returns empty after duplicating a database
When you duplicate a database, the relation column links to the original database, not the duplicated one. The rollup tries to read from the original database, but the duplicated database may not have the same pages or the original database may be inaccessible. To fix this, delete the existing relation column and rollup column. Create a new relation column that links to the duplicated database. Then add a new rollup column that references the new relation.
Rollup shows empty in a linked database view
A linked database view is a copy of the original database displayed elsewhere. The rollup in the original database works, but the linked view shows empty. This usually means the linked view has a filter that hides the related pages. Click the linked database view header, select Filter, and clear any active filters. If the linked view uses a different source database, the rollup may point to a relation that does not exist in that source.
Notion Rollup Behavior: Supported vs Unsupported Property Types
| Source Property Type | Supported as Rollup Target | Notes |
|---|---|---|
| Text | Yes | Works with rollup type set to text |
| Number | Yes | Works with rollup type set to number |
| Date | Yes | Works with rollup type set to date |
| Select | Yes | Works with rollup type set to text or select |
| Multi-select | Yes | Works with rollup type set to text |
| Checkbox | Yes | Works with rollup type set to checkbox |
| Yes | Works with rollup type set to text | |
| Phone | Yes | Works with rollup type set to text |
| URL | Yes | Works with rollup type set to text |
| Formula | Yes | Works with rollup type set to match the formula output type |
| Rollup | Yes | Works with rollup type set to match the nested rollup output type |
| Files and media | No | Rollup will remain empty; use a formula to reference the file name instead |
| People | No | Rollup will remain empty; use a formula to extract the person name |
| Created time | No | Rollup will remain empty; use a formula to capture the creation date |
| Last edited time | No | Rollup will remain empty; use a formula to capture the last edit date |
| Created by | No | Rollup will remain empty; use a formula to extract the creator name |
| Last edited by | No | Rollup will remain empty; use a formula to extract the last editor name |
| Relation | No | Rollup will remain empty; use a formula to reference the relation page title |
You can now identify and fix any empty rollup in Notion by checking the relation link, target property existence, property type compatibility, and relation filters. If the rollup still fails, recreate the column from scratch. As an advanced tip, use a formula property in the related database to convert unsupported property types into text, then roll up that formula for reliable data transfer.