OVER 2 YEARS AGO • 3 MIN READ

How to set up a notification board in Notion|Work Smart #8

profile

Work Smart Newsletter

Every Wednesday, you can expect in-depth Notion tips or valuable content on work system and mindset design.

Work Smart #8

March 27, 2024

Hi Reader, Welcome to issue #8 of Work Smart.

Every Wednesday, you can expect 3 brief or 1 in-depth Notion tips or valuable content on work system and mindset design.


How to set up a notification board in Notion

4 min read

↓

Have you ever wished for a centralized place on your Notion dashboard to keep track of all your tasks, deadlines, and important information? Consider creating a notification board in Notion!

A notification board, or notification center, is a gallery view that brings together information from different databases and summarizes it.

Let's explore how to make one.

Getting Started

In our example, we will use a task management scenario.

A. Preparation

First, we need a few things:

  1. A Task database
  2. A Notification Board database​
    (This should be in gallery view and set the card preview to “no preview”. Create an entry called “Notification Board”.)

Next, you'll need to relate the two databases.

Before you start adding tasks to the Task database, set a filter to the relation property that contains “Notification Board”. This means that when you add a task, it will automatically relate to the “Notification Board”, allowing you to have an instant summary.

⚠️ Note this: if you have other database views of the Task Database in your template, you'll need to apply the same filter too.


B. Section Title

If you have multiple sections on your notification board, it’ll look more organized if you assign a title to each section.

You can use the text property or the formula style() to set your title: style(”text”, “style”)

Style:

  • b = bold
  • u = underline
  • i = italic
  • "color": all text colors available in Notion can be used

Example: style("Task Overview", "b", "u", "yellow")


C. Gathering Information from Your Task Database

Now, we want to collect some information from your task database.

1. Total number of tasks

  • Use a database property and the formula.length().
    ​
  • Formula explained:
    ​PROPERTY.length() = Returns how many items are in the list.
    ​
  • Example:
    ​"You have " + prop("Tasks").length() + " tasks.”

2. Number of tasks of certain status

For example, overdue tasks.

  • Database Property: Formula
    ​
  • Steps: ​
    Identify unfinished tasks
    → Define overdue tasks (establish today's date and find unfinished tasks from previous days)
    → Calculate the quantity
    → Determine the text for the notification board

(1) Identify unfinished tasks:

Explanation: This filters out tasks within the related “Task” database whose status is not “Done”.

(2) Define overdue:

Explanation: This filters out undone tasks whose “Due” is before (smaller) than today.

  • Define today:
    • 1️⃣ Use now() to get the current date and time.
      ​
    • 2️⃣ Since we don't want the time, we use formatDate(now(), "YYYY-MM-DD") to include only the date. This helps us find tasks before today, the whole day.
      ​
    • 3️⃣ Since formatDate() returns text, we use parseDate() to get a timestamp, so Notion recognizes it as a date instead of text.
      ​
    • Now we get
      Today = parseDate(formatDate(now(), "YYYY-MM-DD")))
  • Define overdue:
    • Due date < today. So the formula would be:
      ​.filter(current.prop("Due") < parseDate(formatDate(now(), "YYYY-MM-DD")))
  • Count the number of overdue tasks
    • Add a .length() to return the number of tasks that meet the conditions specified above.

(3) Decide the text you want to display on the notification board

Use let() to simplify the formula.

If "a" is the number of overdue tasks, you might want to see : "You have a overdue tasks."

You can use:

let(a, number of Overdue tasks, “You have ” + a + “ overdue tasks.”)

You could also add conditions to your text with ifs().

For example:

  • if a (number of overdue tasks) = 0, show: "Yay! You have no overdue task."
  • if a = 1, show "You have " + a + " overdue task."
  • if a > 1, show: "You have " + a + " overdue tasks."​
    ​

You can do the same with tasks you need to complete today, or tasks completed today.

The final result:

“
You can take a closer look at the setting of my example or duplicate it HERE.

Examples of notification board in my template

In my CRM Elite template, I've created a notification board for quarterly reports. Similarly, I use this concept to summarize payment statuses.


Wrapping Up

A notification board can be an incredibly useful tool to keep your information organized.

I hope I provide a simple enough explanation for you to understand.

Give it a try and see how it can improve your productivity!


I build systems to help you work smarter and live a better life.

Whenever you’re ready, here’s how I can help you:

1. Goal Getter Bundle​

This Notion template bundle is designed to help you work with a clear focus and achieve your goals more effectively. It's not just about getting things done. It's about understanding your tasks, your dreams, and your finances, and aligning them all towards your ultimate life goals.

2. Biz Master Bundle​

This is a powerful duo of Notion templates designed to supercharge your business operations. Use them to streamline customer relationships, manage sales, and organize your content like never before.

3. Task Flowy​

Your second brain that operates on the PARA system. The dashboard, designed with a focus on task management, helps you in staying on top of your daily tasks while keeping a track of broader responsibilities and goals.

4. CRM Elite​

A Notion template designed to manage your customer relationships, track client activities, and help you stay on top of your tasks. CRM Elite ensures you never miss a follow-up, keeps you updated with payments, and lets you set and meet your business goals.


P.S. Did someone forward this to you? Subscribe Here.

P.P.S. Thank you for your valuable time spent reading this newsletter. If these emails ever become too much, remember, you have the option to unsubscribe whenever you like.

600 1st Ave, Ste 330 PMB 92768, Seattle, WA 98104-2246
​Unsubscribe · Preferences​

Work Smart Newsletter

Every Wednesday, you can expect in-depth Notion tips or valuable content on work system and mindset design.