Use for questions about Google Sheets custom functions (created using Google Apps Script)
Custom function for Google Sheets, written in JavaScript.
Could be used together with
Useful resources
Questions tagged [google-sheets-custom-function]
59 questions
1
vote
1 answer
How to programmatically add custom functions?
I'm trying to build a rather unique google sheets addon. Google's documentation is great for adding custom functions, however I want my addon to programmatically add custom functions.
For instance, the following doesn't seem to be possible:
Assume…
bumpkin
- 3,321
- 4
- 25
- 32
1
vote
1 answer
Combining Data From Many Cells into One
Im putting together a pretty lengthy spreadsheet in google spreadsheets. This spreadsheet contains information about products ie name, brand, part number, ect... I was helped previously and given some nice solutions but I am still running into…
user2970972
- 83
- 1
- 12
1
vote
2 answers
Google Spreadsheet Script invoked too many times per second for this Google user account
I have a google spreadsheet with a script to calculate tallies, weights, etc., and the spreadsheet calls the script's functions many times in it's cells. A few days ago, it started giving me "Script invoked too many times per second for this Google…
user2679878
- 19
- 2
0
votes
1 answer
Custom Function Google Sheets that displays a message containing a value from another cell
I have been working on this function and would love to display the value of a particular cell in the message that pops up.
This cell is in the same row as the "current cell" if that is of any help, I am just very lost and not even sure if this is…
sophmp
- 19
- 1
- 5
0
votes
1 answer
Creating a pop-up form on google sheets using custom forms
I am very new to creating functions on google sheets and so am struggling in creating code that returns a value from a pop up form.
I have been playing around with this code from Google Apps Script:
var ui = SpreadsheetApp.getUi();
var response =…
sophmp
- 19
- 1
- 5
0
votes
2 answers
Custom function with variable arguments implementation using apps script
I have come across custom functions in Google apps script. It involves writing a function which return value after process.
How do I write the below IFS function using apps script
function ifs(args)
{
????
}
I now want to understand how the…
Code Guy
- 3,059
- 2
- 30
- 74
0
votes
1 answer
Custom Sheets function to be used with ARRAYFORMULA
I am trying to use the following custom function DrivingKms with ARRAYFORMULA so that it recursively calculates the distance down the specified columns.
How can I update it so that it works with ARRAYFORMULA?
function DrivingKms(origin,…
Roggie
- 1,157
- 3
- 16
- 40
0
votes
0 answers
Google Spreadsheet Custom Functions when evaluated/executed?
I got a Google Spreadsheet with two custom functions in a container-bound Appscript.
function helloWorld() {
var message = "Hello World.";
console.log(message);
return message;
}
function getTimeStamp() {
return new Date();
}
I'm then…
Matthias
- 5,574
- 8
- 61
- 121
0
votes
1 answer
Parallelizing requests with fetchAll in a custom function causes it to crash
I'm trying to optimize this code to make it as short as possible I use it to call an API to get data in a Google Sheet. I've been told that it's the fetch that makes the script so long, and that I could try with a fetchAll but it breaks my code, I…
allanetu
- 1
- 3
0
votes
1 answer
How do I create a function that returns the last time a cell was modified?
I'm looking to write a function for Google Sheets Script that accepts a cell reference and outputs the date that cell was last modified. I'm not sure how to get started.
0
votes
2 answers
Make a simple counter in Google Scripts which keeps track of previous value
so I'm trying to make an auto-rotating schedule using google sheets and a custom function which selects a new employee from a linked sheet each week and then starts again at the top of the list when it gets to the bottom, using a Google trigger to…
akajanedoe
- 15
- 8
0
votes
1 answer
Search through all sheets for a string which have a specific value in the cell next to it
I have a custom formula script that loops through all sheets containing "@" in their tab name. In there, I then look through a range to find the string that I am searching for (given as an argument). If I find that string in the range, I run some…
harvanchik
- 78
- 5
0
votes
1 answer
Script do delete all rows and columns and rerun custom function
I have a function on a google sheet that extrapolates data from an ESI and fills in rows and columns with said data.
Since the data gets old and needs to be updated it would be handy to have a script to run that deletes all rows and columns (except…
Simon Riccio
- 23
- 3
0
votes
2 answers
Count the number of cells that have the text strikethrough
I would like to create a custom function to count the number of strikethrough text. Would it be possible to create a script to perform this operation?
For the moment, I managed to create a script that counts the cell number with the strikethrough…
Psychomecano
- 1
- 1
0
votes
2 answers
Get row from currently highlighted cell in google sheets
I want to create a data validation list that automatically updates itself based on the current row. In other words, I want a dropdown in column C with all the values that have been entered into column C for the current value in column A.
I placed…
David Heylen
- 3
- 4