The formula didn't work for me, so had chatgpt revise it. I really appreciate this video tho! Here's the formul i ended up with: if(formatDate(prop("Deadline"), "MMMM D, Y") == formatDate(now(), "MMMM D, Y"), "Deadline is today 🔵", if(dateBetween(prop("Deadline"), now(), "days") == 0, "Deadline is tomorrow ‼", if(dateBetween(prop("Deadline"), now(), "days") > 0, format(dateBetween(prop("Deadline"), now(), "days")) + " Days til deadline 🟢", if(dateBetween(prop("Deadline"), now(), "days") < 0, format(abs(dateBetween(prop("Deadline"), now(), "days"))) + " Days past deadline 🚨", "" ) ) ) )
so grateful that i casually stumbled upon this video. so useful, thank you man
You're welcome!
If I can give this a ten thumbs up 👍🏻, I would. Super clear and easy-to-follow tutorial, a big thank you!
Haha I appreciate it :)
The formula didn't work for me, so had chatgpt revise it. I really appreciate this video tho! Here's the formul i ended up with:
if(formatDate(prop("Deadline"), "MMMM D, Y") == formatDate(now(), "MMMM D, Y"),
"Deadline is today 🔵",
if(dateBetween(prop("Deadline"), now(), "days") == 0,
"Deadline is tomorrow ‼",
if(dateBetween(prop("Deadline"), now(), "days") > 0,
format(dateBetween(prop("Deadline"), now(), "days")) + " Days til deadline 🟢",
if(dateBetween(prop("Deadline"), now(), "days") < 0,
format(abs(dateBetween(prop("Deadline"), now(), "days"))) + " Days past deadline 🚨",
""
)
)
)
)
Thanks!
Ps. You can use map() in your formula to skip the rollup entirely. that way you don't need 2 of that progress bar anymore
Can you please explain how to do this? I'm building a variation of this template right now.
How do you create a custom cover image using Canva and How do you place these Notion icons in Canva
ok dropped at a good time im just making this now i can copy instead :)
Just curious, where are you from? The accent?
South African :)
Is this from new appartman.
Haha no it's my parents house, have moved out of my old apartment so just dumping all my shit here then I'm going to Thailand this weekend :)
Bro
Can you teach us how to use Notion with shortcut?
Really helpful, thank you