How to Build Notion Sync Dashboard for Workspace-Wide Status Monitoring

You want a single view that shows the status of all key projects, tasks, and metrics across your entire workspace. Notion does not have a built-in global dashboard, so you need to build one manually using linked databases, rollups, and formula properties. This article explains how to construct a sync dashboard that pulls live data from multiple source databases into one centralized page.

You will learn how to create linked database views, configure rollup and formula properties, and set up status indicators that update automatically. By the end, you can monitor work items, deadlines, and blockers from every team without switching between pages.

What a Notion Sync Dashboard Does and What You Need Before Building

A sync dashboard in Notion is a single page that displays live data from multiple source databases using linked database views. Each linked view connects to a source database and can be filtered to show only relevant items, such as tasks assigned to a specific team or projects with a deadline this month. The dashboard does not duplicate data; it reflects changes made in the source databases in real time.

Before you start, you need at least two source databases that contain related information. For example, a Projects database and a Tasks database where each task is related to a project. You also need a blank page that will serve as the dashboard. No special permissions are required beyond full access to the workspace, though you may need to duplicate a template if your team uses one.

Steps to Create the Sync Dashboard with Linked Databases, Rollups, and Formulas

Step 1: Create a Blank Dashboard Page

1. Open Notion and navigate to your workspace sidebar
   Click the plus icon next to your workspace name or press Ctrl + N to create a new page. Name it “Workspace Status Dashboard” or a name that fits your team.
2. Set the page type to full width
   Click the three-dot menu at the top right of the page, select “Turn into page style”, then choose “Full width”. This gives you more horizontal space for multiple database views.

Step 2: Add a Linked Database View for Each Source

1. Type /linked and select “Linked view of database”
   A menu appears listing all databases in your workspace. Choose the first source database, such as “Tasks”.
2. Name the view and apply a filter
   Click the view name at the top left of the database block and rename it to “Open Tasks”. Click the filter icon and set a filter: “Status” is “Not Done”. This ensures only active tasks appear.
3. Repeat for each source database
   Add a linked view for “Projects”, “Issues”, or any other database you want to monitor. Apply relevant filters, such as “Deadline” is “This month” or “Priority” is “High”.

Step 3: Create a Rollup Property to Aggregate Data

1. Open the source database that will receive the rollup
   For example, open your Projects database. Add a new property by clicking the plus icon in the top-right column header.
2. Set the property type to “Rollup”
   In the property editor, select “Rollup” as the type. Then choose the relation column that links to the Tasks database. In the “Property” dropdown, pick a numeric property from the related database, such as “Estimated Hours”. In the “Calculate” dropdown, select “Sum” to total the hours across all related tasks.
3. Name the rollup property
   Call it “Total Estimated Hours” or “Open Task Count” depending on what you are aggregating. The rollup property updates automatically when tasks are added or removed.

Step 4: Build a Formula Property for Status Indicators

1. Add a new property and set it to “Formula”
   In the same Projects database, click the plus icon and select “Formula”.
2. Write a formula that returns a status label
   For example, to show whether a project is on track based on the number of open tasks:
   if(prop("Open Task Count") == 0, "Complete", if(prop("Open Task Count") <= 5, "On Track", "At Risk"))
   This formula checks the rollup property "Open Task Count" and returns "Complete", "On Track", or "At Risk".
3. Add conditional formatting to the formula property
   Click the formula property name at the top of the column, then select "Edit property". Under "Color", choose a color for each possible value. For example, set "On Track" to green, "At Risk" to red, and "Complete" to blue.

Step 5: Arrange the Views on the Dashboard Page

1. Drag linked views into columns for better layout
   Click the six-dot handle at the top of a linked database block and drag it to the right of another block. A blue line appears indicating where the block will be placed. Release to create a column layout.
2. Add a heading above each view
   Type a heading such as "Open Tasks" or "Active Projects" above each linked view. Use a heading size that matches your page structure, like H2 or H3.
3. Hide unnecessary columns in each linked view
   Click the view name, select "Properties", and uncheck any columns that are not needed for monitoring. This reduces visual clutter.

Common Mistakes When Building a Sync Dashboard and How to Avoid Them

Linked View Shows All Items Instead of Filtered Items

If a linked view displays every row from the source database, the filter is not applied or was reset. Click the filter icon on the linked view and verify that at least one filter condition is active. If you duplicated the view from another source, filters do not carry over automatically.

Rollup Property Returns Incorrect Values

A rollup that shows zero or an unexpected number usually means the relation between the two databases is broken or missing. Open the source database and check that every item in the related table has a proper link to the parent item. Also confirm that the "Calculate" setting matches the data type: use "Count All" for counting items, "Sum" for numeric totals, and "Average" for mean values.

Formula Property Shows an Error Instead of a Status

Formula errors occur when property names are misspelled or the data type does not match. For example, comparing a text property to a number will throw an error. Double-check the property names inside the formula and ensure they match exactly, including capitalization. Use the formula editor's autocomplete feature to avoid typos.

Notion Dashboard Methods Compared: Linked Views vs Embedded Databases

Item	Linked Database View	Embedded Database (Full Page)
Description	Displays a subset of a source database with filters and sorts	Creates a new database directly on the dashboard page
Data source	Pulls from an existing database elsewhere	Stores data locally on the dashboard page
Real-time sync	Updates automatically when source changes	Does not sync with any other database
Best for	Workspace-wide monitoring of existing data	Collecting dashboard-specific notes or temporary data

Linked views are the correct choice for a sync dashboard because they reflect live changes from source databases. Embedded databases are isolated and require manual updates, which defeats the purpose of a real-time status monitor.

You can now build a Notion sync dashboard that shows live status from every team database on a single page. Start by adding linked views for your most important databases, then configure rollups and formulas to turn raw data into color-coded status indicators. For an advanced setup, consider adding a "Last Updated" formula property using the now() function to timestamp when each item was last modified.