All Questions
Tagged with google-apps-script custom-function
411 questions
2
votes
1
answer
62
views
Throwing errors in an array-valued custom formula [duplicate]
I have created a custom formula in Google Sheets that can take in an array and output another array. Some of the values in the input array may result in an error; I would like to show that error for ...
- 105
-3
votes
1
answer
147
views
Spreadsheet custom function suddenly stop working
I use this to keep track of my stock portfolio, been using it for almost three years now, and recently it stop working, can't figure out why.
function MyPortfolio2(tickers, values , price)
{
var ...
- 9
0
votes
1
answer
54
views
How to make a function format data within its own cell?
I want a custom function that can auto format data units. Turning 1000 m to 1 km. Put simply I cannot get the function to format the cell it is located in.
I plan on adding conditions later to format ...
- 9
-1
votes
1
answer
49
views
Avoid re-rendering of a custom function
I am defining a custom function in Google Apps Script that calls an external API to return some value in the cell. It seems like that it keeps calling this function at certain intervals or on opening ...
2
votes
2
answers
71
views
What elements of this section of code do I need to adjust once I duplicate it to add another variable?
I was given a custom function to add to the spreadsheet I’m building but it doesn’t quite do what I now need it to do. I have a basic understanding of JavaScript but since I didn’t write this code, I’...
- 21
0
votes
3
answers
125
views
How to get a list of all sheet names that contain "week of" that updates on edit
Im new to Apps Script and need some assistance with the code required to get a list of all sheet names (current and those to be created) that will start with "Week of" in the title. Ideally ...
0
votes
1
answer
65
views
Trying to reduce Column A by 10% and then replace the old numbers in Column A with the new numbers
So I have almost zero knowledge of custom functions in Google Sheets. But I am trying to take the numbers in each cell in Column A, reduce it by 10%, then replace the old numbers with the new reduced ...
0
votes
0
answers
80
views
Substantial difference between GOOGLEFINANCE on sheets and on-platform
I'm using GOOGLEFINANCE to plot SPARKLINE miniatures of forex currencies. I use these miniatures as a preview, looking for any interesting patterns, so that I can inspect details on Google Finance ...
- 6,068
0
votes
0
answers
53
views
Update cells with custom formula upon any part of workbook being edited [duplicate]
I have a custom formula where I check the workbook for a certain cell color and return the sum. I also want to update the cell for the last date and time the function was run/updated. I currently have ...
0
votes
0
answers
59
views
Run script and update same cell when changes to spreadsheet are made [duplicate]
I'm trying to update the cell when changes are made on any sheet in the workbook. Here is the script that only runs when I initially call the function in the cell
function countColoredCells(countRange,...
0
votes
1
answer
50
views
Google Sheets Run Function in all sheets
I'm trying to run a function to count the number of cells that have a certain background color accross all sheets. The cell color referenced is in the Practice sheet A6.
Here is the App Script:
...
0
votes
1
answer
280
views
Download generated QR codes as image
I just want to preface this post by saying I have little to no experience with coding. I've been recently tasked with downloading several QR codes from a Google Sheets document that have been ...
- 1
0
votes
1
answer
350
views
Set a cell background color based on a HEX value from another cell
From this question:
Set the background color to a cell based on a hex value
I'm looking for a formula that I can write down in a cell then in an adjacent cell appears the HEX color I wrote down. And ...
- 3
0
votes
0
answers
18
views
I don't know how to make a custom function to change colours of numbers separated by "/" [duplicate]
I'm trying to make a custom function that will assign a different colour to each set of characters that are separated by "/", so that it would look like this:
different coloured text ...
0
votes
1
answer
112
views
Getting Range not found when using getRange()
Every time I use getRange in my program (lines 8 and 11), I get an error
Exception: Range not found,
but I cannot figure out why.
I tried using getA1notation() and toString() , but both resulted in ...
- 3