Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
0
votes
1answer
16 views

Replacing part of a formula using Script

So I usually use template formulas (like - =IMPORTRANGE(LINK,Sheet1!A1) where link is the variable I replace using find and replace). So, now I wanted to automate this task, i.e. for example the ...
0
votes
1answer
39 views

How to speedup this simple google spreadsheet script?

I just learn to create entry data form in google sheet, I managed to get tutorial in Google and seems work fine with my little modification to my meet. but somehow I think is going slow over time ...
0
votes
0answers
18 views

In Google Sheets football squares [closed]

I'm creating a shared Google Sheet Football Pool. I'd like a form to popup, asking for the user's name. Then, when the user clicks on a square (cell), it automatically enters the user's name into the ...
0
votes
1answer
30 views

Adding HTML into sendEmail

I've got an email that populates when the sheet is edited. But the body of the mail displays strange line breaks that aren't in my code. My code: function processEdit(e) { MailApp.sendEmail({ to:...
0
votes
1answer
29 views

Remove All Protections on Selected Range

I am trying to remove all protections on a range. I created a script that adds a protection when a user pushes a button. If the user pushes the button twice, it adds the protection twice. I came up ...
0
votes
1answer
23 views

Loop through each row on one sheet coping specific cells of each row to a second sheet until an empty row(last row) is found

I'm new to sheets script. I want to Loop through each row on one sheet (Driver List) while copying specific cells of each row to a second sheet (Driver List2) until an empty row (last row) is found. I'...
1
vote
1answer
129 views

Where is the Apps Script located which Google Account is referring to?

Scenario Under myaccount.google.com > security > Third party apps page, there are a few App Scripts apps listed, like so: But there is no link or project ID or any way to actually reach or ...
0
votes
1answer
11 views

Google doc access to anyone but keeping mastercopy as it is

I have one google document - which i like to keep as a master copy/template. I want to allow users without any kind of email/account to access this master copy - edit something and save it to doc file ...
1
vote
1answer
17 views

How to Set Values for Discontinuous Cell Locations All at Once?

I am trying to populate a form template on a sheet. Say the a1 locations of the fields on the form to populate are: [B7, B9, D8, D11] (In actuality, I have 65 different fields.) I want to populate ...
0
votes
1answer
30 views

Double Sorting on Google Sheets

My sheet has a drop-down menu with options 1.-4. in column C. I want it to then further sort each option segment using column A. So that option 1. is sorted A-Z separately from option 2. etc. How can ...
0
votes
0answers
11 views

I used Google Apps Script as a text editor, and now the file will not load

Basically just had one long open comment to use as a journal. Now I'm getting "unexpected error occurred" and a spinning loader when attempting to open the project. Is it lost?
0
votes
2answers
32 views

Custom Function to Cross-Joining

I am looking for a flexible custom function to be able to cross-join (cartesian product) 2 columns of varying lengths in Google Sheets. My research so far has led me to ask because: using a ...
-1
votes
1answer
29 views

How to get the newest value of column E and display the value in A1?

I need help to make Google spreadsheet like this. You can input values in column E, and the value of the newest input is displayed in A1. I tried the below code, but it didn't work. function ...
0
votes
1answer
16 views

How do I correct the automatic borders that are scripted into this Google Sheet?

I have this Google Sheet document that already has functionality built in which applies automatic borders. I don't know how it is doing this. I've tried looking in the Script Editor, but I don't see ...
0
votes
2answers
11 views

Getting the ThumbnailLink of a freshly created File in GAS

I've been trying create a file and then access its ThumbnailLink in GAS. this works well - let _file = DriveApp.createFile("TEMPFILE.svg", svg); let file = Drive.Files.get(_file.getId()); (...
0
votes
2answers
16 views

Can Google Sheets macros respect protected ranges?

I have developed a Google Sheets spreadsheet with loads of macros, but I want to have a protected version of it, a blank "master copy" that I then duplicate every time I want to use it. I ...
0
votes
1answer
25 views

Convert Script into HTML and have links embedded

I have the below script and want to have the URL links embedded instead of the whole link appearing on the automatic emails, but don't know how to convert this script into an htmlbody script to have ...
0
votes
1answer
15 views

Merged cells not preserved when copying and pasting

I wrote a script to copy and paste a block of cells from one sheet to another in Google Sheets, and everything is working fine except the merged cells are no longer merged after the cells are pasted. ...
0
votes
1answer
33 views

How does one automatically update rows/data with a Slicer filter when a spreadsheet is edited?

How does one automatically update a Slicer when data is changed on a spreadsheet? I would like it so that when I change cells and data on the spreadsheet, the Slicer filter will automatically update (...
0
votes
1answer
19 views

Is there a way to embed a specific cell from a Google Sheets to Google Docs?

I want to fill in a sentence with blank spaces on Google Docs from information that I can provide from Google Sheets. Is this possible? "For my student number X = [student_number], the required ...
0
votes
1answer
22 views

Notification email with data from different columns when edit is made to cell in the same row

I've browsed similar questions but I'm a bit flabbergasted. Google Sheet name: Book List Records Tab Name: Books sent to Wisconsin When any cell in column E is (manually) changed in the tab mentioned ...
0
votes
1answer
23 views

Copy Row Script & Paste at last Row in the Same Sheet

Do you guys have idea in script how can I copy the details on quotation GE-2108-0271-Rev.0 in few pages and paste the row at the bottom in the same sheet? Page 1: to be exact I need the number ...
0
votes
0answers
21 views

Clear Some Cell Values Based on Another Cells Value

Just looking for some help with the below script, as I need the IF statement to be between "29" and "50" and not just 29 or more, as this impacting other cells that it shouldn't. ...
0
votes
0answers
9 views

Small differences between data visible in Google Analytics panel and provided by Google Analytics API

I'm using a Google Analytics API to transfer data from Analytics to a Google Sheet. However, for data within the scope of the same filters and data range, I can see small discrepancies (~10%) between ...
0
votes
0answers
19 views

Get the title and other metadata of a PDF using Google Apps Script

I have a lot of research papers in my google drive. They are all in PDF format. To better manage this large collection of papers (>1k), I want to make a simple table (a Google sheet), in which I ...
0
votes
1answer
18 views

Pop Up in Google Sheets for Viewers and Editors

Is there a way to create a pop-up messsage that shows in Google Sheets not only to Editors/Collaborators but also to those with "view only" privileges?
0
votes
1answer
34 views

Date comparison is not working as expected

I'm working on a small project, using Google Sheets and Google Script to generate a tennis scheduling system. Basically the user enters their info on a Google Form, which is passed to Google Sheets ...
0
votes
1answer
31 views

Daily record log to different spreadsheet

I would like to be able to log the last value with yesterdays timestamp to a completely different Google sheet, but am a bit stomped by the complexity of this. I have a sheet that logs "...
0
votes
1answer
17 views

running script over multiple sheets

My programming knowledge is weak at best. I would like to be able to run the below script over a few of my sheets in google-sheets. The sheets names would be "Liquor Room", "Mezz" &...
1
vote
2answers
67 views

Help with dynamic dependent dropdown

How do I change this dynamic dependent dropdown list script so it works with my particular Google Sheet. function onEdit(){ var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var ...
-1
votes
1answer
7 views

Sending email with check box formula gives me range error using script

Here is the script for this it keeps saying range undefined and I cant figure it out function onEdit(e) { // this script is installed as an installable onEdit trigger /* if the checkbox is ...
0
votes
1answer
43 views

Problem with invalid regular expression missing / (slash)

I have a spreadsheet. I want to send emails from the Apps Script. The logic to send email as follows. Only send 1 email to each unique value in Column A (Co Name) the content of the email will include ...
0
votes
1answer
16 views

RSS News Feed collection into Google Sheet Problem

So I was given a good direction from a previous post, however there are a few flaws that somehow made it stop working. Here is the original goal: Have a google sheet that refreshes the rss link and ...
0
votes
1answer
67 views

Google sheet RSS feed automatically Update

So my goal is to have a google sheet that collects news from different RSS feeds and updates as new article happen in the feed. So far I have found two "methods", one is inserting "?=...
0
votes
1answer
19 views

Counting sheets viewer

How do I use Google Apps Script to find out how many "current viewer" and their status, such as 'idle' or not. I've already search thru all the question and answer, but only found how to ...
0
votes
1answer
67 views

Track highest and lowest number reached in a specific cell over a period of time in google sheets

I have a cell that references the total value of a stock portfolio. I want to figure out how I can let Google Sheets (over a period of time, say a month) automatically tell me the highest number and ...
0
votes
1answer
16 views

After deleting cell contents, cell is no longer "blank" when comparing in a conditional using == ""

In my else statement below, if a cell in column G is blank I want to clear the contents (the timestamp) of another cell in column F using the event function onEdit(). However, after testing the code ...
0
votes
1answer
32 views

How can I use the onEdit() trigger to timestamp a cell if another cell in the same row is checked "TRUE" in apps script?

I am able to add a timestamp in column 5 using a conditional when I'm comparing the column to a number, but what I am actually trying to do is add a stamp to the corresponding cell in column 5 if a ...
0
votes
0answers
20 views

Duplicate and rename a sheet (only it`s data) at fixed hr and day [duplicate]

every monday I've to make a copy of a sheet which is called week_nn, where nn is a progressive number of the current week for that sheet from its beginning. At some point of the day, we have to fix ...
0
votes
1answer
29 views

Google Sheets - Turning text in cell into an image

I was wondering if it's possible to turn text into a picture. For example the text "Arizona Cardinals" is imported automatically into a Google Sheet and that cell recognizes "Arizona ...
0
votes
1answer
15 views

Send email when there is a change in column

I would like an automatic notification to be sent to several people when I entered 'Yes' in column C. I wish this would apply to Sheet1 only, not to the entire file. I have this code function ...
0
votes
1answer
17 views

Unlinking checkboxes

I have 3 checkboxes. When I check one, others get checked too. How to unlink them? //Validating Permition if(shUserForm.getRange("C14").getValue() == "0"){ ui.alert("Blank ...
-1
votes
1answer
51 views

How to transpose and split in Google Apps Script?

How do write script for below google form response as below time stamp Document No. Recipient Name Document transmittal ref no 7/9/2021 21:36:11 170709, 170738, 171769, 172003, 172025 Susan 20210001 ...
0
votes
1answer
20 views

Google script (custom function) doesn't get updated inside a cell

I have this function : function clastrow(targetsheet) { var SS= SpreadsheetApp.getActiveSpreadsheet(); var Sheet = SS.getSheetByName(targetsheet); return(Sheet.getLastRow()); } function ...
0
votes
1answer
8 views

What should I do to get a working script to not affect the formatting

I have a script from users Iamblichus and Cooper which creates a list of sheetnames and updates the list as the names are edited or new ones are created. The script does very well copying the data ...
0
votes
1answer
41 views

Paste special values using a script

I am a beginner and need to write a simple script to paste special values in Google Sheets. I tried the below script, but it's not working. function livedata_Function() { var spreadsheet = ...
0
votes
1answer
26 views

Need Script changed to a different page in the same sheet

I have a script on a sheet in my Google Sheets workbook that emails when a cell changes to "TRUE", but the cells in question are a vlookup to another sheet in the workbook. This works in the ...
0
votes
1answer
18 views

Needing to change a column to false when Data Validation is changed

I am using Google sheets and have a cell that has data validation and I am putting check boxes (I4:I) for people when items are received, they need to be changed to "False" when the Data ...
0
votes
1answer
25 views

openById / openByUrl always returns empty object/null [duplicate]

I am unable to access my spreadsheet via openById or openByUrl. Is there a permission setting I am not aware of? There is no verbose output indicating why it is unable to open the spreadsheet.
0
votes
0answers
19 views

Make links work on copied sheet

I have created a plan book template within google sheets and at the top I have a header to link to a certain day. When I make a copy of the sheet for another week the links are still for the last ...

1
2 3 4 5
31