Notion Relation Order: How to Control the Display Sequence

Notion relation properties link two databases, but the order in which linked records appear can feel random or frustrating. By default, Notion sorts relations by the order records were added to the source database, not by any logical sequence you control. This article explains how relation order works and shows you concrete methods to reorder linked records using database views, formulas, and manual sorting.

How Notion Relation Order Works by Default

When you create a relation property between two databases, Notion stores the linked record IDs in the order they were selected. If you add records to the relation one by one, the order matches the sequence you picked. However, if you use a rollup or a linked database view to display the related records, Notion applies its own default sort: records appear in the order they were created in the source database. This means the oldest records appear first and the newest appear last, regardless of any manual arrangement you made inside the relation cell.

The source database does not have a built-in “order” column. Notion relies on the creation timestamp and any sort rules you apply to the database view. If you want a specific sequence, you must create a view that sorts by a property you control, such as a rank number or a date field. Without this, the relation order will always fall back to creation order.

Why the Default Order Feels Random

The confusion happens because the relation property on a parent page shows only the first few linked records and a count. Expanding that list reveals the default order. If you have multiple users adding records at different times, the sequence appears mixed. Notion does not allow you to reorder items inside the relation cell itself. The only way to control the sequence is through the source database view settings.

Steps to Control Relation Display Sequence

You have three reliable methods to control the order of related records. Each method works for different use cases. Choose the one that matches how you use the relation.

Method 1: Sort the Source Database View

This is the simplest method. The relation property respects the first sort condition applied to the default view of the source database. If you change the sort on that view, the relation order updates automatically.

1. Open the source database
   Go to the database that contains the records linked by the relation. This is the database on the other side of the relation.
2. Create a sort rule
   Click the menu icon (three dots) in the top-right corner of the database. Select Sort from the dropdown. Click Add a sort.
3. Choose a property to sort by
   Select a property such as Created time, Last edited time, or a custom number property. Set the order to Ascending or Descending. The relation will now display records in this order.
4. Verify the relation
   Return to the parent page that contains the relation property. Expand the relation list. The records should appear in the same order as the sorted source database view.

Method 2: Use a Formula Property for Custom Rank

If you need a specific sequence that does not match any existing property, create a formula that assigns a numeric rank to each record. Then sort the source database view by that formula.

1. Add a formula property to the source database
   Open the source database. Click the + button in the last column header. Select Formula as the property type. Name it Order Rank.
2. Write the formula
   In the formula editor, enter a number that represents the rank for each record. For manual ranking, use a simple number like 1, 2, 3. For dynamic ranking based on another property, use a formula such as prop(“Date”).formatDate(“YYYYMMDD”) to generate a sortable number. Click Done.
3. Assign rank values to each record
   Manually edit the formula result for each record. Notion formulas cannot be edited per record unless you use a separate number property. Instead, use a Number property and let the formula read that number. Create a Number property called Rank, fill in values, then set the formula to prop(“Rank”).
4. Sort the database view by the formula
   Click the database menu, select Sort, add a sort, and choose the formula property Order Rank. Set the order to Ascending.
5. Check the relation
   The relation on the parent page now displays records in the order defined by the rank values.

Method 3: Use a Linked Database View with Manual Drag-and-Drop

This method gives you full manual control. Instead of using the relation property directly, create a linked view of the source database on the parent page. You can then drag rows to any position, and that order persists.

1. Create a linked database view
   On the parent page, type /linked and select the source database. A linked view appears.
2. Filter to show only related records
   Click the linked view menu. Select Filter. Add a filter that matches the relation condition. For example, if the relation is called Projects, filter by Projects contains and select the current page name. This ensures only records linked to this parent appear.
3. Enable manual sort
   In the linked view menu, click Sort. Remove any existing sort rules. This allows manual drag-and-drop to work.
4. Drag rows to reorder
   Hover over the left edge of a row until the six-dot handle appears. Click and drag the row to the desired position. Release to lock the order.
5. Save the view
   The manual order is saved automatically. The linked view now displays records in the sequence you set.

Common Mistakes and Limitations When Reordering Relations

Even after applying a sort, you may encounter situations where the relation order does not behave as expected. Below are the most frequent issues and how to resolve them.

Relation Order Does Not Change After Sorting the Source View

The relation property reads the default view of the source database. If you applied the sort to a different view, the relation will not update. Open the source database and ensure the sort is applied to the view named All or the view that is set as the default. Also, check that no other sort is overriding your rule. Only the first sort condition in the list is used by the relation.

Manual Drag-and-Drop Order Resets After Refresh

Manual order in a linked view only persists if the view has no active sort rules. If you add a sort rule after arranging rows, Notion overrides the manual order with the sort rule. To keep manual order, remove all sort rules from the linked view. Additionally, manual order is specific to that view. If you create a new linked view on a different page, you must reorder the rows again.

Relation Shows Duplicate or Missing Records

If the relation property shows records that should not appear or misses records, the filter in the linked view may be incorrect. Verify that the filter condition matches the relation property name exactly. Also check that the source database does not have a filter that hides certain records. The relation always shows all linked records, but a linked view filter can limit what you see.

Method	Ease of Setup	Persistence of Order
Sort source database view	Easy, one click	Automatic, updates with sort changes
Formula property with rank	Medium, requires formula setup	Automatic, based on rank values
Manual drag-and-drop in linked view	Easy, but needs per-page setup	Persistent only in that specific view

You now have three methods to control the display sequence of related records in Notion. Start with the simplest method: sort the source database view by a date or number property. If you need a custom sequence that does not match any existing property, use a formula with a rank number. For full manual control on a single page, use a linked database view with drag-and-drop. Remember that each linked view stores its own order, so you may need to repeat the manual setup on multiple pages. An advanced tip: combine a formula rank with a linked view filter to create a dynamic, auto-sorted list that updates as you add new records.