The Employee Dashboard

Employee Directory Info View

Properties

• Hired: date

• Name: text

• First Name: formula

  • replaceAll(prop("Name"), "[ ].*", "")

• Last Name: formula

  • replaceAll(prop("Name"), ".*[ ]", "")

• Profile: notion profile

• Job Title: text

• Status: multi-select

  • Onboarding

  • Employee

  • On Leave

• Photo: files and media

• Department: relation to Departments database.

Employee Contact Info View

Properties

• Birthday: date

• Phone: phone number

• Office: text

• Reports To: notion profile

• Email: email

• Slack: URL

• City: select

Employee Upcoming Birthday View

Filter

• Bday Month: formula

  • month(prop("Birthday")) == month(now())

Employee Status Pipeline View

Employee Departments

Properties

• Name: text

• Employees: relation connected to Employees database.

• Hide: hidden rollup from Employees database to find all “statuses” the corresponding department’s employees hold.

• Onboarding: formula to find number of employees On Boarding in the department.

  • "☞ " + format(length(replaceAll(replaceAll(prop("Hide"), "Onboarding", "|"), "[^|]", ""))) + " Onboarding"

• Employee: formula to find number of employees Employees in the department.

  • "☞ " + format(length(replaceAll(replaceAll(prop("Hide"), "Employee", "|"), "[^|]", ""))) + " Employee(s)"

• On Leave: formula to find number of employees On Leave in the department.

  • "☞ " + format(length(replaceAll(replaceAll(replaceAll(prop("Hide"), "On ", ""), "Leave", "|"), "[^|]", ""))) + " On Leave"

The Notion system for teams begins with relating databases like this, creating smart filters, and utilizing formulas in order to create a smooth working experience for everyone.

Copy Template Inside Notion

Further Reading