Questions & Answers

Google Appscript

I created a custom Google Apps script that uses data from a different sheet in the same spreadsheet file, which works as intended. However, after a period of time, the function gets called again and returns all '0's in every cell, including closing and reopening the file after a while.

It's a custom function that takes in 3 parameters from different sheets, and is simply called from A1 in it's own sheet.

=DataCalc('Set-Up'!E2, 'Set-Up'!D6:D, 'Data Entry'!N2:R)

I'm retrieving the other sheet via

var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Calculations");

if that's a potential culprit.

The function works again if I delete and replace the function in the cell.

2023-01-23 23:10:18
Welcome to Stack Overflow. The question lacks the necessary detail to make it answerable. See How to create a Minimal, Reproducible Example.
2023-01-23 23:10:18
Please include your complete function and how is the function executed, is it a custom function, menu driven, button, trigger?
2023-01-23 23:10:18
The question continues to lack necessary debugging details.
2023-01-23 23:10:18
Please add a minimal reproducible example (add the a whoule Google Apps Script function that replicates the problem, including some sample data input data and enough details so other can reproduce the same problem). The title should be descriptive and summarize the question body.
Answers(0) :