# Using a Progress Bar to Count Items Completed in Checklist **URL:** \ **Category:** Ask for Help\ **Created:** [May 3, 2021, 10:12pm UTC](https://community.glideapps.com/t/using-a-progress-bar-to-count-items-completed-in-checklist/26358 "2021-05-03T22:12:14Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![RyanThomas](https://avatars.discourse-cdn.com/v4/letter/r/ba8739/32.png) [@RyanThomas](https://community.glideapps.com/u/RyanThomas)\ **Post date:** [May 3, 2021, 10:12pm UTC](https://community.glideapps.com/t/using-a-progress-bar-to-count-items-completed-in-checklist/26358/1 "2021-05-03T22:12:14Z")
I’m a little bit at a loss for how to proceed here and feel like there must be a simpler way to achieve what I’m doing. Here is my app: > **[Activity Board](https://activityboard.glideapp.io/)** Here is my sheet: > **[Truck Info App](https://docs.google.com/spreadsheets/d/116OpzNZidYdURs_jujb0b39hNdPJlmxkCP_fqXTKnrM/edit?usp=sharing)** > > Project > > Order Number,Fuel Cost,Mileage,Expendables Used,Missing Gear,Damaged Gear,Project ID,Truck,Pick Date,Return Date,Prep Tech (Prep),Location,Call Client Check,CRM Complete (-Hold),Hold Complete,Hide Processing Tasks,Generators,2000w Generator... Basically, we have a check in/check out checklist for rental orders. I would really like to add a progress bar at the top so its much more clear if they have completed all of the prep tasks, and then another progress bar if they have completed all of the return tasks. I found a few people suggesting to use roll up columns, but it seems like that will count the true check boxes vertically, when my projects run on the sheet horizontally. I started to try and use CountIF, but found that wouldn’t work with an array formula. I did find some other solutions in sheets, but it was a bit uncharted territory and I’m wondering if there is a simpler way to achieve this. Any help would be appreciated. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 3, 2021, 10:43pm UTC](https://community.glideapps.com/t/using-a-progress-bar-to-count-items-completed-in-checklist/26358/2 "2021-05-03T22:43:49Z")
Yeah, the problem with horizontal checklists is that you can’t use rollups (and thus are not dynamic in the event you wanted to add more items to the list). You’ll need to create a math column that adds the true/false values for each column together to get the user’s progress and then tell Glide how many checkboxes there are in order to create the progress bar. ---
**Author:** ![RyanThomas](https://avatars.discourse-cdn.com/v4/letter/r/ba8739/32.png) [@RyanThomas](https://community.glideapps.com/u/RyanThomas)\ **Post date:** [May 3, 2021, 10:59pm UTC](https://community.glideapps.com/t/using-a-progress-bar-to-count-items-completed-in-checklist/26358/3 "2021-05-03T22:59:43Z")
Great, that seems like a pretty easy way to go about it. Thank you. Just curious, how would I have made my checklist vertical? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 3, 2021, 11:13pm UTC](https://community.glideapps.com/t/using-a-progress-bar-to-count-items-completed-in-checklist/26358/4 "2021-05-03T23:13:56Z")
There’s a couple ways to do it but basically you use user specific columns. I talk more about it here: [🔁 How to set up a recurring daily checklist](https://community.glideapps.com/t/how-to-set-up-a-recurring-daily-checklist/21430) ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/using-a-progress-bar-to-count-items-completed-in-checklist/26358/5 "2024-01-17T16:52:20Z")