Rollup
A database property that aggregates values from related records using Relation fields. Summarize data like sums, counts, averages, and specific properties across databases.
Definition
A Rollup in Notion is a database property type that lets you pull and aggregate data from entries in another database linked via a Relation property. After selecting the Relation field, you choose a specific property from the linked entries (e.g., number, date, checkbox) and apply an aggregation function (sum, average, min, max, count, or show unique values). Rollups automatically update when linked records change, providing dynamic summaries. You can use rollups to calculate project totals, count completed tasks, extract due dates, or list unique tags from related items.
Usage & Context
Use a Rollup when you need to summarize or extract information from a set of related records in Notion. First, ensure you have a Relation property linking two databases. Then add a Rollup property, choose the Relation, pick the target property from related entries, and select an aggregation function. Rollups are ideal in dashboards, project trackers, budgets, and CRM systems. For example, you can roll up task durations to show total project hours, count interview statuses in a hiring pipeline, or display the nearest deadline across related tasks.
Frequently Asked Questions
- Can I use a Rollup without a Relation property?
- No. Rollups depend on Relation properties to know which records to reference. Create a Relation first, then add a Rollup that points to that Relation.
- What aggregation functions does Rollup support?
- Notion Rollups support sum, average, minimum, maximum, count, count values, and showing unique values. For dates, you can also roll up earliest or latest date.
- How often do Rollups update?
- Rollups update in real time whenever linked records change. Edits to related entries or the Relation itself will immediately reflect in the Rollup.
- Can Rollups handle text or checkbox properties?
- Yes. You can roll up text properties to show all values or unique values, and checkbox properties to count checked vs. unchecked items.
- Can I filter or sort by a Rollup property?
- Absolutely. Once you’ve added a Rollup, you can use it in filters and sorts just like any other property to refine views based on aggregated data.
Benefits
Rollups save time and reduce manual work by automatically summarizing related data. They provide up-to-date insights across linked databases, making your workflow more efficient and your reports more accurate.
Related Terms
Aggregation
Feature that calculates summary values—sums, averages, counts, and more—across database entries, giving quick insights at the bottom of any view.
Relation
A Relation property in Notion links records between databases, letting you connect and view associated items across tables for richer, interlinked workflows.
Database Relations
A property linking entries across Notion databases, creating bidirectional connections for dynamic, relational data modeling and insights.
Conclusion
Rollups are a powerful Notion feature that unlock dynamic, cross-database summaries. By linking data with Relations and aggregating with Rollups, you create living dashboards and reports that adapt as your projects evolve.
Ready to roll up form responses with NoteForms?
Try NoteForms for freeLoved by our customers
100.000+ users and companies have chosen NoteForms
to build beautiful & powerful forms with Notion