custom-function Questions
2
Solved
I have a custom function that accepts three range names as input parameters. When values of cells in these ranges change, the function output stays the same. This is a "feature" of the platform.
I...
Carl asked 6/8, 2014 at 14:37
2
In Google sheets Script, I'm trying to copy value from one cell in Sheet A to another cell in sheet B.
The problems is, when I start avgUtilisationPerWeek() function in oogle Sheets script e...
Shocker asked 10/5, 2017 at 7:37
1
Solved
I am trying to make a script where I have the address of the cell.
In excel, I have this code:
Function pos(cell As Range)
pos = cell.Address
End Function
And it gives me the address of the ce...
Syringomyelia asked 2/7, 2019 at 21:36
6
Solved
In a spreadsheet I can enter =SIN(45)+123 in a cell, and it will be evaluated.
How can I evaluate spreadsheet functions within a custom function, something like an "eval"
function that would work ...
Hedges asked 7/11, 2014 at 16:5
4
As far as I understand, in order to track our quota usage, we need to provide our API key to the Google App Service on the service we are planning to use.
In my case I have a spreadsheet with Orig...
Blench asked 9/3, 2015 at 18:3
1
Solved
I have a Google Sheet where we are fetching the driving distance between two Lat/Lng via the Maps Service. The function below works, but the matrix is 4,500 cells, so I'm getting the "Hit Limit" er...
Crying asked 5/6, 2018 at 15:7
4
Solved
I'm stuck on a something basic. How do I pass arguments to a Google Sheets custom function.
I have a function in the Apps Script code editor defined as:
function usageByMonth(range,theDate) {
//...
Speculator asked 26/1, 2016 at 18:39
4
Solved
I am very new to Google Apps Script (as well as JavaScript, for that matter), but I have been trying to tinker with it for fun.
I have tried writing a script to fetch API price data in Google She...
Bizarre asked 27/6, 2017 at 7:55
2
I am stucking on a "scraping problem" right now. Especially i want to extract the name of the author from a webpage to google spreadsheet. Actually the function =IMPORTXML(A2,"//span[@class='author...
Co asked 18/8, 2016 at 9:37
1
Solved
i am trying to solve this super simple problem and i am already sick of it, I hope somebody can help my out with this. I have a dataframe of shape like this:
---------------------------
| Categor...
Overthecounter asked 18/11, 2016 at 16:24
5
Solved
Test script
$i = 0;
array_uintersect(['foo', 'bar'], ['baz', 'qux'], function($a, $b) use (&$i) {
print_r([$a, $b, $i++]);
});
Actual Result
Array
(
[0] => bar
[1] => foo
[2] =>...
Profligate asked 27/10, 2016 at 15:43
3
Solved
When I call a spreadsheet function, say int(f2), the function operates on the value in the cell. If cell("F2") contains 3.14159, the result would be 3.
But when I call a different type of function ...
Finespun asked 30/8, 2012 at 22:20
1
Solved
I created anew function in sheets from within a sheet. The function is not recognized:
From within the sheet tools > script editor
function DOUBLE(input) {
return input * 2;
}
save
Go into the ...
Rosarosabel asked 18/8, 2015 at 16:32
3
Solved
It is possible to add "custom function help" to a google spreadsheet?
i.e. If I type =sum into a spreadsheet cell, I get floating help text,
is there a way to do this with custom functions?
Docume...
Sidero asked 22/2, 2013 at 1:28
2
I want to use Google Apps Script to make custom functions for a spreadsheet. I've made an extremely simple function:
function foo(){
return "bar";
};
The problem is that I need this function in...
Wrinkle asked 15/12, 2012 at 0:57
1
Solved
In google sheets, I'd like my custom function to use one of the built-in functions. Specifically, this function would take a string as a parameter, comb through another sheet to locate that v...
Converge asked 17/9, 2014 at 22:24
4
Solved
I am pulling data from a web service and it is formatted as JSON. I am writing a Google Apps Script for Google Sheets that will populate the data for me. My problem is, I can't seem to get it to pa...
Burdened asked 17/4, 2010 at 15:50
2
Solved
I have following function in a cell. It reads date from other cell, than calculates age and transforms it in format "3 weeks 5 days"
=INT((TODAY()-D19)/7)&" weeks, "&(TODAY()-D19-(INT((TOD...
Taking asked 13/7, 2013 at 16:4
1
Solved
Is there a way to access the cell coordinates (in A1 notation) of the cell that was passed in to my function?
For example, if my function is this
function displayA1Notation(myCell){
return myCel...
Carrolcarroll asked 27/10, 2012 at 4:19
1
Solved
I apologise if this has been asked before but I've looked for an example and unfortunately I'm unable to find an answer hence why I'm asking here.
If I have a custom function in a Google Spreadshe...
Exobiology asked 21/5, 2012 at 19:19
1
I'm having trouble running even the simplest Google Apps Scripts, for instance when I run this script by setting a cell my spreadsheet to =pantsHate(Y) I'm getting this error:
error: You do not...
Bellman asked 8/5, 2012 at 20:37
© 2022 - 2025 — McMap. All rights reserved.