Why Notion Relation Limit Differs Between Free and Paid Plan
🔍 WiseChecker

Why Notion Relation Limit Differs Between Free and Paid Plan

Notion users on the Free plan often discover that they cannot add more than one relation property between the same two databases. The root cause is a hard limit enforced by Notion to encourage upgrades to paid plans. This article explains the exact relation limits for Free, Plus, Business, and Enterprise plans, why the limit exists, and how to work around it without upgrading.

Key Takeaways: Notion Relation Limits by Plan

  • Free plan relation limit: Maximum of 1 relation property between the same two databases.
  • Plus plan relation limit: Maximum of 3 relation properties between the same two databases.
  • Business and Enterprise plans: No limit on relation properties between the same two databases.

ADVERTISEMENT

How Notion Relation Properties Work and Why the Limit Exists

A relation property in Notion links one database row to a row in another database. For example, you can link a Tasks database to a Projects database so each task belongs to a project. By default, you can create multiple relation properties between the same two databases. Each relation property can have its own name and rollup settings.

The limit exists because each relation property consumes server-side indexing and query resources. Notion restricts the Free plan to one relation between any pair of databases to keep infrastructure costs low. The Plus plan allows up to three relations, which covers most small-team workflows. Business and Enterprise plans remove the limit entirely, as these plans are billed per seat and include higher resource quotas.

The limit applies per pair of databases, not per workspace. If you have databases A, B, and C, you can create one relation between A and B, one between A and C, and one between B and C on the Free plan. You cannot create a second relation between A and B.

What Counts as a Relation Property

A relation property is a column of type Relation added to a database. Rollup properties that reference a relation do not count as separate relations. You can add multiple rollups from the same relation without hitting the limit.

Steps to Check Your Current Plan and Relation Count

  1. Open Workspace Settings
    In the left sidebar, click Settings & Members. Then click Settings at the top of the panel.
  2. View Your Plan
    Under Plan, you will see Free, Plus, Business, or Enterprise. This is your current plan.
  3. Identify Relation Properties Between Two Databases
    Open the database that you suspect has multiple relations. Look at the column headers. Each column labeled Relation is a relation property.
  4. Count the Relations
    Note the target database for each relation. If you see two Relation columns both pointing to the same database, you have two relations between those databases. On the Free plan, this will cause an error when you try to add a second relation.

ADVERTISEMENT

If You Hit the Relation Limit: Workarounds and Fixes

Error Message: Cannot Add Second Relation on Free Plan

When you try to add a second relation property between the same two databases on the Free plan, Notion shows a red error banner: You have reached the limit of relation properties between these two databases. The relation is not created.

To work around this without upgrading, you can use one of these methods:

  • Use a single relation with multiple rollups. Add one relation and then create multiple rollup properties that display different fields from the target database. Rollups do not count toward the relation limit.
  • Create a lookup database. Duplicate the target database and create a relation to the duplicate. This uses a different pair of databases, so the limit does not apply.
  • Use a formula with relation data. Instead of a second relation, use a formula property that extracts data from the existing relation using functions like prop(Relation Name).map(current.prop(Field)).

Error Message: Third Relation Fails on Plus Plan

On the Plus plan, you can add up to three relations between the same two databases. If you try to add a fourth, Notion shows a similar error. The only workaround on the Plus plan is to upgrade to Business or Enterprise, or use the rollup and formula workarounds listed above.

Notion Free vs Plus vs Business: Relation Limits Compared

Item Free Plus
Maximum relations per pair of databases 1 3
Maximum relations per pair of databases (Business & Enterprise) N/A Unlimited
Rollup properties per relation Unlimited Unlimited
Workaround using rollup Yes Yes

The table above shows that the core difference is the count of relation properties. Both Free and Plus plans allow unlimited rollups from a single relation. Business and Enterprise plans remove the limit entirely.

Common Misconceptions About Notion Relation Limits

I can add one relation between A and B and another between B and A

This is not true. A relation is bidirectional. Adding a relation from A to B also creates a relation from B to A. Notion counts this as one relation between the pair. You cannot add a second relation in the reverse direction.

The limit applies per workspace

The limit applies per pair of databases, not per workspace. You can have unlimited pairs of databases, each with one relation on the Free plan.

Deleting a relation frees up a slot

Yes. If you delete one of the two relations between the same databases, you can add a new relation in its place. The limit is on the current count, not a historical count.

Conclusion

You now know that the Free plan allows only one relation between any two databases, the Plus plan allows three, and Business and Enterprise plans have no limit. To work around the limit, use rollup properties or formula fields to extract additional data from a single relation. If you need multiple relations for complex workflows, consider upgrading to the Plus plan or higher. An advanced tip: use the prop().map().current pattern in formulas to simulate multiple relations from one relation property.

ADVERTISEMENT