How to make progress bar in Notion?

Tricks Mar 19, 2022

When I launched my Resolution Board Template, the single most asked thing was how to get the progress bar in the database column using Formulas. So in this article I will you a break down on how to create.

Formula to create Progress bar

How to make progress bar in Notion
How to make progress bar in Notion

First you create a Database. Next, remember to have two fields in the database Target and Done. Well you can name is essentially any thing but do keep in mind to replace it in the formula as well.

Add Formula to the Database
Add Formula to the Database

Now create a progress property with type formula. Next, copy the following formula inside the edit formula section. Remember that we have named your property differently replace it here.

if(prop("Done") / prop("Target") == 0, " 💪🏼 Let's start", if(smallerEq(prop("Done") / prop("Target"), 0.1), "■ " + format(round(prop("Done") / prop("Target") * 100)) + "%", if(smallerEq(prop("Done") / prop("Target"), 0.2), "■■ " + format(round(prop("Done") / prop("Target") * 100)) + "%", if(smallerEq(prop("Done") / prop("Target"), 0.3), "■■■ " + format(round(prop("Done") / prop("Target") * 100)) + "%", if(smallerEq(prop("Done") / prop("Target"), 0.4), "■■■■ " + format(round(prop("Done") / prop("Target") * 100)) + "%", if(smallerEq(prop("Done") / prop("Target"), 0.5), "■■■■■ " + format(round(prop("Done") / prop("Target") * 100)) + "%", if(smallerEq(prop("Done") / prop("Target"), 0.6), "■■■■■■ " + format(round(prop("Done") / prop("Target") * 100)) + "%", if(smallerEq(prop("Done") / prop("Target"), 0.7), "■■■■■■■ " + format(round(prop("Done") / prop("Target") * 100)) + "%", if(smallerEq(prop("Done") / prop("Target"), 0.8), "■■■■■■■■ " + format(round(prop("Done") / prop("Target") * 100)) + "%", if(smallerEq(prop("Done") / prop("Target"), 0.9), "■■■■■■■■■ " + format(round(prop("Done") / prop("Target") * 100)) + "%", if(smallerEq(prop("Done") / prop("Target"), 0.99), "■■■■■■■■■■ " + format(round(prop("Done") / prop("Target") * 100)) + "%", if(prop("Done") / prop("Target") == 1, " 🚀 Completed", ""))))))))))))
Formula to create progress bar in Notion

That's it, Your progress bar is ready. You can name the 0% and 100% state differently. I have named them  "Let's Start" and "Completed" respectfully. Here is how it's gonna look.

Progress bar in Notion using Formula
Progress bar in Notion using Formula

Conclusion

I hope you like this experiment and it will help you create an awesome template. That you can then sell on Prototion and make some money. We are always in need of creators like you. Join us now.

Btw, the above gif is from one of our really popular template "Product Launch Ki 🚀". As our readers, we are giving you a special coupon to get 10% off on the template. Enjoy 🎉
 

Tags

Sarthak Sharma

Founder of Prototion 📕 | JavaScript Nerd 👨🏻‍💻| Life Hacker 🔧 | Philosopher 🧘🏻‍♂️ | Serial Maker 🌱 | Shipped 15 Products ✨|

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.