If you’re following my Notion Task Manager build guide from 2020, you may find this page helpful.

https://www.youtube.com/watch?v=32dLXdB4ozs

It contains a copy of Ultimate Tasks that contains all the exact same blocks and formulas from that tutorial. The current version of Ultimate Tasks contains many changes, so copying formulas from there while following the video guide may not work.

Here’s the exact “Ultimate Tasks from Scratch” template I built in the video.

Ultimate Tasks from Scratch

Below, you’ll find the exact formulas used in that tutorial. You can hit the Copy button in the top-right corner of these Code blocks in order to copy the formulas and paste them into your own build.

Formula Order

It’s important to create your formulas in the same order that I did in the tutorial. That order is:

  1. Type
  2. State
  3. Next Due

State Formula

Note: This formula won’t work until you’ve created the Due and Parent Task properties.

if(empty(prop("Due")) and empty(prop("Parent Task")), "⚪️", if(empty(prop("Due")), "➞⚪️", if(formatDate(prop("Due"), "L") == formatDate(now(), "L") and empty(prop("Parent Task")), "🟢", if(formatDate(prop("Due"), "L") == formatDate(now(), "L"), "➞🟢", if(prop("Due") < now() and empty(prop("Parent Task")), "🔴", if(prop("Due") < now(), "➞🔴", if(empty(prop("Parent Task")), "🔵", "➞🔵")))))))

Next Due Formula

Note: This formula won’t work until you’ve created the Due and Recur Interval (Days) properties.

if(dateBetween(now(), prop("Due"), "days") >= 1 and unequal(formatDate(now(), "L"), formatDate(prop("Due"), "L")) and unequal(prop("Type"), "One-Time"), if(equal(dateBetween(now(), prop("Due"), "days") / prop("Recur Interval (Days)"), ceil(dateBetween(now(), prop("Due"), "days") / prop("Recur Interval (Days)"))), dateAdd(prop("Due"), multiply(dateBetween(now(), prop("Due"), "days") / prop("Recur Interval (Days)") + 1, prop("Recur Interval (Days)")), "days"), dateAdd(prop("Due"), multiply(ceil(dateBetween(now(), prop("Due"), "days") / prop("Recur Interval (Days)")), prop("Recur Interval (Days)")), "days")), dateAdd(prop("Due"), prop("Recur Interval (Days)"), "days"))

Type Formula

Note: This formula won’t work until you’ve created the Recur Interval (Days) property.

if(empty(prop("Recur Interval (Days)")), "⏳One-Time", "🔄Recurring")