👉 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"))
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: