How to make progress bar in Notion?

Sarthak Sharma -

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 give you a break down on how to create.

Formula to create Progress bar

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

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

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 🎉