Database

Notion Formula: Double Progress Bar

Sarah Brennan ·

notion-formula-double-progress-bar.png

📚 Dual Progress

Here’s an alternative to the classic Notion progress bar that may be interesting to the power-user. Let's assume you're reading for an exam, and you want to give yourself a number of days to finish reading and make sense of the text before the exam. This Notion formula will keep track of task progress AND progress to a deadline.

The Database Properties

Screen Shot 2021-02-11 at 8.43.50 PM.png

  • Date Range: time to complete task

  • Pages: pages to read

  • Page On: pages completed

The Goal: make sure the green book leads the red dot. In other words, stay ahead of schedule.

The Formula

if(not empty(prop("Pages")) and not empty(prop("Date Range")), "Progress: " + format(slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, floor(20 * prop("Page On") / prop("Pages"))) + "📗" + slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, 20 - floor(20 * prop("Page On") / prop("Pages"))) + " " + format(floor(100 * prop("Page On") / prop("Pages"))) + "%") + "\nDeadline: " + format(if(dateBetween(start(prop("Date Range")), now(), "days") > 0, "⭕‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒ 0%", if(dateBetween(end(prop("Date Range")), now(), "days") > -1, slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, floor(20 * dateBetween(now(), start(prop("Date Range")), "days") / dateBetween(end(prop("Date Range")), start(prop("Date Range")), "days"))) + "⭕" + slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, 20 - floor(20 * dateBetween(now(), start(prop("Date Range")), "days") / dateBetween(end(prop("Date Range")), start(prop("Date Range")), "days"))) + " " + format(floor(100 * dateBetween(now(), start(prop("Date Range")), "days") / dateBetween(end(prop("Date Range")), start(prop("Date Range")), "days"))) + "%", "‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒⭕ 100%"))), "")

Untitled_Artwork 40.png

Learn more about finding the progress between now and a deadline and creating a progress bar here.

 

Further Reading

Featured
Free Notion Template: Airline Ticket Organizer for Travel

For those looking for an easy way to manage their travel information, this Notion template for airline tickets can provide a great solution. This template is designed to help users keep track of airline tickets and associated information. It includes sections for collecting and organizing information like flight number, departure and arrival times, airline, layovers, and more.

Populate A Weekly Spread From a Notion Calendar

This is a weekly spread between Monday and Sunday that will auto-populate from a Notion calendar. All days are spread into two rows of four columns. For those who like the presentation of a non-database weekly spread but also like the convenience of a database manager, this is the best of both worlds, and it takes a few minutes to setup. There is also the option to duplicate the Notion template below the tutorial.

Track Productivity In Notion With This Simple Timesheet

Here is a simple timesheet database template in Notion that requires little to no system building and can help you get right to work. This is a planner and timesheet for your working sessions. For example, you can track total hours worked for projects your working on, describe how well each session went, and analyze most and least productive weeks and months of the year. Here’s how it works.

How To Make A Twitter Thread Editor In Notion

Create a Twitter thread editor inside of Notion with the formula property and new grouping feature! Creating, planning, and analyzing thread performance can be done inside a single minimal Notion database. Below is how it works, a character limit formula, and a link to a free Twitter thread editor template.