SpreadsheetApp.flush() to force the spreadsheet to finish calculating before retrieving the data in my script, however it still seems to pull the data before calculations are finished. Should I be using
SpreadsheetApp.flush() before or after opening the spreadsheet with
SpreadsheetApp.openByUrl(spreadsheetURL)? Or maybe after my call to
userSpreadsheet.getSheetByName("Timecard")? I've tried each, but to no avail.
Any help is appreciated!