Red Gregory

View Original

Super Minimal Deadline Notion Formula

See this content in the original post

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

See this gallery in the original post