I am building an event app. I originally only intended to use the multiple tabs on one google sheet. However, presenters have their own sheets with info I would like to show. What is the best way to use multiple sheets in one app?

You could use an IMPORTRANGE formula to create new tabs in your main Sheet that would pull in data from the others’ sheets into their own tabs of your main Sheet. Either that, or provide access to your sheet through the Sharing options in Google Sheets and the others can make their own tabs directly…

I am not sure that would be dynamic. Wouldn’t that just be a snapshot of the data at the time it was taken?

An IMPORTRANGE should update itself automatically when used. I don’t know what the delay would be when it’s used in conjunction with a Glide app, but it shouldn’t be any more significant than the usual Google Sheets delay.

Thanks. I’ll try that and report back.

I was just researching the same and came across this… [image] praypray>25K rows in GT, or external database. So needed! Feature Requests You list your database in another workbook all together. Then you use vlookup to pull the data. you can use the importrange function di…

IMPORTRANGE works quite well when your source data has a fixed set of columns that don’t/wont change. If that’s not the case, then it’s risky and subject to breakage. I use IMPORTRANGE generally only when the source sheets are under my control and so I can guarantee there won’t be any nasty surpris…

It did do what I needed it to do. Thank you.

Yeah, it would be easier to find but I’m a no name contributor :slight_smile:

Nah you just changed your icon one too many :stuck_out_tongue_winking_eye:

lol, the demotion from community expert didn’t help either, lmao.

Best way to "bring in" data from other spreadsheets

Ask for Help

Eric_Penn June 15, 2021, 1:20am 6

I was just researching the same and came across this…

Topic		Replies	Views
Two Googlesheet files for the same application Ask for Help	6	122	May 18, 2024
Can I create app linked to multiple spreadsheets? Feature Requests	5	432	June 25, 2020
Can tabs within an app read from different google sheet files? Feature Requests	15	3306	May 17, 2020
Adding second google sheet Ask for Help	9	276	August 29, 2021
Probème de synchronisation google sheets et Glide Ask for Help	2	119	November 14, 2023

Best way to "bring in" data from other spreadsheets

Related topics