Required Properties
(Name Sensitive)
Deadline: Date Property
Done : Checkbox Property
What The Symbols Mean
★ - Done
⚠︎ - Overdue
☆ - Today
→ - Upcoming
The Formula
if(prop("Done"), "\t★", if(formatDate(prop("Deadline"), "MDYYYY") == formatDate(now(), "MDYYYY"), "\t☆", if(now() < prop("Deadline"), "\t→", if(prop("Deadline") < now(), "\t⚠︎", ""))))
How To Center Formula Text
Adding “\t” adds a tab effect before or after text.
This will only work if wrap cells is turned on.