Red Gregory

View Original

How To Automate Re-Schedule For Overdue Tasks In Notion

This Notion template is intended for those seeking a better way to tackle tasks that are overdue. Re-scheduling overdue tasks is a valuable solution for projects with multiple contributors. The static overdue label can also hinder productivity for an individual's to-do list. What I implement in the table below is a single Notion formula that can replace or enhance your current project status property.

Note: This is an update for “Make Custom Deadline Reminders

In addition to the above framework, one can implement this re-schedule formula. In my example, I return a 7 day relapse for completion of a task, whereby the new deadline is 7 days after original deadline. This is an element that can be manipulated to fit your needs.

Status Property With Re-Schedule Formula

(prop("Priority") == "➡Look at New Deadline") ? formatDate(dateAdd(prop("Deadline"), 7, "days"), "M/D/YY") : ""

COPY TEMPLATE