Skip to content

Instantly share code, notes, and snippets.

View yannik-dittmar's full-sized avatar
🌌
Exploring the universe of code

Yannik Dittmar yannik-dittmar

🌌
Exploring the universe of code
22 followers · 7 following
  • Hasso-Plattner-Institut
  • Germany
View GitHub Profile
@yannik-dittmar
yannik-dittmar / Notion Deadline Minified.txt
Last active November 17, 2021 22:14
Notion Deadline Formula
if(prop("Status")==true,"✔ Done",if(not(empty(dateBetween(prop("Dates"),now(),"minutes"))),if(dateBetween(prop("Dates"),now(),"minutes")<=0,"❌ OVER",if(dateBetween(prop("Dates"),now(),"days")<=3,if(dateBetween(prop("Dates"),now(),"days")==0,"🚨 ","⚠ "),"🕑 ")+if(dateBetween(prop("Dates"),now(),"weeks")>0,if(dateBetween(prop("Dates"),now(),"weeks")>1,format(dateBetween(prop("Dates"),now(),"weeks"))+" weeks","1 week"),if(dateBetween(prop("Dates"),now(),"days")>0,if(dateBetween(prop("Dates"),now(),"days")>1,format(dateBetween(prop("Dates"),now(),"days"))+" days","1 day"),if(dateBetween(prop("Dates"),now(),"hours")>0,if(dateBetween(prop("Dates"),now(),"hours")>1,format(dateBetween(prop("Dates"),now(),"hours"))+" hours","1 hour"),format(dateBetween(prop("Dates"),now(),"minutes"))+" min")))),"❓ No date"))