Design, Planning

Recurring Weekday Tasks In Notion: Show Today And Tomorrow

Screen Shot 2020-07-29 at 8.29.03 AM.png

👉 Show Today And Tomorrow

In addition to this distribution table I made to show me based on today’s day of the week what content I should publish, I set out to solve one more problem: show me what tasks I need to get ready to publish tomorrow. In short, add one day to today and return any tasks that contain tomorrow. Here’s the formula breakdown.

First, How To Find Tasks For Today

Create a database in Notion, create a multi-select property for days of the week, and correlate tasks with what days you’d like them to recur on.

To Do Formula

contains(prop("Day"), formatDate(now(), "dddd"))

Screen Shot 2020-07-29 at 8.34.46 AM.png

Next, How To Find Tasks For Tomorrow

contains(prop("Day"), formatDate(dateAdd(now(), 1, "days"), "dddd"))

Lastly, Arrange Two Linked Databases To View Today And Tomorrow Tasks

Create two titles labeled something like “Today” and “Tomorrow,” and drag one title next to the other into two columns. Link the database you made above twice, and filter accordingly:

Screen Shot 2020-07-29 at 8.42.09 AM.png
Screen Shot 2020-07-29 at 8.44.09 AM.png

Drag The Linked Databases Under Both Titles

ezgif.com-video-to-gif (3).gif