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.

See Example Inside Notion

Further Reading