🏁 Progress Bar Formula
A seamless touch to any database in need of a quick view progress bar that doesn’t include extraneous data or require exact percentages. Great for students and those who prefer to visualize data in a non-numerical format.
STEP 1
Add two number columns: Sections and Section Read. You may change the names of these columns after formula input. It will update automatically.
![Screen Shot 2019-11-25 at 11.51.38 AM.jpg](https://images.squarespace-cdn.com/content/v1/5a049a70be42d60e92dd8246/1574700714918-TZ8K2F9OUUHDSPUTG59H/Screen+Shot+2019-11-25+at+11.51.38+AM.jpg)
![Screen Shot 2019-11-25 at 11.52.40 AM.jpg](https://images.squarespace-cdn.com/content/v1/5a049a70be42d60e92dd8246/1574700773962-SAV4ITQN9SR45ZEMTHAP/Screen+Shot+2019-11-25+at+11.52.40+AM.jpg)
STEP 2
Add a "formula" Progress column.
Add the following to the Progress formula input:
if(prop("Sections Read") / prop("Sections") == 0, " ✖︎", if(smallerEq(prop("Sections Read") / prop("Sections"), 0.1), "◉ ", if(smallerEq(prop("Sections Read") / prop("Sections"), 0.2), "◉◉ ", if(smallerEq(prop("Sections Read") / prop("Sections"), 0.3), "◉◉◉ ", if(smallerEq(prop("Sections Read") / prop("Sections"), 0.4), "◉◉◉◉ ", if(smallerEq(prop("Sections Read") / prop("Sections"), 0.5), "◉◉◉◉◉ ", if(smallerEq(prop("Sections Read") / prop("Sections"), 0.6), "◉◉◉◉◉◉ ", if(smallerEq(prop("Sections Read") / prop("Sections"), 0.7), "◉◉◉◉◉◉◉ ", if(smallerEq(prop("Sections Read") / prop("Sections"), 0.8), "◉◉◉◉◉◉◉◉ ", if(smallerEq(prop("Sections Read") / prop("Sections"), 0.9), "◉◉◉◉◉◉◉◉◉ ", if(smallerEq(prop("Sections Read") / prop("Sections"), 0.99), "◉◉◉◉◉◉◉◉◉◉ ", if(prop("Sections Read") / prop("Sections") == 1, " 🏁", ""))))))))))))
STEP 3
Test the formula! Input 7 under sections and let’s say you've only consumed 4 sections thus far. 6 dots, or about 60% finished should be the result. Below are three random results:
STEP 4
Hide Sections and Sections Read columns for minimal aesthetic. These properties are still visible to manipulate in page property header.
![Screen Shot 2019-11-25 at 12.09.31 PM.jpg](https://images.squarespace-cdn.com/content/v1/5a049a70be42d60e92dd8246/1574701850520-3QWQF5UUVIBML6FUA6AO/Screen+Shot+2019-11-25+at+12.09.31+PM.jpg)
![Screen Shot 2019-11-25 at 12.10.26 PM.jpg](https://images.squarespace-cdn.com/content/v1/5a049a70be42d60e92dd8246/1574701850651-EAZZF89ZP9L4T630YTSI/Screen+Shot+2019-11-25+at+12.10.26+PM.jpg)