<aside> ↙️ Hi, Hello! My name is Sarah - the writer behind redgregory.com.

</aside>

<aside> ⚡ Subscribe to the newsletter if you haven't already

</aside>

<aside> 🍄 Yes the Notion progress bar is a great addition to a workspace, but what about the double progress bar?

</aside>

What Exactly Is Going On Here?

• Let's say you have a database with a deadline and project progress variables (ie. total pages/pages read for book progress).
• The double progress bar will act as a visual cue for the user to determine where the project's progress lies parallel to the distance to the deadline.

The Two Progress Bars:

What You'll Need For This Example

• 2 number properties to find book reading progress named "Total Pages" and "Page on"
• A date range property named "Start → Stop Reading"

The Scenario

<aside> 🗣 THE SCENARIO: Imagine you are an English major (like I was) and you want to find the relation between book reading progress and the deadline you've set for yourself to finish said book (ie. in 2 weeks)

THE GOAL: Simply, make sure the green book leads the red circle!

</aside>

Double Progress Bar

Final Formula

"Progress: " + format(slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, floor(20 * prop("Page On") / prop("Total Pages"))) + "📗" + slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, 20 - floor(20 * prop("Page On") / prop("Total Pages"))) + " " + format(floor(100 * prop("Page On") / prop("Total Pages"))) + "%") + "\\nDeadline: " + format(if(dateBetween(start(prop("Start → Stop Reading")), now(), "days") > 0, "⭕‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒ 0%", if(dateBetween(end(prop("Start → Stop Reading")), now(), "days") > -1, slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, floor(20 * dateBetween(now(), start(prop("Start → Stop Reading")), "days") / dateBetween(end(prop("Start → Stop Reading")), start(prop("Start → Stop Reading")), "days"))) + "⭕" + slice("‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒", 0, 20 - floor(20 * dateBetween(now(), start(prop("Start → Stop Reading")), "days") / dateBetween(end(prop("Start → Stop Reading")), start(prop("Start → Stop Reading")), "days"))) + " " + format(floor(100 * dateBetween(now(), start(prop("Start → Stop Reading")), "days") / dateBetween(end(prop("Start → Stop Reading")), start(prop("Start → Stop Reading")), "days"))) + "%", "‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒‒⭕ 100%")))

<aside> 🔥 More about how to make the slider progress bar Slider Progress Bar Use-Cases

</aside>

Extra: How To Enter A New Line In A Formula

• Insert (+ "\n") for new line

My Mood