Finally understand the three features that turn Notion from notes into a real database tool.
Notion & ProductivityPDF · 6 pages· v1.0
4.7Relations, rollups, and formulas are the features that separate people who 'use Notion' from people who build powerful systems in it, and they're exactly where most users get stuck. This guide demystifies all three with concrete, worked examples you can follow along and reproduce. Who it's for: anyone who's hit the ceiling of basic Notion and watched a YouTube video that said 'just add a rollup' without explaining what a rollup actually is. If relations confuse you, if rollups show blank, or if formula errors make no sense, this is the explainer you needed. You'll build a small two-database example (Books and Authors) and use it to understand one-to-many vs many-to-many relations, how rollups follow a relation to aggregate data, and how to write formulas with the property() function, conditionals, and date math. Every concept is paired with a screenshot-style step description and the exact syntax. The guide includes a reference section of the most useful formulas for real workflows: progress bars, days-until-due, automatic status, and formatted text. It also covers the most common errors (greyed-out rollups, type mismatches, circular references) and how to fix each one. By the end you'll understand the mental model well enough to design your own connected databases instead of copying templates you can't modify. This is a skills guide, not a single template, the knowledge transfers everywhere.
No. Formulas are explained from scratch. If you've used a spreadsheet formula like =A1+B1, you're more than ready.
Yes. The guide uses Notion's current formula syntax (the 2.0 editor with prop() and named functions). Examples are copy-pasteable.
No. It's a skills guide built around a small teaching example. The goal is understanding so you can build your own relations, rollups, and formulas anywhere.
That exact problem is covered in the troubleshooting section. It's almost always a missing or misconfigured relation, and the guide shows how to fix it.
Read the full refund policy and trust & safety terms.