We have a Google Spreadsheet that pulls data from an external source via an
IMPORTDATA() function and then a Google Apps Script that is on a timed trigger that performs other things with the imported data.
It's failed a few times which makes us wonder whether the
IMPORTDATA() function is refreshing the data if the sheet is not manually opened? Or in other words when the Apps Script fires from it's timed trigger does the sheet automatically refresh it's formulas?