🚀 Colorful Notion Formula
Update your Notion progress bars with these colorful designs. All you’ll need is a percentage to work with and the following formulas. Included are two designs, one for a slider progress bar, and another for a Notion progress bar that changes colors as the percentage increases. Here is how they work.
The Notion Progress Bar Design
This colorful slider uses a Notion formula that divides the progress bar into two lines. To create a line break in a formula use "\n”.
This progress bar changes colors as the percentage increases from red to yellow to green. This formula uses only one line and provides a simpler design.
How To Use Them
The Slider Progress Bar
Replace every instance of .5 with a calculation that results in a percentage or another number property that is a percentage.
"🟥🟥🟥🟨🟨🟨🟨🟩🟩🟩 " + format(floor(1000 * .5) / 10) + "%" + "\n" + slice("▔▔▔▔▔▔▔▔▔▔", 0, 10 * .5) + "^"
The Color Changing Progress bar
if(.5 < 0.2, "🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(.5 < 0.3, "🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(.5 < 0.4, "🟥🟥🟥⬜️⬜️⬜️⬜️⬜️⬜️⬜️", if(.5 < 0.5, "🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️⬜️", if(.5 < 0.6, "🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️⬜️", if(.5 < 0.7, "🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️⬜️", if(.5 < 0.8, "🟨🟨🟨🟨🟨🟨🟨⬜️⬜️⬜️", if(.5 < 0.9, "🟩🟩🟩🟩🟩🟩🟩🟩⬜️⬜️", if(.5 < 1, "🟩🟩🟩🟩🟩🟩🟩🟩🟩⬜️", "🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩"))))))))) + " " + format(floor(1000 * .5) / 10) + "%"
When To Use Them
Date Progress Bar
Track progress of dates for today, this week, this month, and this year. No other properties required. All you’ll need is a formula.
Habit Tracker Progress Bar
Find the total percentage of completed checkboxes in a Notion database and return the following progress bars. This uses an extra required property to calculate the percentage of checkboxes. More about this extra step here.
Bookshelf Progress Bar
Using two separate properties, you can find the progress of a book with one number property labeled Pages Read divided by another number property labeled Total Pages. And so, the percentage you will need to build a progress bar can be achieved with existing properties.
Plan and track the month's fitness accomplishments with the template button and general tracking properties in Notion! This template is a simple calendar database with various easy at-home workouts to follow inside. Every workout only requires body weight and no extraneous weights or equipment. Included is a simple weight loss tracker.