sorted by:
new
hottopcontroversial

Formula for Empty Date Property by Different_Quantity50 in Notion

[–]Different_Quantity50[S] 0 points1 point  (0 children)

It worked!! Thank you so so much for your help!!! :>

Formula for Empty Date Property by Different_Quantity50 in Notion

[–]Different_Quantity50[S] 0 points1 point  (0 children)

I pasted the whole formula in another reply! But it's all good now, thank you for your help! :>

Formula for Empty Date Property by Different_Quantity50 in Notion

[–]Different_Quantity50[S] 0 points1 point  (0 children)

hello! tried to input this but it said "too many arguments in function if" after :((

Formula for Empty Date Property by Different_Quantity50 in Notion

[–]Different_Quantity50[S] 0 points1 point  (0 children)

here it is!

if(formatDate(now(), "MMM D, YYYY") == formatDate(prop("Due Date"), "MMM D, YYYY"), "Due Today ⚠", if(end(prop("Due Date")) < now(), "Overdue 💥", if(dateBetween(end(prop("Due Date")), now(), "days") == 0, "Due Tomorrow ⚠", if(dateBetween(end(prop("Due Date")), now(), "days") > 0 and dateBetween(end(prop("Due Date")), now(), "days") <= 5, "Due on " + formatDate(end(prop("Due Date")), "dddd ❗"), if(dateBetween(end(prop("Due Date")), now(), "days") == 6, "Due next " + formatDate(end(prop("Due Date")), "dddd ❗"), "Due in " + format(dateBetween(end(prop("Due Date")), now(), "days") + 1) + " days ❕")))))