Deadline Status

<aside> ⚠️ Change lowercase w to uppercase W if your weeks start on Monday.

</aside>

prop("Done") ? "Done" : (or(prop("Done"), empty(prop("Deadline"))) ? "" : ((formatDate(now(), "L") == formatDate(prop("Deadline"), "L")) ? "Due today" : ((formatDate(dateAdd(now(), 1, "days"), "L") == formatDate(prop("Deadline"), "L")) ? "Due tomorrow" : ((formatDate(dateAdd(now(), 1, "weeks"), "wY") == formatDate(prop("Deadline"), "wY")) ? "Due next week" : (format(abs(dateBetween(now(), prop("Deadline"), "days"))) + " day" + ((abs(dateBetween(now(), prop("Deadline"), "days")) == 1) ? "" : "s") + ((now() < prop("Deadline")) ? " until deadline" : " overdue"))))))

Deadline Status (Emoji)

prop("Done") ? "✅ Done" : (or(prop("Done"), empty(prop("Deadline"))) ? "❌ No Date" : ((formatDate(now(), "L") == formatDate(prop("Deadline"), "L")) ? "🔥 Due today" : ((formatDate(dateAdd(now(), 1, "days"), "L") == formatDate(prop("Deadline"), "L")) ? "😬 Due tomorrow" : ((formatDate(dateAdd(now(), 1, "weeks"), "wY") == formatDate(prop("Deadline"), "wY")) ? "👉 Due next week" : (((now() < prop("Deadline")) ? "👊 " : "😱 ") + format(abs(dateBetween(now(), prop("Deadline"), "days"))) + " day" + ((abs(dateBetween(now(), prop("Deadline"), "days")) == 1) ? "" : "s") + ((now() < prop("Deadline")) ? " until deadline" : " overdue"))))))

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>