The Classic Notion Deadline Formula
How To Return Alerts Via A Deadline
The Scenario: Let's assume you have a database for assignments due for various classes with different deadlines. This formula will return the following ↓
⇧ Due Today: Find if deadline lands on today and NOT done
⌫ Overdue: Find if deadline is overdue and NOT done
⌦ Upcoming: Find if deadline is in the future and NOT done
★ Done: If the prior three do not apply, task is assumed to be DONE
Full Formula
What You Need:
A date property called “Deadline”
A checkbox property called “Done”
if(prop("Done") == false and formatDate(prop("Deadline"), "MMM DD, YYYY") == formatDate(now(), "MMM DD, YYYY"), "⇧ Due Today", if(prop("Done") == false and prop("Deadline") < now(), "⌫ Overdue", if(prop("Done") == false and prop("Deadline") > now(), "⌦ Upcoming", "★ Done")))
I Launched A Notion Website
I talk through the process that went into designing it in my latest video.