# FOrmulas for progress bar

**URL:** <https://community.glideapps.com/t/formulas-for-progress-bar/740>\
**Category:** Ask for Help\
**Created:** [September 30, 2019, 6:36pm UTC](https://community.glideapps.com/t/formulas-for-progress-bar/740 "2019-09-30T18:36:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jesschrist](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jesschrist/32/86_2.png) [@jesschrist](https://community.glideapps.com/u/jesschrist)\
**Post date:** [September 30, 2019, 6:36pm UTC](https://community.glideapps.com/t/formulas-for-progress-bar/740/1 "2019-09-30T18:36:34Z")

</div>

I havent quite mastered the progress bar. Are there any preferred formulas being used to total the completion of items in the app. Also I am measuring a combo of inputted text, true/false values, and numbers to determine progress. Im getting errors but if there is an easier way to make this valid, Im open to ideas.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [September 30, 2019, 11:55pm UTC](https://community.glideapps.com/t/formulas-for-progress-bar/740/2 "2019-09-30T23:55:26Z")

</div>

I put this [simple spreadsheet](https://docs.google.com/spreadsheets/d/1Z_YIF6HfSTxGm787joYOLbx2TqIJwANaGtODfZ7Wgk0/edit?usp=sharing) together to test it out and show you the formula I would use. It’s in C2. You could hard code the values for min($F$4) and max($G$4) but I put them in as variables so you can test it. Let me know if it fails on any number comb. Note that it will go negative and I have no idea how glide would handle it. I’m guessing it would just show zero progress. I also did a column D calc, which uses the MIN MAX from the data. Not sure anyone would do it but it’s there if you want it. Bottom line you need to use a calculation that max’s at 100 and min’s at 0.

```auto
=ARRAYFORMULA(IF(B2:B,(B2:B-$F$4)/($G$4-$F$4) * 100,""))

```

---

<div class="post-metadata">

**Author:** ![deepu\_coolguy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deepu_coolguy/32/4448_2.png) [@deepu\_coolguy](https://community.glideapps.com/u/deepu_coolguy)\
**Post date:** [March 20, 2020, 10:55am UTC](https://community.glideapps.com/t/formulas-for-progress-bar/740/3 "2020-03-20T10:55:27Z")

</div>

When I input a custom value in the editor itself, it doesn’t show progress, am I doing something wrong?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 20, 2020, 11:53am UTC](https://community.glideapps.com/t/formulas-for-progress-bar/740/4 "2020-03-20T11:53:17Z")

</div>

Screenshots? What are you trying to do? What are the settings for your progress bar? What column value are you using for the progress bar? Are you on an add/edit/view/form screen?