2021-12-15 // 65 words // 1 minute read

Notion "Due" Formula

Here is a Notion formula to show when an item is/was due

if(prop("Done"), "", if(empty(prop("Deadline")), "", if(abs(dateBetween(prop("Deadline"), now(), "seconds")) < 86400, format(dateBetween(prop("Deadline"), now(), "hours")) + " hours", format(dateBetween(prop("Deadline"), now(), "days")) + " days") + if(dateBetween(prop("Deadline"), now(), "milliseconds") >= 0, " from now", " ago")))

This requires a date field named Deadline and a checkbox named Done