# Progress bar: Change source?
**URL:** https://community.glideapps.com/t/progress-bar-change-source/13692
**Category:** Feature Requests
**Created:** [August 7, 2020, 11:47am UTC](https://community.glideapps.com/t/progress-bar-change-source/13692 "2020-08-07T11:47:16Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Raph](https://community.glideapps.com/u/Raph)
#### Post date: [August 7, 2020, 11:47am UTC](https://community.glideapps.com/t/progress-bar-change-source/13692/1 "2020-08-07T11:47:16Z")
Hello,
As much as we can change the source for an INLINE LIST, I’d like to be able to do so for a PROGRESS BAR (to be able to select from another google sheets tab the info to do, say, a pie chart).
Maybe that’s possible already with some kin of a workaround?
Thank you, Raph
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 7, 2020, 12:00pm UTC](https://community.glideapps.com/t/progress-bar-change-source/13692/2 "2020-08-07T12:00:46Z")
Can you bring that over using relations & lookups?
---
### Author:  [@Raph](https://community.glideapps.com/u/Raph)
#### Post date: [August 7, 2020, 12:41pm UTC](https://community.glideapps.com/t/progress-bar-change-source/13692/3 "2020-08-07T12:41:47Z")
I’d love to but haven’t been able so far… 😕
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 7, 2020, 1:10pm UTC](https://community.glideapps.com/t/progress-bar-change-source/13692/4 "2020-08-07T13:10:52Z")
Tell me if I can help.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [August 8, 2020, 6:58pm UTC](https://community.glideapps.com/t/progress-bar-change-source/13692/5 "2020-08-08T18:58:51Z")
Relations and lookups/rollups would be the best way. What kind of problems are you having using that method?
---
### Author:  [@Sarit](https://community.glideapps.com/u/Sarit)
#### Post date: [September 8, 2020, 5:29pm UTC](https://community.glideapps.com/t/progress-bar-change-source/13692/6 "2020-09-08T17:29:50Z")
So I had the same problem that I just solved.
I wanted to pull through a pass/fail rate from the other tab.
In the test tab:
I did a relation between the person’s name column in the main sheet and the name in the test sheet.
then a roll up count of all the all the values ( 2 passes and a fail gives a count of 3).
math column -\> pass/ amnt of tests = pass rate
In main tab:
rollup of the pass rate (sum)
and a rollup of the amnt of tests (count)
template column -\> Pass Rate Out of X Sessions where X = amnt of tests
now make a progress bar with Pass Rate as your column and the template as your title