Scroll Database for more progress bar examples.
| Name | Completed | Total | Star Bar | Ship Slider | Shader Bar | Dot Bar | Diamond Bar |
|---|---|---|---|---|---|---|---|
0 | 0 | 100 | ☆☆☆☆☆☆☆☆☆☆ % | ⏅⏜⏜⏜⏜⏜⏜⏜⏜⏜⏜ | ░░░░░░░░░░ % | ◦◦◦◦◦◦◦◦◦◦ % | ◇◇◇◇◇◇◇◇◇◇ % |
1 | 1 | 100 | ☆☆☆☆☆☆☆☆☆☆ 1% | ⏅⏜⏜⏜⏜⏜⏜⏜⏜⏜⏜ | ░░░░░░░░░░ 1% | ◦◦◦◦◦◦◦◦◦◦ 1% | ◇◇◇◇◇◇◇◇◇◇ 1% |
19 | 3 | 16 | ★☆☆☆☆☆☆☆☆☆ 19% | ⏜⏅⏜⏜⏜⏜⏜⏜⏜⏜⏜ | ▓░░░░░░░░░ 19% | ●◦◦◦◦◦◦◦◦◦ 19% | ◆◇◇◇◇◇◇◇◇◇ 19% |
50 | 50 | 100 | ★★★★★☆☆☆☆☆ 50% | ⏜⏜⏜⏜⏜⏅⏜⏜⏜⏜⏜ | ▓▓▓▓▓░░░░░ 50% | ●●●●●◦◦◦◦◦ 50% | ◆◆◆◆◆◇◇◇◇◇ 50% |
72 | 72 | 100 | ★★★★★★★☆☆☆ 72% | ⏜⏜⏜⏜⏜⏜⏜⏅⏜⏜⏜ | ▓▓▓▓▓▓▓░░░ 72% | ●●●●●●●◦◦◦ 72% | ◆◆◆◆◆◆◆◇◇◇ 72% |
99 | 99 | 100 | ★★★★★★★★★☆ 99% | ⏜⏜⏜⏜⏜⏜⏜⏜⏜⏅⏜ | ▓▓▓▓▓▓▓▓▓░ 99% | ●●●●●●●●●◦ 99% | ◆◆◆◆◆◆◆◆◆◇ 99% |
100 | 100 | 100 | ☑︎ | ⏜⏜⏜⏜⏜⏜⏜⏜⏜⏜⏅⚑ | YASS | ●●●●KILLED IT●●●● | --------◆DONE◆-------- |
The formulas build off of the “Completed” and “Total” number columns. In practical use, many people use this formula to see the progress of a Project with how many tasks are related to it. To accomplish this, simply use the rollup feature to roll-up the total tasks related to the project. Then, roll-up the completed tasks related to the project. Use those rolled up columns to make your formula.
Star Bar Formula
if(prop("Completed") / prop("Total") >= 1, "☑︎", slice("★★★★★★★★★★", 0, floor(prop("Completed") / prop("Total") * 10)) + slice("☆☆☆☆☆☆☆☆☆☆", 0, ceil(10 - prop("Completed") / prop("Total") * 10)) + " " + format(round(prop("Completed") / prop("Total") * 100)) + "%")Ship Slider Formula
if(prop("Completed") / prop("Total") >= 1, "⏜⏜⏜⏜⏜⏜⏜⏜⏜⏜⏅⚑", slice("⏜⏜⏜⏜⏜⏜⏜⏜⏜⏜", 0, floor(prop("Completed") / prop("Total") * 10)) + "⏅" + slice("⏜⏜⏜⏜⏜⏜⏜⏜⏜⏜", 0, ceil(10 - prop("Completed") / prop("Total") * 10)))Shader Bar Formula
if(prop("Completed") / prop("Total") >= 1, "YASS", slice("▓▓▓▓▓▓▓▓▓▓", 0, floor(prop("Completed") / prop("Total") * 10)) + slice("░░░░░░░░░░", 0, ceil(10 - prop("Completed") / prop("Total") * 10)) + " " + format(round(prop("Completed") / prop("Total") * 100)) + "%")Dot Bar Formula
if(prop("Completed") / prop("Total") >= 1, "●●●●KILLED IT●●●●", slice("●●●●●●●●●●", 0, floor(prop("Completed") / prop("Total") * 10)) + slice("◦◦◦◦◦◦◦◦◦◦", 0, ceil(10 - prop("Completed") / prop("Total") * 10)) + " " + format(round(prop("Completed") / prop("Total") * 100)) + "%")Diamond Bar Formula
if(prop("Completed") / prop("Total") >= 1, "--------◆DONE◆--------", slice("◆◆◆◆◆◆◆◆◆◆", 0, floor(prop("Completed") / prop("Total") * 10)) + slice("◇◇◇◇◇◇◇◇◇◇", 0, ceil(10 - prop("Completed") / prop("Total") * 10)) + " " + format(round(prop("Completed") / prop("Total") * 100)) + "%")Related Resources
Created in Notion by Josh Redd at NotionState. 🖤
Find value here? Consider buying me a coffee ☕
