How to Use Notion Database Linked View With Pre-Applied Sort and Filter
🔍 WiseChecker

How to Use Notion Database Linked View With Pre-Applied Sort and Filter

You want to show a filtered subset of a database in another page without duplicating data. A linked view in Notion displays the same source database but can have its own sort and filter rules. This article explains how to create a linked view, apply sort and filter conditions, and keep them separate from the original view.

A linked view is a copy of a database view that points to the same source data. Any changes to the source database appear in all linked views. The key is that each linked view can have its own sort order and filter criteria, independent of the original view.

You will learn the exact steps to create a linked view, set sort and filter rules, and avoid common mistakes that break the view configuration.

Key Takeaways: Creating a Notion Linked View With Custom Sort and Filter

  • Create linked view via the + menu or /linked command: Inserts a copy of the current view that remains connected to the source.
  • Sort and filter are per-view settings: Each linked view stores its own sort and filter rules independently of other views.
  • Always use the green Linked View indicator: Confirms you are editing a linked view and not the original database.

ADVERTISEMENT

What Is a Notion Linked View and Why Use It

A linked view is a snapshot of a database view that you place on another page. The source database is the original page where you created the database. The linked view shows the same rows and columns, but you can change its layout, sort order, and filter settings without affecting the source view. This is useful when you want to show only high-priority tasks on a dashboard or display overdue items on a weekly review page.

Every linked view has a green bar at the top with the text Linked View of [Database Name]. This indicator tells you that you are working with a linked instance. If you see a blue bar, you are editing the original database view. Changes to the source database, such as adding a new row or editing a property, appear in all linked views. But sort and filter changes you make in the linked view do not propagate back to the source.

How Sort and Filter Work in Linked Views

Sort rules reorder rows based on property values. Filter rules hide rows that do not meet specified conditions. In a linked view, you can set both independently. For example, the original view might show all tasks sorted by due date. A linked view on a project page can show only tasks with status = In Progress and sort by priority. This separation is maintained even if someone changes the sort or filter on the original view.

Steps to Create a Linked View and Apply Sort and Filter

Follow these steps to create a linked view from an existing database and configure its sort and filter rules.

  1. Open the destination page
    Navigate to the page where you want the linked view to appear. This can be a different page from the source database page.
  2. Insert a linked view of the database
    Type /linked and select Linked view of database from the menu. Alternatively, click the + icon on the page, choose Link to database, and then select the source database from the list.
  3. Choose the source view
    A dialog appears asking you to pick which view of the source database to link. Select the view that contains the columns and layout you want. For example, select Table view or Board view. Click Create linked view.
  4. Confirm the linked view indicator
    Look at the top of the inserted database block. You should see a green bar with the text Linked View of [Database Name]. This confirms you are editing a linked instance, not the original.
  5. Open the view menu
    Click the current view name at the top-left of the database block. It appears as a dropdown with the view name, such as All Tasks or My View.
  6. Add a sort rule
    Click Sort at the top of the view menu. Click + Add a sort. Select a property to sort by, such as Due Date, and choose ascending or descending. Click Done. The rows reorder immediately.
  7. Add a filter rule
    Click Filter at the top of the view menu. Click + Add a filter. Select a property, a condition (for example, Status is In Progress), and a value. Click Done. Rows that do not match the condition are hidden.
  8. Save the view
    Click the view name again and select Save as. Give the view a descriptive name, such as In Progress – Sorted by Priority. This saves the sort and filter rules to this linked view only.
  9. Rename the linked view tab
    Click the view name dropdown, then click Rename. Type a name that reflects the sort and filter applied, for example, High Priority Items. Press Enter to save.

After completing these steps, the linked view displays only the rows that match your filter, sorted according to your rules. You can repeat steps 5 through 9 to add more sort or filter conditions. Each linked view can have its own set of rules.

ADVERTISEMENT

Common Mistakes and Issues With Linked Views

Linked View Shows All Rows Instead of Filtered Results

This happens when you apply the filter to the original view instead of the linked view. Check the green bar at the top. If you see a blue bar, you are editing the original database. Close that tab and return to the page where you inserted the linked view. Apply the filter again from that page.

Sort Order Resets After Refreshing the Page

You likely did not save the view after applying the sort. Click the view name and select Save as to create a new view that stores the sort rule. If you only click Done without saving, the sort is temporary.

Linked View Shows a Different Database Than Expected

You may have accidentally linked to a different database. Delete the linked view block by hovering over it and clicking the six-dot handle, then selecting Delete. Reinsert the linked view and ensure you select the correct source database from the list.

Cannot Add a Filter on a Rollup or Formula Property

Notion allows filters on most property types, but rollup and formula properties have limited filter conditions. For example, you cannot filter by a rollup that returns text with a condition like Contains. If you need to filter on such data, create a helper property of type Select or Text and use a formula to populate it, then filter on that helper property.

Linked View vs Original View: Capabilities Compared

Item Original View Linked View
Source data Directly edits the source database Shows same data, edits apply to source
Sort rules Affects all users viewing that view Independent per linked instance
Filter rules Affects all users viewing that view Independent per linked instance
Layout changes Changes saved to the source view Changes saved only to this linked view
Green bar indicator Blue bar Green bar with Linked View text
Can be placed on multiple pages No, only on the source page Yes, unlimited

Linked views give you the flexibility to present the same data in different ways across your workspace without altering the original database structure.

You can now create a linked view from any database in your workspace and apply sort and filter rules that are unique to that view. Try adding a linked view to a dashboard page and set a filter to show only tasks due within the next seven days. For an advanced use case, combine multiple linked views on one page, each with a different filter, to create a live dashboard that updates automatically as the source database changes.

ADVERTISEMENT