Database

Super Minimal Deadline Notion Formula

Sarah Brennan ·

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

Featured
Free Notion Template: One-Click Recurring Checklists

How to create a one-click checklist using Notion. This includes a free template that can be used for personal or professional tasks. The recurring checklist is designed to simplify the process of adding checklists and completing projects, allowing you to focus on what needs to be done rather than spending time recreating repetitive to-do lists.

11 Ways to Generate Clickable Links with Notion Formulas

Notion formulas can now be used to create clickable links that make constructing and navigating URL links a breeze. Creating clickable links in Notion formulas only requires inputting the correct code that results in a url syntax (https://www.website.com/…). Below are instructions on how to generate clickable links in Notion formulas for maps, social media searches, Twitter profiles, Wikipedia, Goodreads, and Amazon.

Notion For Note-Taking: Where To Start

There are many reasons why Notion is a great note-taking app. For starters, it's extremely user-friendly and easy to use. The interface is clean and simple, making it quick and easy to find what you're looking for. There are also tons of features and customization options available, so you can tailor the app to your specific needs. Here is how you can get started.

How To Connect Zotero To Notion With Notero

Utilize the immensely useful Notero integration with Notion to save and organize citations and web clippings from the Zotero browser extension and app. In this short tutorial, I show you how to get started with Notero in 2022, and where to add integrations in Notion. Here’s how it works.