How to create a project management dashboard in Notion?

To build a Notion project management dashboard: 1. Create linked Projects and Tasks databases with key properties. 2. Use relations to connect tasks to projects. 3. Add rollups for metrics like overdue tasks and average progress. 4. Assemble a dashboard page with synced gallery, board, timeline, and summary views.

If you want to build a project management dashboard in Notion, you can leverage databases, relations, rollups, and views to centralize tasks, timelines, and team progress. Here are the steps to create it:

The operating environment of this tutorial: MacBook Air M2, macOS Sonoma

1. Set up a master Projects database

This database serves as the central registry for all projects, storing metadata like status, deadline, owner, and budget. Each project entry acts as a parent record linked to related tasks and sprints.

• Create a new database with “Table” view.
• Add properties: Name (Title), Status (Select), Start Date (Date), Deadline (Date), Owner (People), Budget (Number), Description (Text).
• Enable “Relations” and add a relation to a new “Tasks” database.

2. Build a Tasks database with status tracking

This database holds granular task items, each tied to a project and equipped with priority, assignee, due date, and progress tracking via a status property that syncs with Kanban board views.

• Create a second database named “Tasks”, also as “Table”.
• Add properties: Task Name (Title), Project (Relation → Projects database), Assignee (People), Priority (Select: High/Medium/Low), Due Date (Date), Status (Select: To Do/In Progress/Blocked/Done), Progress (Number, 0–100).
• Create a “Kanban” view grouped by Status.

3. Link databases using relations and rollups

Relations allow cross-database connections, while rollups pull aggregate data—such as count of overdue tasks or average progress—from Tasks into the Projects database for real-time health metrics.

• In the Projects database, open Properties → Add Relation → Select “Tasks” database → Name it “Related Tasks”.
• Add a Rollup property named “Overdue Tasks Count”: Source = Related Tasks, Property = Due Date, Rollup = Count where Due Date is before today.
• Add another Rollup named “Avg Progress”: Source = Related Tasks, Property = Progress, Rollup = Average.

4. Design a dashboard page with synced views and metrics

A dashboard page surfaces key information through embedded database views, inline charts (via /chart block if using Notion AI Pro), and summary text blocks—all dynamically updated as underlying databases change.

• Create a new blank page titled “Project Dashboard”.
• Type “/linked view” → select Projects database → choose “Gallery” view to show project cards with cover images and status badges.
• Type “/linked view” again → select Tasks database → choose “Board” view grouped by Status.
• Add a “/text” block with summary stats: Total Projects: {{Projects.count}}, Active Tasks: {{Tasks.filter(Status != "Done").count}}.

5. Add timeline visualization with Timeline view

A Timeline view displays tasks or projects along a chronological axis, helping identify scheduling conflicts, bottlenecks, and overlapping workloads across initiatives.

• In the Tasks database, create a new “Timeline” view.
• Set “Time property” to Due Date and “Group by” to Project.
• Adjust bar duration using Start Date and Due Date properties if both exist; otherwise, use Due Date only for point-in-time markers.
• Embed this view on the dashboard page using “/linked view”.

The above is the detailed content of How to create a project management dashboard in Notion?. For more information, please follow other related articles on the PHP Chinese website!