A Notion formula to stop missing deadlines:
if(not empty(prop("Due Date")), if(prop("Done"), "✅ Complete", if(formatDate(prop("Due Date"), "L") == formatDate(now(), "L"), "🚧 Due Today", if(prop("Due Date") < now() and prop("Done") == false, "❌ Overdue", "🗓 Due Later"))), "")