Linking Data Between Spreadsheets

Hi there,

Is there a way to cross reference data cells from one spreadsheet and another? I can see how easy it is to cross reference tables within the same spreadsheet, but curious if there is a way to link between spreadsheets.

The use case is I have several spreadsheets that are going to different users, and one consolidated spreadsheet that takes the totals from the spreadsheets and summarises.

Thank you in advance for any assistance.

Kind Regards,
G

1 Like

Hey @SuperGav :wave:t4: — thanks for reaching out!

While there isn’t an IMPORTRANGE type of a function to interact with data from different spreadsheets inside Rows, what I’d recommend is pushing the data from a table in Rows to a Google Sheet using our integration and then pulling it back into another table in Rows — albeit tedious, that’s the best alternative I can think of :sweat_smile:

We also do have this proposal shared with our Product team but it doesn’t look like something that we’d be able to deliver in the next quarter or so.

Hope this helps.

1 Like

Awesome and thank you. That works well.

G

1 Like