All Questions
162 questions
0
votes
2
answers
77
views
Clear active sheet without clearing formulas or Letters
I have written this script to clear data and keep formulas, however I would like to keep
the letters. IE column titles I have made so that when I enter data I know where it goes.
This is my current ...
-3
votes
1
answer
95
views
How do I store data from month to month in Google App Script?
I have an app script that is setup to a trigger to automatically send out the statistics on the 1st of each month. I currently store the data using PropertiesService() class in name value pairs. The ...
1
vote
1
answer
61
views
How use loop variable in column or row number?
I wrote a simple apps script to repeat set formula:
for (var i=157;i<=160;i++)
{
spreadsheet.getRange('E'+i).activate();
spreadsheet.getCurrentCell().setFormula('=concatenate(F&i:AG&i)')...
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
1
vote
1
answer
30
views
Customize y-axis
I have a few charts with data and I want the y-axis to autofit to the data + a buffer of 10%.
The customize tools don't have this option. I don't have any coding background, but with the help of ...
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
53
views
Error when trying to use addRange in Embedded Line Chart Builder
I am posting it here after trying multiple solutions.
My Data in Gsheet looks like
I am trying to draw an line Chart my code is below
var c_data = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(...
- 331
2
votes
0
answers
58
views
Console.Log in Apps Script returns correct order but Google Sheets does not
I am creating a sheet for a gaming organization I am a part of. I am attempting to sort a list of names based on characteristics of their in-game character. After checking the output of a particular ...
- 21
0
votes
0
answers
113
views
How to Get and Set Formulas as a text string with GetFormulas and SetFormulas?
I need a bit of help figuring out how to get and set formulas in App Script while converting them to text strings in-between. For example:
I have 3 sheets, Sheet 1 contains source formulas, Sheet 2 ...
0
votes
1
answer
58
views
cannot enter the data every third row and sum 1 column
enter image description herecannot input query data every third row on the target google sheets
tried query and appscript
trying to sum column 9 value using the unique values of columns 6,5 and 7 and ...
0
votes
1
answer
439
views
Appsheet calculated expired date spesifiec 2
I have an Appsheet who consist of two columns, let's both named is Production Date and Expired Date. If column Production Date has 35 months of Expired Date, then how the formula in appsheet to ...
0
votes
1
answer
619
views
Appsheet calculated expired date spesifiec
I have an Appsheet who consist two column, let's both named is Production Date and Expired Date. If column Production Date has 2 years of Expired Date then how the formula in appsheet to calculated it?...
0
votes
2
answers
58
views
Function button not working, only works manual input
Can you please help me why its not working everytime i click on button its not updating. I want to get the old value of column J and column K and set it to column L and M everytime it was change. ...
-1
votes
1
answer
74
views
Is there a way to auto-populate a cell with a drop-down answer when a new row is added?
I am trying to use a google spreadsheet to create an appointment booking tracking system.
When a new row is added in the spreadsheet, the "SHOW" column will auto-populate the cell with the &...
- 1
0
votes
0
answers
42
views
script that checks for specific phrases in an https response for a list of urls and returns a not working status
I have a list of embed urls, and I want to check the ones that are not working.
The problem is the one that is not working; it is not a broken link; it just deleted from the website and still displays ...
- 9