In this report, I would like to introduce a workaround for automatically recalculating custom functions on Spreadsheet.
The sample situation is below. This is a sample situation for this document.
- There are 3 sheets with "sheet1", "sheet2" and "sheet3" of sheet name in a Spreadsheet.
- Calculate the summation of values of "A1" of each sheet using a custom function.
- Sample script of the custom function is as follows.