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!
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.
Can you setup the calculation inside Glide using math/rollup?
Ultimately it would be great to have containers in glide that let you reference other sheets per container.
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