We’re Still Here to Help (Even Over the Holidays!) - find out more here.
Forum Discussion
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.
5 Replies
Replies have been turned off for this discussion
- Walter
Dropbox Community Moderator
Hey 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!
Hello Water!
Thank you for the information. However, it doesn't work. It seems there are no importrange in list of formulas.- Hannah
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.
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.
- Jay
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.
