Category "custom-function"

How to use for to sum a range in google app script?

I want create a simple custom sum formula in google Spreadsheets using google app Script. function somaDias(range, days) { var sum = 0; for(i=0; i<d

Work around for JSON data import in Google Sheet using custom script

enter image description here I want to import data from a table within an HTML page. Used IMPORTHTML =IMPORTHTML("https://www.fpi.nsdl.co.in/web/Reports/FPI_For

Custom functions intermittently hang with "Error - Loading Data"

I have a Google Apps Script custom function, very simple: function sharesBurned(sharesToSell) { return "tree" } Obviously, this works when I test it in