How To Return Alerts Via A Deadline

<aside> 📋 The Scenario: Let's assume you have a database for assignments due for various classes with different deadlines. This formula will return the following ↓

</aside>

Assignments

Find if deadline lands on today and NOT done

if(prop("Done") == false and formatDate(prop("Deadline"), "MMM DD, YYYY") == formatDate(now(), "MMM DD, YYYY"), "⇧ Due Today",

Find if deadline is overdue and NOT done

if(prop("Done") == false and prop("Deadline") < now(), "⌫ Overdue",

Find if deadline is in the future and NOT done

if(prop("Done") == false and prop("Deadline") > now(), "⌦ Upcoming",

If the prior three do not apply, the assignment is assumed to be DONE

"★ Done")))

Full Formula

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 Website With Notion And Super

<aside> 📋 I talk through the step-by-step process that went into designing it in my latest video

</aside>

http://redgregory.me/

My Mood

Untitled

Highest Performing Tweet

https://twitter.com/RedGregory1/status/1363617576606183426

Content Published This Week

https://youtu.be/iDxhVbX1I_s

How I Built A Double Elimination Bracket With Notion - Red Gregory