Construct a progress bar by simply setting the values you need and then copying and pasting the result.

To copy a formula from the Progress Bar Formula column, double click its cell. This will quickly display and then dismiss the formula panel and leave the cell selected. You can then copy and paste the formula.

Progress Bar Builder

Completed / Goal Examples

These examples use a total amount and a completed amount to calculate the progress.


Completed Only Examples

These examples use a single number to calculate the progress, so that result will need to be less than or equal to 1


Double Progress Examples

Multiple progress bars can be shown in one formula by simply chaining together the output with + "\\n" + to add each on a new line.