🎚 Progress Slider
In the midst of redesigning for my 2021 Notion workspace, I worked out a new progress bar style that I very much prefer over my prior design. This slider helps me achieve a more minimal look and is easy to gauge progress upon a glance. Here’s the formula I used to make it.
The Progress Formula With Dashed Line
if(prop("Page Read") / prop("Pages") == 1, "┅┅┅┅┅┅┅┅┅⚫" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .9, "┅┅┅┅┅┅┅┅⚫┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .8, "┅┅┅┅┅┅┅⚫┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .7, "┅┅┅┅┅┅⚫┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .6, "┅┅┅┅┅⚫┅┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .5, "┅┅┅┅⚫┅┅┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .4, "┅┅┅⚫┅┅┅┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .3, "┅┅⚫┅┅┅┅┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .2, "┅⚫┅┅┅┅┅┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", if(prop("Page Read") / prop("Pages") >= .1, "⚫┅┅┅┅┅┅┅┅┅" + " " + format(round(prop("Page Read") / prop("Pages") * 100)) + "%", "┅┅┅┅┅┅┅┅┅┅ 0%"))))))))))
Simplified Version W/ Solid Line (Credit)
concat(slice("––––––––––––––––––––", 0, 20 * prop("Pages Read") / prop("Total Pages")), "⚫", slice("––––––––––––––––––––", 0, 20 - 20 * prop("Pages Read") / prop("Total Pages")), " ", format(floor(100 * prop("Pages Read") / prop("Total Pages"))), "%")
Colorful Version
if(prop("Pages Read") / prop("Total Pages") == 1, "┅┅┅┅┅┅┅┅┅🔵" + " " + format(round(prop("Pages Read") / prop("Total Pages") * 100)) + "%", if(prop("Pages Read") / prop("Total Pages") >= .9, "┅┅┅┅┅┅┅┅🔵┅" + " " + format(round(prop("Pages Read") / prop("Total Pages") * 100)) + "%", if(prop("Pages Read") / prop("Total Pages") >= .8, "┅┅┅┅┅┅┅🔵┅┅" + " " + format(round(prop("Pages Read") / prop("Total Pages") * 100)) + "%", if(prop("Pages Read") / prop("Total Pages") >= .7, "┅┅┅┅┅┅🔵┅┅┅" + " " + format(round(prop("Pages Read") / prop("Total Pages") * 100)) + "%", if(prop("Pages Read") / prop("Total Pages") >= .6, "┅┅┅┅┅⚫️┅┅┅┅" + " " + format(round(prop("Pages Read") / prop("Total Pages") * 100)) + "%", if(prop("Pages Read") / prop("Total Pages") >= .5, "┅┅┅┅⚫️┅┅┅┅┅" + " " + format(round(prop("Pages Read") / prop("Total Pages") * 100)) + "%", if(prop("Pages Read") / prop("Total Pages") >= .4, "┅┅┅⚫️┅┅┅┅┅┅" + " " + format(round(prop("Pages Read") / prop("Total Pages") * 100)) + "%", if(prop("Pages Read") / prop("Total Pages") >= .3, "┅┅🔴┅┅┅┅┅┅┅" + " " + format(round(prop("Pages Read") / prop("Total Pages") * 100)) + "%", if(prop("Pages Read") / prop("Total Pages") >= .2, "┅🔴┅┅┅┅┅┅┅┅" + " " + format(round(prop("Pages Read") / prop("Total Pages") * 100)) + "%", if(prop("Pages Read") / prop("Total Pages") >= .1, "🔴┅┅┅┅┅┅┅┅┅" + " " + format(round(prop("Pages Read") / prop("Total Pages") * 100)) + "%", "┅┅┅┅┅┅┅┅┅┅ 0%"))))))))))
How To Use The Formula
The properties “Pages” and “Pages Read” are placeholders that must be temporarily in your database before pasting the formula.
Either duplicate the page below and change the "Pages" and "Pages Read" property names to suit your database. OR
Create or temporarily rename two properties in an existing database called "Pages" and "Pages Read", copy and paste formula below into a new formula property, then return the properties to their original names (The formula will automatically update).
