Database

Super Minimal Deadline Notion Formula

notion-deadline-formula-task-management.png

☞ Deadline Formula

This super minimal deadline formula in Notion is a stripped back approach to labeling tasks. With only a date property and done checkbox, one can use this formula to identify whether a task lands on Today, is Overdue, In The Future, or Complete. Add this to your Notion database and give it a try! Here is how it works.

Required Properties

(Name Sensitive)

  • Deadline: Date Property

  • Done : Checkbox Property

What The Symbols Mean

  • ★ - Done

  • ⚠︎ - Overdue

  • ☆ - Today

  • → - Upcoming

Screen Shot 2021-06-22 at 10.15.08 AM.png

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.

Screen Shot 2021-06-22 at 11.47.11 AM.png
Screen Shot 2021-06-22 at 11.39.09 AM.png
 

Further Reading