New answers tagged

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&...
user avatar
  • 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://...
user avatar
  • 41.9k
0 votes

Target range coordinates exceed sheet dimensions

Try destinationSheet.insertRowsAfter(lastRow, numRows); ...before sourceRange.copyTo().
user avatar
  • 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),...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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....
user avatar
  • 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'; ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 4,753

Top 50 recent answers are included