New answers tagged

0

The simple trigger onEdit only works when a user manually edit one or more cells, more specifically when the user: Type directly on a cell Type directly on the formula bar Paste over one or more cells (the paste action should modify the cells, pasting an image over the grid will not make the onEdit function to be executed) Paste over the formula bar Try ...


0

This is what I use: OFFSET(Sheet1!$A$1, 0, 0, Rows(Sheet1!$A:$A), Columns(Sheet1!$1:$1)) An advantage of using OFFSET over INDIRECT is that the reference will update if Sheet1 is renamed after this formula is entered.


1

You will need to get familiar with the basics of the Google Apps Script platform, in this case more specifically with installable triggers, so please read https://developers.google.com/apps-script/guides/triggers and https://developers.google.com/apps-script/guides/triggers/installable. Also you should get familiar with the JavaScript basics, more ...


0

One solution is not to create new tabs, but instead use the default tab always for new content. duplicate the default tab. the content of default tab change to new content duplicated tab remains with the old data


0

You can put the link in a cell, perhaps in a 'Config' sheet. The same applies to the range reference. Your formula will look like this: =importrange(Config!B2, Config!B3) To change the link, simply put a new value in cell Config!B2. If you want to automate that, use something like this: ss.getRange('Config!B2').setValue(newLink); To answer your question, you ...


0

While the size of the spreadsheet might have a performance effect on your script it is minimal compared to the execution time required by all the calls to the Google Apps Script Spreadsheet service (getRange, getValue, setValue), actually the best practices suggest use batch operations. More specifically, instead of reading/writing one value at a time, read/...


0

First you have to create the HTML, then assign it to the htmlBody property of the object set as sendMail parameter Example: function processEdit(e) { const html = '<p>Please go into the Parts Purchasing tab in the Saleable Indicator Report Folder and see the changes.</p><p>Make sure to Supersede parts that are active in your branch to the ...


0

You want suggestions about how to go about building the script for this task. I am concerned that a scripting skill level of 1% is too low to be able to build the scripts for this task - it's like walking around the block and then deciding that on the weekend you will climb Everest. The task is very involved and you have not yet been exposed to the skills ...


0

I had the same problem and I was able to fix it by using and connecting a GCP project with Google Sheets API enabled. This could be a factor of Google moving to a new editor and Apps Script. You can follow the instructions in this link, and it gives you a sample script as well, which should work if configured properly. https://developers.google.com/sheets/...


1

You want to delete all the protections, so you must be looking for a process that repeat itself, as long as the condition is matched. In your case as long there is a protection on C4:F30. Intuitively: You want to specify in which sheet you want to work on: var ss = SpreadsheetApp.getActive() Then you want to get all protections available in this sheet: var ...


0

Try this in cell A1: =+sort(E2:E, E2:E <> "", false, row(E2:E), false)


1

You want to loop through the data on a given sheet ("Driver List") and copy the data values from columns A, B, C and M to a second sheet ("Driver List2"). There are many precedents for this but you have attempted to write the code (which appears to constructed from a series of macros), and hopefully this answer will assist you to better ...


0

Well, I never did figure out a way to do this without a 'for' loop. However, thanks to my friend's suggestion, I did look around and figure out how to substantially speed up my for loop. Here is the revised example code. The code I posted for this example in my original question took me 1,431 ms, whereas the code below took 271 ms. And for my actual database,...


0

You can find all the Google Apps Script projects owned by an account or shared with it in https://script.google.com no matter if they are standalone or bounded scripts. It's worthy to note that the data shown in the third-party items might not be Apps Script projects owned or shared with you i.e. they could be Google Workspace add-ons (i.e. Gmail add-ons, ...


0

It is not possible to open or use Google doc without google account. Here is what you can do to protect your master template: Create a template and share it publicly view only. Grab the url and replace the last path element /edit with /copy. Example: https://docs.google.com/document/d/1BKMD8jG5Z6zUds1fonf-Vvt1uA3kAZoS5OCeCZTeFME/copy When a user opens ...


-1

It may be easier for you to utilize the build in Data Sort options provided by Google Sheets. Within the Data tab, click Sort range>in the dialogue box click "‘Data has header row option". This dialogue box always you to add an additional column to sort by and the "A-Z" sort works the same for numerical data. This article provides a ...


Top 50 recent answers are included