0

I'm pulling a realtime quote from "spreadsheet B" into "spreadsheet A" through:

=IMPORTRANGE("url";"A1").

For some kind of reason the referenced cell in "spreadsheet A" is blank until I open "spreadsheet B". This will kickstart the realtime quotes and they will be updated also in "spreadsheet A".

It's worth mentioning that "spreadsheet B" is using a custom "apps script" in order to pull in those realtime cryptocurrency quotes.

Is there a way to have the calculations in "spreadsheet B" kickstarted only by accessing "spreadsheet A"? Thanks all!

rudyStock
  • 93
  • 1
  • 1
  • 10
  • 1
    I have to apologize for my poor English skill. I cannot understand `a custom script` of `It's worth mentioning that "spreadsheet B" is using a custom script to pull in those quotes.`. Can I ask you about the detail of it? – Tanaike Mar 18 '22 at 12:20
  • 1
    Try running the script everytime you open spreadsheet A – Cooper Mar 18 '22 at 13:19
  • 1
    What calculations have to be made on Spreadsheet B? Can you give more information on your workflow? – Kessy Mar 18 '22 at 13:58
  • If I try to import the script into the new spreadsheet it won't run for some reason, while it works in the original spreadsheet but it has to be triggered manually - by the simple opening of the spreadsheet. I wonder if there's a script or function which can trigger a script present in another spreadsheet (Not sheet) – rudyStock Mar 20 '22 at 16:04
  • Custom function in spreadsheet A right? Checkout https://stackoverflow.com/questions/17341399/refresh-data-retrieved-by-a-custom-function-in-google-sheet – TheMaster Mar 21 '22 at 20:34
  • 1
    Have you thought of using a [Time-driven trigger](https://developers.google.com/apps-script/guides/triggers/installable#time-driven_triggers) on she spreadsheet b that triggers the custom apps script script? – Kessy Mar 25 '22 at 12:11
  • Like Kessy says, you could try to trigger the Spreadsheet B script using the time-driven triggers. They will not be real-time though. You could try an onOpen or onEdit connected to spreadsheet A but that would require that whoever is using Spreadsheet A also has access to Spreadsheet B. Also worth noting that if Spreadsheet B is updating frequently, importrange may be unable to keep up with the changes. – a-burge Mar 28 '22 at 10:20

0 Answers0