Smart Deadline

Smart Deadline

Master Tag
Tips & Tricks
Created
Mar 3, 2021 03:44 PM
Usage
formateDate
dateBetween
Format
Web Tags
Database
Formula
Design
Alternatives
Cover
Week Of Month (8).png
Β 
Smart To Do List
Formula Guide
Β 
if(dateBetween(prop("Deadline"), now(), "days") < -1 and prop("Done") == true, "‑›Archive", if(prop("Done") == true, "β˜… Done", if(formatDate(now(), "MMM D, YYYY") == formatDate(prop("Deadline"), "MMM D, YYYY"), "⇧ Due Today", if(prop("Deadline") < now(), "⌫ Overdue", if(dateBetween(prop("Deadline"), now(), "days") == 0, "⌦ Due Tomorrow", if(dateBetween(prop("Deadline"), now(), "days") > 0 and dateBetween(prop("Deadline"), now(), "days") <= 5, "βˆ† Due On " + formatDate(prop("Deadline"), "dddd"), if(dateBetween(prop("Deadline"), now(), "days") == 6, "βˆ† Due Next " + formatDate(prop("Deadline"), "dddd"), "Β» Upcoming in " + format(dateBetween(prop("Deadline"), now(), "days") + 1) + " days")))))))
Β 
Β 
Β 
Β 
Β 
Β 
Β