Hi, Hello! My name is Sarah - the writer behind redgregory.com.
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 ↓
Assignments
Class
Name
Deadline
Done
Action
- 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
I talk through the step-by-step process that went into designing it in my latest video
My Mood
Highest Performing Tweet
Content Published This Week
