Most Notion Teams Don't Know Rollups Replace Their Zapier Bill
Notion's rollup field can auto-sum, average, and count data across linked databases in real time—on every plan, at no extra cost. Teams paying for external automations rarely realize it's already built in.
01. What It Is
A rollup is a special Notion database property that reaches into records connected through a Relation and performs a calculation on their values. Instead of manually adding up numbers from a dozen linked pages, the rollup does it automatically and updates the instant any linked record changes.
Rollups support a surprisingly deep set of functions. For numbers you get Sum, Average, Median, Min, Max, Range, and several Count modes (Count all, Count values, Count unique values). For dates there's Earliest date, Latest date, and Date range. For checkboxes there's Percent checked. This means a single rollup can answer questions like 'total revenue across all deals,' 'average score across all reviews,' or 'how many tasks are complete.'
The part most teams miss is that these calculations run natively, in real time, on every Notion tier including Free—no premium lock, no per-task fee. Where people reach for Zapier or Make to shuttle numbers between tools, a properly designed relation-plus-rollup structure often replaces the whole workflow inside Notion itself, at zero marginal cost.
Why It Matters
External automation tools charge per task or per run, and many teams wire up Zapier or Make just to aggregate numbers between lists. A rollup does the same aggregation instantly, forever, for free—turning a recurring subscription cost into a one-time setup. It also updates in real time, so dashboards stay accurate without any sync delay or run limits.
Who Can Benefit
- Small teams tracking budgets, sales pipelines, or project hours who want live totals without extra software
- Freelancers and founders who want a single Notion dashboard instead of a stack of paid automation subscriptions
- Project managers who need rolled-up completion percentages and deadlines across many tasks
- Anyone building a personal finance, habit, or inventory tracker who wants automatic sums and counts
02. Step-by-Step Guide
- 1
Create a Relation between two databases first
Rollups can't exist without a Relation. In the database that will show the summary, add a new property of type 'Relation' and connect it to the second database (for example, a 'Projects' database related to a 'Tasks' database). Link the relevant records so Notion knows which pages belong together.
- 2
Add a Rollup property
In the same database, click the '+' to add a new property and choose 'Rollup'. This opens a configuration panel with three choices you need to fill in.
- 3
Pick the Relation to pull from
Set the 'Relation' field to the relation property you just created. This tells the rollup which linked records to look at.
- 4
Choose the target property
Set 'Property' to the field inside the linked records you want to aggregate—for example a 'Cost' number field, a 'Due date' field, or a 'Done' checkbox.
- 5
Choose the calculation
Set 'Calculate' to the aggregation you need: Sum for totals, Average or Median for typical values, Min/Max/Range for extremes, Count all/values/unique for counts, Earliest/Latest date or Date range for dates, or Percent checked for checkboxes. The result appears instantly and recalculates whenever linked records change.
Pro Tips
- Build layered structures: a database rolls up its linked records, and a parent database rolls up those results—useful for department → team → member breakdowns.
- Combine a rollup with a Formula property to do extra math on the aggregated value, such as multiplying a summed cost by a tax rate, since the formula can reference the rollup's output.
- Use 'Percent checked' on a tasks relation to get an automatic completion bar for each project without any manual tracking.
- Count unique values is great for de-duplicating—like counting how many distinct clients appear across a list of orders.
Warnings & Limitations
- You cannot roll up a rollup. Notion blocks nested rollups to prevent circular logic, so plan multi-level aggregations using formulas as intermediaries.
- There's no hard cap on related records, but Notion has confirmed performance can degrade when you attach thousands of related pages while using rollups, formulas, or table calculations.
- When accessed through the Notion API, rollups return a maximum of 25 references—so integrations reading rollups with more than 25 related records may see truncated results.
- The relation must be created before the rollup; a rollup has nothing to calculate until records are actually linked.
Related Tricks
Notion Can Fill In Database Fields By Itself—And Most Teams Miss It
Before you pay for another Zapier seat, know this: Notion's built-in AI can classify, summarize, and extract data into your database properties automatically—no external automation tool required.
Most Notion Teams Still Pay for Zapier—When Notion Can Do It Natively
Notion's database automations can trigger AI summaries, translations, and extractions the moment a property changes—no Zapier required. Up to 60% of your Notion-touching workflows may be redundant.
Most Notion Users Don't Know It Can Fill Entire Database Records by Itself
Notion's AI can do far more than rewrite paragraphs — it can intelligently populate whole database rows from a single field, automating data entry for CRMs, hiring pipelines, and project trackers.