- eyeconicAsked on July 25, 2016 at 10:21 PM
Actually this can be achieved by using the import range, if you set the destination spreadsheet to update automatically in the settings.
Go to File > Spreadsheet Settings > Re-Calculate > "On Change and Every Minute/Hour"
This will cause it to constantly pull the new data from the other spreadsheets regardless if there is a change detected or not manually.
I hope this helps! It helped me in a similar situation importing a field that was using an auto date range calculation to determine number of days since a specified date.
- JotForm SupportChriistianAnswered on July 25, 2016 at 10:29 PM
Thank you for the suggestion @eyeconic. This will be very helpful for other users who might want to do the same. However, I would suggest to create a new spreadsheet where we will use the ImportRange function. This is to ensure that the integrated spreadsheet is kept intact, since any modifications done to the integrated spreadsheet may cause the integration to break. Cheers.
- eyeconicAnswered on July 25, 2016 at 10:51 PM
Of course. I did not mention that directly, but referred to the new spreadsheet as the destination spreadsheet. You definitely want it to be separate.