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 β