We’re Still Here to Help (Even Over the Holidays!) - find out more here.
Forum Discussion
Yuliia Halkina
3 years agoExplorer | Level 4
Google sheet importrange formula
Hello team!
Does Dropbox support importrange formula in google sheet? I can't find it in list of formula. In this case, I can't connect two google sheets between each other.
Walter
Dropbox Community Moderator
3 years agoHey Yuliia Halkina, thanks for using Dropbox and welcome to our Community!
Can you take a look at this discussion and let us know if it helps at all?
Thanks!
Yuliia Halkina
3 years agoExplorer | Level 4
Hello Water!
Thank you for the information. However, it doesn't work. It seems there are no importrange in list of formulas.
- Hannah3 years ago
Dropbox Community Moderator
Hey Yuliia Halkina, sorry to jump in here.
It seems that IMPORTRANGE should work, even though it is not in the list of formulas.
However, you'll need to make sure the master file is in your Google Drive.
There are some steps in the thread that Walter linked in his response above, that should be able to help you.
- Yuliia Halkina3 years agoExplorer | Level 4
Hello Hannah!
Thank you for the information! I did all steps indicated in Walter's message, but it doesn't work. Despite the fact that I use the same account and I cut information until /.
Does importrange formula work between two google sheets inside Dropbox? While I tried it, I receive the message that Spreadsheet cannot be found.
- Jay3 years ago
Dropbox Community Moderator
Hi Yuliia Halkina, the IMPORTRANGE function will only work if the master sheet is in a Google Drive. If both sheets are in Dropbox, then the function will fail.
About Integrations
Find solutions to issues with third-party integrations from the Dropbox Community. Share advice and help members with their integration questions.
The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.
If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X, Facebook or Instagram.
For more info on available support options for your Dropbox plan, see this article.
If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!