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:
Here is my sheet:
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.