# Multiple sheets going to one screen

**URL:** https://community.glideapps.com/t/multiple-sheets-going-to-one-screen/12228
**Category:** Ask for Help
**Created:** [July 9, 2020, 6:03pm UTC](https://community.glideapps.com/t/multiple-sheets-going-to-one-screen/12228 "2020-07-09T18:03:42Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Mark\_Smillie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_smillie/32/833_2.png) [@Mark\_Smillie](https://community.glideapps.com/u/Mark_Smillie)
#### Post date: [July 9, 2020, 6:03pm UTC](https://community.glideapps.com/t/multiple-sheets-going-to-one-screen/12228/1 "2020-07-09T18:03:42Z")

</div>

Hola! I have a sheet that provides data to my “home screen” as you would normally set up an app/sheet. However, I have another sheet (sheet 2) that is being used to do an aggregation (AVG) calculation that I want to display on the “home screen”. Specifically, I am calculating the average multiuser rating on “sheet 2”, the result of which I want to display on the Home screen. I seem to remember seeing something that illustrated this but I cannot find it, TIA!

---

<div class="post-metadata">

### Author: ![Thibault\_Milan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibault_milan/32/4970_2.png) [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)
#### Post date: [July 9, 2020, 8:29pm UTC](https://community.glideapps.com/t/multiple-sheets-going-to-one-screen/12228/2 "2020-07-09T20:29:48Z")

</div>

So you can reference the result into your homescreen sheet into a new column  
`='Sheet2'!B2` for exemple if your result is in B2  
And then use it into your homescreen construction.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 9, 2020, 10:33pm UTC](https://community.glideapps.com/t/multiple-sheets-going-to-one-screen/12228/3 "2020-07-09T22:33:53Z")

</div>

Can you setup the calculation inside Glide using math/rollup?

---

<div class="post-metadata">

### Author: ![Mark\_Smillie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_smillie/32/833_2.png) [@Mark\_Smillie](https://community.glideapps.com/u/Mark_Smillie)
#### Post date: [July 10, 2020, 6:47pm UTC](https://community.glideapps.com/t/multiple-sheets-going-to-one-screen/12228/4 "2020-07-10T18:47:40Z")

</div>

Thanks @ThinhDinh and @Thibault_Milan. In this case that worked.

Ultimately it would be great to have containers in glide that let you reference other sheets per container.

---

<div class="post-metadata">

### Author: ![Thibault\_Milan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibault_milan/32/4970_2.png) [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)
#### Post date: [July 10, 2020, 7:01pm UTC](https://community.glideapps.com/t/multiple-sheets-going-to-one-screen/12228/5 "2020-07-10T19:01:54Z")

</div>

Well you can do it in certain way.  
If you set a tab as a Detailed view and remove everything, then you can put a list, for exemple, which get the content from another sheet and use the data from the current sheet of the tab. It’s not working for everything but it can do a lot 😃
