Skip to content Skip to sidebar Skip to footer
Home / Google Apps / Google Apps Script / Google Sheets / Google Sheets Formula / Javascript

Does Google Sheet Needs To Be Opened For A Function To Run?

Post a Comment
I have a google sheet where there are some functions in the cell like: =CLEAN(SUBSTITUTE(CONCATENATE('https:',scrape(A1)),'https:',)) =CLEAN(SUBSTITUTE(CONCATENATE('https:',sc

Solution 1:

No...But you might need to use SpreadsheetApp.flush() in your scripts to make sure that when you read values off of the spreadsheet after intermediate operations that your getting the correct values.


Post a Comment for "Does Google Sheet Needs To Be Opened For A Function To Run?"