Skip to main content

Using Relations and Roll Ups Property in Super.so

This beginner’s guide explains how to use Relations and Rollups in Notion to connect databases, display related data, and track projects efficiently without formulas, perfect for dashboards and Super.so setups.

Charlene avatar
Written by Charlene
Updated over 2 weeks ago

Relations and Rollups are two of the most powerful features in Notion. They let you connect databases and summarize data without duplicating it, essential for dashboards, project trackers, and CMS setups like Super.so.

What is a Relation?

A Relation links one database to another.

Think of it like this:

  • Database A (Projects) → “owns” something

  • Database B (Tasks) → items that belong to Database A

  • A relation tells Notion: “This Task belongs to this Project”

Project Name

Website Redesign

Marketing Campaign

Task Name

Project

Homepage UI

Website Redesign

Mobile Layout

Website Redesign

Ad Copy

Marketing Campaign

Landing Page

Marketing Campaign

  • Here, the Tasks → Project property is a Relation.

  • Once set up, you can see from the Project page which tasks are linked.

How to Create a Relation

  1. Open the child database (Tasks).

  2. Add a new property → Type: Relation → select Projects database.

  3. Link each task to its Project by selecting the page from the dropdown.

  4. Optional: Enable two-way relation if available (this automatically creates a reciprocal property in Projects).

⚠️ Always select a page, don’t type text. Typing won’t create a real relation.

What Relations Allow You To Do

  • See related items in both databases automatically

  • Filter views by related items (e.g., show only Tasks for “Website Redesign”)

  • Prepare for rollups, without a relation, rollups can’t work

What is a Rollup?

A Rollup summarizes or calculates data from a related database.

  • It requires a relation first

  • It can count items, sum numbers, calculate averages, or filter by a property

Step 1: Make sure a Relation exists

  • Database A needs a relation property linking to Database B.

  • Example:

    • Database A = Projects

    • Database B = Tasks

    • Relation property = Tasks in Projects or Project in Tasks

This is the bridge that allows data to flow.

Step 2: Create the Rollup property in Database A

  • In Database A, add a new property → Type = Rollup

  • Select the Relation property (the one that links to Database B)

Step 3: Choose the property to display or summarize

  • In the Rollup, select which property from Database B you want to see:

    • Example: Task Name, Status, Estimated Progress

Did this answer your question?