Database

Push Overdue Tasks To Today In Notion

Sarah Brennan ·

🗓 Notion Calendars

If a task is overdue, push the due date in Notion to today, and show the new due date in a calendar. If the task is not overdue or complete, show the original due date. We also explore how to see this new date formula in a calendar view. Calendars can only see one date at a time so it is important to join all dates you want to see into one Notion formula. Here is how it works.

 

Push Overdue Date to Today Formula

In the example above, there is a task database with a due date property, a done checkbox, and a formula named “Show In Calendar.” If there is a task that is in the past and NOT done, the due date will change to today. Otherwise, the date shown in the formula will display the original date.

if(prop("Done") == false and prop("Due Date") < now(), dateAdd(prop("Due Date"), dateBetween(now(), prop("Due Date"), "days"), "days"), prop("Due Date"))

This formula uses the if() operator to create the conditions explained for the formula to function.

if() syntax → if(boolean, true value, false value)

  • boolean == task that is in the past and NOT done

  • true value == the due date will change to today

  • false value == the date in the formula will display the original date

 

View Formula In Notion Calendar

To create a calendar view in an existing Notion database, navigate to the “+” button at the top of the database. Next, choose the Calendar layout. In this menu there is an option for Show calendar by. Choose the new date formula. This will join all past dates, future dates, and updated overdue dates in the same calendar.

 

Bonus: Late Status Formula

You may have noticed the “Late Status” formula in addition to the date formula. This will signal if a task with a due date and a done checkbox is Overdue, Due Today, Complete, or Due Later. Emojis are compatible with this code because it is returning a string property.

What you need

  • Date property named “Due Date”

  • Checkbox property named “Done”

if(not empty(prop("Due Date")), if(prop("Done"), "✅ Complete", if(formatDate(prop("Due Date"), "L") == formatDate(now(), "L"), "🚧 Due Today", if(prop("Due Date") < now() and prop("Done") == false, "❌ Overdue", "🗓 Due Later"))), "")

 

Further Reading

Featured
Free Notion Template: One-Click Recurring Checklists

How to create a one-click checklist using Notion. This includes a free template that can be used for personal or professional tasks. The recurring checklist is designed to simplify the process of adding checklists and completing projects, allowing you to focus on what needs to be done rather than spending time recreating repetitive to-do lists.

Free Notion Template: Airline Ticket Organizer for Travel

For those looking for an easy way to manage their travel information, this Notion template for airline tickets can provide a great solution. This template is designed to help users keep track of airline tickets and associated information. It includes sections for collecting and organizing information like flight number, departure and arrival times, airline, layovers, and more.

Populate A Weekly Spread From a Notion Calendar

This is a weekly spread between Monday and Sunday that will auto-populate from a Notion calendar. All days are spread into two rows of four columns. For those who like the presentation of a non-database weekly spread but also like the convenience of a database manager, this is the best of both worlds, and it takes a few minutes to setup. There is also the option to duplicate the Notion template below the tutorial.

Free 2022-2023 Calendar Covers For Notion

Claim your free copy of 2022-2023 calendar covers for Notion in 6 color way themes. Below is a collection of calendars between September 2022 and December 2023 with weekly pages included too. The template, available to duplicate at the bottom of the article, nests all corresponding weeks with their parent month in the body of every month page.