All Questions
Tagged with google-apps-script spreadsheet
679 questions
0
votes
2
answers
71
views
how to make a copy of a sheet each for week 3 weeks in advance
I am trying to make a weekly workbook for my team to see work coverage 3-4 weeks in advance. I would like the name of the new tab to be for the week ending on Saturday. It would copy from the tab made ...
0
votes
1
answer
142
views
Auto numbering rows in GoogleSheet
I want to create an auto-number for each row in my google sheet following the logic below:
it takes the sheet number from A1 e.g. 8
generates sequential table header numbers from that sheet number ...
- 1
0
votes
1
answer
65
views
Condition if-else
I'm trying to send some data from a spreadsheet to a different one.
What I need is, if the text of the last row in column B is "APPLE" or "ORANGE" it should go to cell AA7 of the ...
- 3
1
vote
1
answer
47
views
Google Apps Script is not exporting PDF blob correctly
I am scripting a tool that creates a copy from Google Slide file (a template) and replaces some data in the Slides with data from a Spreadsheet. Then it adds the link to the file in the same ...
0
votes
1
answer
77
views
Google Apps Script doPost request timing out when processing large spreadsheet data
I'm encountering an issue while attempting to run a Google Apps Script doPost request for processing a large spreadsheet containing approximately 30,000 rows of data. Despite the file being available ...
- 1
-1
votes
1
answer
111
views
Automatically create a new table every month
I would like to create a new table based on the active table and name it after cell A1 (e.g.: "June"). Addition: Ideally automatically after each month.
Thanks a lot
Stefan
var spreadsheet ...
0
votes
2
answers
69
views
Preventing or removing multiple instances of same range protected cells
I have two separate spreadsheets, one for admin and one for user. The admin can lock or unlock certain ranges for either Fri, Sat, Sun or Holiday via onEdit trigger (ie fridaycheck(). When checkmark ...
- 45
0
votes
1
answer
57
views
I cant use a single number on my function
I have this function here that calls another function. The problem is that I cant use single numbers in input prompt like (1, 2, 3) I have to add a letter like (a1, a2, a3) for this to work.
Actually ...
0
votes
0
answers
39
views
Is it possible to set triggers for another spreadsheet in GAS?
I think it is possible to set a trigger with the GAS code below, but is it possible to set a trigger for another spreadsheet file?
ScriptApp.newTrigger(function_name).timeBased().everyDays(...).atHour(...
- 762
0
votes
1
answer
772
views
How to efficiently copy borders (with formatting and values) between Google Spreadsheets?
Question Description:
In Google Apps Script, when we need to copy a range from one sheet to another within the same spreadsheet, we can use the copyTo method. However, when attempting to copy a range ...
- 150
1
vote
2
answers
68
views
Add floats found in single string
I have started using financial spreadsheets and am looking for a way to extract float (price) numbers from multi-line strings. Attached is an example of how I format my prices and totals by category:
...
0
votes
1
answer
132
views
When trying to open Google spreadsheet Apps Script, an error occurs and it cannot be opened [duplicate]
Apps Script cannot be opened and a text similar to the following is displayed.
Is this just me? Or is it a general problem with Google?
Google Docs encountered an error. Please try reloading this page,...
- 9
0
votes
0
answers
83
views
Google Sheet formula for week day number mapping check [or Google Apps Script]
I have a Google Sheet table:
SourceSheet Google Sheet (sample data) is available on: SourceSheet
Im trying to create formula in another sheet that checks each row (in above SourceSheet): D10, D11, ...
- 4,353
0
votes
2
answers
46
views
I want to use GAS to determine if nothing is entered in a cell, but I don't know how to handle `0`
I would like to implement a function that allows characters and numbers to be entered into a spreadsheet, and if nothing is entered using GAS, a message box will be displayed.
Therefore, I would like ...
- 762
1
vote
1
answer
53
views
I want to insert the information obtained from the spreadsheet into the dialog using GAS and HTML into the initial value of the text field
It is possible to retrieve information entered into cells in a spreadsheet.
Next, how can we insert the information obtained in HTML into a text field as an initial value?
I have created it so far, ...
- 762