custom-function Questions
2
Is there a way to get the identification (i.e. A1 notation) of a selected cell or range in Google Sheets?
Something like:
=SELECTION(['Sheet1']) -> "D6"
Trihydric asked 11/6, 2015 at 11:23
14
I have a few Simple Custom Functions that I use all the time. I have recently run into a spreadsheet that I desperately need to use them in, but when I try to use even the most basic custom functio...
Lemur asked 16/6, 2015 at 21:3
1
I created a google apps script for Google Sheets with some simple custom functions. But when I Test the Deployment as an Add-on to a test Sheet. The custom functions don't work in the test sheet. H...
Platoon asked 4/2 at 6:58
25
Solved
I have a spreadsheet with some values in column G. Some cells are empty in between, and I need to get the last value from that column into another cell.
Something like:
=LAST(G2:G9999)
except t...
Wessex asked 12/11, 2010 at 23:21
22
Solved
I've written a custom Google Apps Script that will receive an id and fetch information from a web service (a price).
I use this script in a spreadsheet, and it works just fine. My problem is that ...
Surfbird asked 27/6, 2013 at 11:1
2
Solved
Is there a FORMULA that will display the name of the file in a cell?
I've found scripts that will do it, formulas that will display the sheet name, but no luck finding a formula that will show the...
Who asked 11/8, 2019 at 19:3
2
Solved
I'd like to document (in the Google Sheet autocomplete) a custom function with optional arguments, similar to the WEEKDAY function (autocomplete below).
The JSDoc spec on optional arguments does n...
Macarthur asked 26/1, 2019 at 23:0
4
In Google Sheets (as with Excel, etc) if a user enters bad input into a formula, an error code will be printed in the offending cell and a small pop-up provides more detail about the error. So if I...
Encrimson asked 2/10, 2014 at 0:9
4
Solved
PHP's native sorting functions modify by reference and do not return the sorted array.
I am looking for a reliable standard method to sort an array, returning the sorted array as the return value.
...
Rennarennane asked 10/9, 2013 at 13:45
1
I've been trying to create a Google Spreadsheet plugin from some existing Google App Scripts that I have, and one important part of this app script is Custom Functions.
I have seen an addon that ca...
Irma asked 18/1, 2023 at 13:8
4
I've followed the instructions from: https://developers.google.com/apps-script/execution_custom_functions to create a custom function.
Neither my functions or even cut and paste from the tutorial ...
Ardenardency asked 3/8, 2012 at 21:25
1
I have a Google Apps Script custom function, very simple:
function sharesBurned(sharesToSell) {
return "tree"
}
Obviously, this works when I test it in Apps Script. In my sheet, when I...
Neuropath asked 3/3, 2022 at 15:54
1
Solved
I have a working custom function but not sure how to allow it to loop with a list of inputs. Looks like I need to understand apply() and the such but I'm not quite there with my current setup. The ...
Hirsch asked 11/2, 2022 at 16:42
2
Solved
I've created a dynamic column name w/ dplyr::mutate() based on this thread Use dynamic variable names in `dplyr` and now I want to sort the new column.... but I'm not correctly passing the column n...
Million asked 7/2, 2022 at 7:23
3
Solved
What is the difference between array_udiff_assoc() and array_diff_uassoc()?
For array_udiff_assoc(), I have this code:
function myfunction($v1,$v2)
{
if ($v1===$v2) {
return 0;
}
return 1;
}
...
Pinhead asked 2/2, 2012 at 17:35
3
I have created the following simple function:
function test(r,c) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
sheet.getRange(r,c).setBackground("red");
return 1;
}
...
Wallow asked 26/6, 2014 at 7:42
1
I am getting the following error in my Google sheet:
Service invoked too many times for one day: urlfetch
I know for a fact I am not making 100k calls, but I do have quite a few custom functions i...
Corrinecorrinne asked 15/11, 2019 at 21:38
4
Solved
I am trying to set some value to a cell in a Google Spreadsheet:
function exampleFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var range1 = sheet....
Meander asked 10/4, 2013 at 17:57
10
Solved
I don't quite understand the syntax behind the sorted() argument:
key=lambda variable: variable[0]
Isn't lambda arbitrary? Why is variable stated twice in what looks like a dict?
Extravasate asked 23/1, 2012 at 2:9
6
Solved
I try to participate in my first Kaggle competition where RMSLE is given as the required loss function. For I have found nothing how to implement this loss function I tried to settle for RMSE. I kn...
Tonietonight asked 8/5, 2017 at 18:49
2
Solved
I have a Google Sheet with a custom function formula that: takes in a matrix and two vectors from a spreadsheet, does some lengthy matrix-vector calculations (>30 sec, so above the quota), befor...
Flemming asked 18/6, 2020 at 18:34
1
Solved
I have a .tsv file from a tool and I have to import it the Google Sheet (nearly) real-time for reports. This is my code for importing:
function importBigTSV(url) {return Utilities.parseCsv(UrlFe...
Trench asked 23/5, 2020 at 10:8
1
Solved
Google implies that JsDoc is supported:
Custom functions will appear in this list if their script includes a
JsDoc @customfunction tag, as in the DOUBLE() example below.
https://developers.go...
Journalist asked 10/5, 2020 at 12:3
2
I want to write a custom function which has some mandatory arguments but can also accept a few optional arguments. I couldn't find any documentation on this. Does anyone know? Is it similar to Java...
Ianteen asked 1/6, 2012 at 2:45
2
I have written a custom function for Google Sheets in Apps Script. The goal is to have a sheet which automatically calculates who owes how much money to whom (e.g. to split a bill).
My sheet looks...
Contractor asked 10/10, 2018 at 13:12
1 Next >
© 2022 - 2024 — McMap. All rights reserved.