New answers tagged google-apps-script
0
votes
Function to create a calendar for one year with gaps (date and days in separate cells)
The answer to this question does not require a script. The OP is correct that "autofill" does not work. However a simple copy/paste do the job. The key is to copy not only the "calendar&...
- 4,753
1
vote
Google Workspace Marketplace only shows first 100 sheets add-ons
There isn't. You might make a feature request directly to Google by clicking the help button (the circle with a ?) then Send Feedback.
One workaround is to use Google (web search), i.e.
site:https://...
- 41.9k
0
votes
Target range coordinates exceed sheet dimensions
Try
destinationSheet.insertRowsAfter(lastRow, numRows);
...before sourceRange.copyTo().
- 6,748
0
votes
Accepted
Copy variable Range (fixed number of columns, flexible number of rows based off cell value) to last row of another tab in the same sheet
Delete:
getRange(sourceRange).copyTo(destinationSheet.getRange(lastRow+1,1),SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
Substitute:
sourceRange.copyTo(destinationSheet.getRange(lastRow+1,1),...
- 4,753
0
votes
How to make the specific dropdown list reset to the specific choice daily?
There are two ways to do this.
1-Write a script
Write a script that will update the status column once a day.
The WebApps question Reset drop-downs contains a solution/precedent, but you said I have ...
- 4,753
0
votes
Custom trigger to update values in a column from a formula
This is a suggestion for a solution to the selling price calculation method.
Note this method doesn't include a process to "trigger" and update to the "Data 1" sheet. This method ...
- 4,753
0
votes
How to set C1=D1 then clear D1 Google Sheets using App Script
The code you show does not clear cell C2, so chances are that have another script project (not shown) with a trigger that clears that cell. Remove the other trigger to sort out the issue. See ...
- 6,748
0
votes
Copy variable Range (based off cell value) to another tab
To do that with a script, use Range.offset(), like this:
const sourceSs = SpreadsheetApp.getActive();
const numRows = sourceSs.getRange('template!P16').getValue();
const sourceRange = sourceSs....
- 6,748
0
votes
Schedule a script to run at midnight to append current date to sheet
Use Sheet.appendRow(), like this:
function appendDateRowToSheet() {
const ss = SpreadsheetApp.getActive();
const sheet = ss.getSheetByName('Sheet1');
const timestampFormat = 'yyyy-MM-dd';
...
- 6,748
0
votes
Copying Values immediately based on other cell Values
You've asked a VERY narrow, closed question - you're inviting a yes/no answer. So:
Yes, it can be done
an apps script is the conventional way to do it.
trigger the script by using on OnEdit or ...
- 4,753
1
vote
Automatically Color Series In Chart
The following answer was developed piecemeal and many elements could have been combined to create a more efficient process. However, each of the functions will run standalone and this may assist the ...
- 4,753
Top 50 recent answers are included