Building an employee-manager reporting tree in Notion requires linking two databases so each employee record points to their manager. Without a proper relation, you cannot see who reports to whom or create a hierarchical org chart. This article explains how to set up a relation between an Employee database and a Manager database, then use rollups to display manager details. You will learn to create the relation property, configure the rollup, and avoid common pitfalls like circular references.
Key Takeaways: Building a Notion Employee-Manager Relation
- Employee Database > Manager relation: Links each employee to a single manager record in the Manager database.
- Manager Database > Direct Reports relation: Automatically created as the inverse relation to show all employees under a manager.
- Rollup property to show Manager Name: Pulls the manager’s name from the related manager record into the employee view.
What the Employee-Manager Relation Does and What You Need
The employee-manager relation is a linked database feature in Notion that connects two separate databases. One database stores employee records. The other stores manager records. Each employee gets a relation property that points to their manager. The manager database then shows an inverse relation with the list of direct reports. This setup lets you filter employees by manager, create a reporting tree view, and use rollups to display manager names or contact info without duplicating data.
Before you begin, you need two existing databases. Create an Employee database with columns for Name, Department, Role, and any other fields. Create a Manager database with columns for Name, Title, Email, and Department. Both databases must have at least a few records. You also need full edit permissions on both databases. If you are using a shared workspace, confirm you are not in a read-only view.
Steps to Build the Relation Between Employee and Manager Databases
Follow these steps to link the Employee database to the Manager database and create the reporting tree.
- Open the Employee database
Navigate to your Employee database in Notion. Click the database name at the top to open the full page view. If the database is inline on a page, click the three-dot menu and select Open as page. - Add a new Relation property
Click the + button in the last column header. Select Relation from the property type list. Name the property Manager. In the popup, choose the Manager database as the related database. Click Create relation. - Configure the relation to allow one manager per employee
After creating the relation, click the Manager column header. In the property settings, ensure the relation is set to Single value. This prevents assigning multiple managers to one employee. Leave the Show on Manager database checkbox checked so the inverse relation appears automatically. - Link each employee to a manager
Click the Manager cell in any employee row. A list of manager records appears. Select the correct manager. Repeat for every employee row. You can also use the database menu and select Edit property to bulk-link if you have many records. - Open the Manager database to verify the inverse relation
Go to the Manager database. You will see a new column named Direct Reports (or the name you set). This column shows all employees linked to that manager. Click a manager row to see the full list of direct reports. - Add a Rollup property to show manager name in the Employee database
In the Employee database, click the + button in the last column header. Select Rollup. Name it Manager Name. In the Rollup configuration, set the Relation to Manager. Set the Property to Name (from the Manager database). Set the Calculate option to Show original. Click Save. The Manager Name column now displays the manager’s name for each employee. - Create a filtered view for each manager
Click the + tab at the top of the Employee database. Name the view after a manager. Add a filter: Manager Name contains [manager name]. This view shows only employees under that manager. Repeat for each manager to build a complete reporting tree.
Common Mistakes and Limitations to Avoid
Circular reference when linking an employee as their own manager
Notion does not prevent you from linking an employee to themselves or creating a loop where A reports to B and B reports to A. This breaks the reporting tree and causes incorrect rollup values. To avoid this, always double-check that the manager record is a different person. If you accidentally create a circular reference, click the Manager cell, remove the wrong link, and select the correct manager.
Manager database shows no Direct Reports column
If the inverse relation does not appear, you may have unchecked Show on Manager database when creating the relation. To fix this, click the Manager column header in the Employee database. In the property settings, check Show on Manager database. The column appears immediately.
Rollup shows empty values for some employees
A rollup depends on the relation being filled. If an employee has no manager selected, the rollup shows blank. Ensure every employee row has a manager assigned. Also confirm the Manager database has a Name property with non-empty values. If the Name property is missing or empty, the rollup cannot display anything.
Filtered view shows no results
If a filtered view for a specific manager returns zero employees, check that the filter uses the correct property. Use Manager Name (the rollup) or Manager (the relation) as the filter column. Also verify that the manager name in the filter matches exactly. Notion filters are case-sensitive. Remove extra spaces from the filter value.
| Item | Using Relation Only | Using Relation + Rollup |
|---|---|---|
| Data shown in Employee view | Link to manager record | Manager name displayed as text |
| Ability to filter by manager | Yes, by relation value | Yes, by rollup text value |
| Manager database shows direct reports | Yes, inverse relation | Yes, inverse relation |
| Requires extra property | No | Yes, one rollup property |
| Best for | Simple linking without displaying names | Org charts and reports that need manager names inline |
You can now create a complete employee-manager reporting tree in Notion using a relation and rollup. Start by linking each employee to their manager, then add the rollup to display manager names. For advanced use, try adding a second rollup to pull the manager’s email or department. Use the Ctrl + D shortcut to quickly duplicate a filtered view for each manager.