Ben SmithBen Smith
Ben Smith/
Deadline Status
Deadline Status
Deadline Status

Deadline Status

For
Jeremy
From
Facebook
Status
Updating
Formulas
abs
abs
+
+
dateBetween
dateBetween
empty
empty
format
format
formatDate
formatDate
if
if
|| · or
|| · or
Share

Deadline Status

Tasks
📅
Current Week Day View

Deadline Status

⚠️
Change lowercase w to uppercase W if your weeks start on Monday.
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"))))))
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
 
if(empty(format(prop("Deadline"))), "", if(empty(format(prop("Timeline"))), if(larger(now(), prop("Deadline")), concat("😱Procrastinated ", format(dateBetween(now(), prop("Deadline"), "days")), " days"), concat("👊You Have ", format(unaryMinus(dateBetween(now(), prop("Deadline"), "days"))), " Days Until Deadline")), if(equal(prop("Deadline"), end(prop("Timeline"))), "🤗On-Time", if(larger(end(prop("Timeline")), prop("Deadline")), concat("☠", format(unaryMinus(dateBetween(prop("Deadline"), end(prop("Timeline")), "days"))), " days late"), if(prop("Done") == true, concat("😍Completed soon ", format(dateBetween(prop("Deadline"), end(prop("Timeline")), "days")), " days"), concat("🔥", format(dateBetween(prop("Deadline"), end(prop("Timeline")), "hours")), " hours Until Deadline"))))))