# Progress Bar **URL:** \ **Category:** Ask for Help\ **Created:** [March 31, 2021, 8:02am UTC](https://community.glideapps.com/t/progress-bar/24961 "2021-03-31T08:02:40Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [March 31, 2021, 8:02am UTC](https://community.glideapps.com/t/progress-bar/24961/1 "2021-03-31T08:02:40Z")
Hi, ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/15b7b6058b7490b220579e1eec3b1597667119f1.jpeg) User have to tick all question. How to make calculation a progress bar, if they tick or fill in the column the progress bar shows 100%. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 31, 2021, 8:45am UTC](https://community.glideapps.com/t/progress-bar/24961/2 "2021-03-31T08:45:10Z")
A simple way: - Instead of putting ticks and crosses in each column, put 1 for done and 0 (or empty) for not done - Then create a math column that adds all the columns together - You can then use that in your progress bar. ie. if you have 12 columns and the sum is 6, then they are 50% complete. ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [March 31, 2021, 8:56am UTC](https://community.glideapps.com/t/progress-bar/24961/3 "2021-03-31T08:56:14Z")
Not presentable right if we put 1 instead of tick sign, Is there any other ways? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 31, 2021, 9:02am UTC](https://community.glideapps.com/t/progress-bar/24961/4 "2021-03-31T09:02:53Z")
There are lots of ways 😉 For example, you could use an if-then-else column to decide what to display… - If 0, then cross - Else tick ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [March 31, 2021, 9:09am UTC](https://community.glideapps.com/t/progress-bar/24961/5 "2021-03-31T09:09:23Z")
For you information, There a lot of column. Let say I have 30 column do i need to make if-then-else for each? ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [March 31, 2021, 9:21am UTC](https://community.glideapps.com/t/progress-bar/24961/6 "2021-03-31T09:21:59Z")
Previously i make something like this: Item 1 | Item 2 | IF Item 1 | IF Item 2 Tick | Tick | if item 1 tick show 1 | If item 2 tick show 1 But it is not applicable since i have a lot of column… ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [March 31, 2021, 9:39am UTC](https://community.glideapps.com/t/progress-bar/24961/7 "2021-03-31T09:39:35Z")
I don’t know if it could be ussable to you but if you create a new sheet with the questions (in the first col) and the answers in the second column ( with a user specific column in order not to erase the answers of another user ) then you can create a template column or a if then else that when it is a tick you put the email and if its a cross not and make a relation with your users sheet. Then maybe you can rollup how many emails dou you have there. I know its a bit confusing to read that but if i can help you with something just tell me ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 31, 2021, 9:49am UTC](https://community.glideapps.com/t/progress-bar/24961/8 "2021-03-31T09:49:16Z")
> [@adriasoce](#): > > I don’t know if it could be ussable to you but if you create a new sheet with the questions (in the first col) and the answers in the second column ( with a user specific column in order not to erase the answers of another user ) then you can create a template column or a if then else that when it is a tick you put the email and if its a cross not and make a relation with your users sheet. Then maybe you can rollup how many emails dou you have there. Yes, laying out the questions in a single column would be a much better approach. ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [March 31, 2021, 9:52am UTC](https://community.glideapps.com/t/progress-bar/24961/9 "2021-03-31T09:52:01Z")
Then you cannot see others answers because are user-specific but you can count them and displaying to that user. Which is what you want i understand. ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [April 1, 2021, 1:14am UTC](https://community.glideapps.com/t/progress-bar/24961/10 "2021-04-01T01:14:30Z")
Hi adriasoce, Thanks for throwing your idea. But it is something like this? Question 1 | Answer-Question 1 | if the else email 1 | Question 2 | Answer-Question 2 | if the else email 2 | Roll up if then else email 1 | Roll up if then else email 2 ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [April 1, 2021, 7:20am UTC](https://community.glideapps.com/t/progress-bar/24961/11 "2021-04-01T07:20:26Z")
No, I mean to have a table like this - Column 1: Question - Column 2: Answer (user specific) - Column 3: pick the actual signed user with an if then else (if answer tick → email, else blank). Then in your users sheet you can relate the email of the user with that newtable-\>column3 and then rollup (with count option) how many emails do you have there (which are the ticked answers) and there ou have the count for each user (only visible for them not for all). Do you need to show to everybody how many ticks have all your users or only visible to each one their ticks?