Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
1
vote
2answers
302 views

Adding 1 to a Cell with VLookup

So this is my first time trying to write a script, and the sheet I am working on is here. The script I'm trying to run would allow me to push a button and have it use Vlookup to add 1 to a cell in ...
-1
votes
2answers
62 views

Google Sheets - Looking for script that auto capitalizes all cells in a specified column

Looking around, I found different things, but I never found the spot where you could specify the range, and I'm not familiar with this script. Can someone please show me a script for this? For ...
0
votes
1answer
15 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 ...
1
vote
1answer
7k views

Send a Google Forms response to specific email address based on form response

I need to send Google Forms responses to specific clinicians at my practice depending on whether they have been selected on a drop-down menu in the form. At the moment, Google Forms sends an email to ...
0
votes
1answer
270 views

Changing a cell value based on another cell's color?

In my Google Sheets in column F, I want to include the word "LATER" based on magenta color (#ff00ff) that is in column B starting from row 227, how should I write this script? I'll really appreciate ...
0
votes
1answer
78 views

How to Copy Cell Value and Format From One Tab to Another Using a Formula?

An answer was provided in this question: webapps: Cell reference with colour formatting for doing so within a tab, but not across tabs. Does anyone have suggestions for a script that will work across ...
0
votes
2answers
23 views

Auto Sort different ranges

I have a google sheet that I would like to sort different ranges by the 2nd column in each range. Example: A B C D E F G p 7 1 h 9 1 q 6 2 j 3 2 g 9 3 p 7 3 I need the range A:C sorted by B ...
0
votes
1answer
104 views

Google Apps Script MailApp Not Sending Email To Script Owner

I've set up a script to take information from a Google Form and email that information to multiple people using Google Apps Script. What it does not do, however, is email the owner of the script. I'...
0
votes
1answer
17 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
20 views

Google Sheets Google Forms updates

I have created a Google Form for which collects data from a user. Once the use submits the form I have scripts that copy the data to several other Google sheets and then send an email to the ...
0
votes
1answer
32 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
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
334 views

Limit number of rows

I have a Google Sheets document that keeps adding hundreds of rows and slowing down the project, and sometimes causing it to crash. Is there a way to limit the number of rows to say 100. I do not ...
0
votes
1answer
26 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
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
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 ...
2
votes
1answer
109 views

Script to place duplicate Google sheet beside the sheet it copies (instead of the end)

Is there any way to modify my script to have the sheet it's copying insert the new sheet immediately to the right of the one it's copying? I have tons of tabs in the file, and it's starting to get ...
0
votes
1answer
33 views

Script that reads rows and columns in a sheet and returns strings with frequency of occurrence

first time caller! I have a single column that contains comma separated names (lots of names) -- I am trying to find a script that can read the comma separated string entries in cell and give me a ...
0
votes
1answer
21 views

How do I write a script that exits a cell that is being edited

If I enter a value in cell A1 without exiting the cell . Before I exit editing A1 I run a script that at some point selects another cell B1 , while A1 is still being edited. When I then click C1, the ...
2
votes
3answers
960 views

Google Spreadsheet Script Trigger: This app is blocked

I am trying to create a trigger for a script in google spreadsheet and upon trying to save the trigger I am getting the following error: This app is blocked This app tried to access sensitive info in ...
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 ...
40
votes
9answers
86k views

How to specify the entire sheet as range in Google Sheets?

The best workaround I have found so far is: worksheet_name!$A$1:$YY but ideally I would like to be able to simply write, e.g.: worksheet_name! So, does anyone know: is there a syntax for ...
0
votes
1answer
26 views

How to apply "sendAlertEmailWhenCellValueIsNotEmpty" script to multiple tabs in Google Sheets

I would like to apply this to let's say "Weekly" and "Monthly" tab. Here's my script: function sendAlertEmailWhenCellValueIsNotEmpty(){ //send an email alert when cellToWatch is not empty //set ...
1
vote
2answers
67 views

A Script that Allows a Checkbox to Recognise a Value via Formula and Copy to Another Cell

Is it possible for: a set of checkboxes to recognise lists (grouped in one cell) on entry (via formula) to then have the same checkboxes copy the list to another cell as it returns "TRUE" ...
0
votes
1answer
21 views

How to sort by merged cells in Google Sheet

I have been using this script for sorting and so I know it works. Now I'm trying to use it on a new Google Sheet project. Except that the column I want to sort the entire sheet by isn't just one ...
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'...
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 ...
-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
41 views

TimeStamp syntax to appear 24 Hrs Timestamp

I am using var TIMESTAMP_FORMAT = "yyyy-MM-dd hh:mm:ss a"; var TZ = "GMT-7"; in my script code of Google document I want it to be convert into 24 hrs timestamp What changes should I do ?
1
vote
1answer
127 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
3k views

Show/Hide Rows based on text in a cell

I'm trying to toggle which rows are shown/hidden on multiple sheets in my Google Sheets document. Simply put, a user will provide an input on Sheet1, which will populate a "show" or "hide" value in ...
0
votes
1answer
17 views

Google Spreadsheet Alert Scripts

Wanting to add an alert so if the information entered here if not all filled in as required it send you an alert. function Repair1() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var r ...
0
votes
1answer
30 views

Google Sheet Search Button

Sorry beginner and just starting to try Apps Script just for a few weeks. I'm create a form for my Inventory Tracker with few button 'Search', 'Clear Form', 'Save Data', 'Update Data' and 'Delete Data'...
0
votes
1answer
83 views

How best to handle a range moving between getValue and setValue?

I have a simple experiment to illustrate the issue: function testRangeAddressAfterSort() { var spreadSheet = SpreadsheetApp.getActiveSpreadsheet(); var testSheet = spreadSheet.getSheetByName("...
0
votes
1answer
19 views

Only the first thread is displayed in my Apps Scripts program, but I need all the threads

My issue is that the first thread in my inbox is being displayed 45 times which is the number of messages in my inbox. What I need is the for loop to go through all the threads and gather all the ...
5
votes
2answers
427 views

Odd Google Apps Script behavior

I have a Google Apps Script project that I have used for the past few months (successfully) and everything has worked just fine. A few weeks ago, I started getting the "Unable to load files" error ...
4
votes
2answers
2k views

Jump to bottom of spreadsheet, blank (non-formula) row

I had a tall spreadsheet that I need to add data at every time it opens. Answers like Go to Bottom Cell have been helpful, but my quirk is that the first column contains formulas that return blank in ...
5
votes
2answers
4k views

Copy range from specific values to top of another sheet

I want to copy everything from the range "Start" to "End" to the top row of another sheet (Sheet2). Sheet1: The data between "Start" to "End" can be any number of rows. This is my current code. It ...
0
votes
2answers
682 views

Auto Create New Google Sheet With Column Headers Based on List of Names

I'm trying to create a VERY basic CRM tool. I want to create a running list of customer names. Once I enter a name in Column A I'd like a new Sheet automatically created with pre-set columns I can ...
0
votes
1answer
255 views

3D Formula Google Sheets - sum across sheets

I'm trying to script an equivalent to Excel 3D formula into Google sheets. I have a workbook with numerous worksheets and a master sheet that should sum up the data. In excel I would have used this 3D ...
0
votes
1answer
570 views

How can I use a script across multiple pages of a Google Sheet

I'll start by saying I'm very new to this. Here's my problem. I have a GoogleSheet I created to use as a seating chart in my classes. It is designed so that when I click the blue check button the cell ...
0
votes
0answers
12 views

Comments in Google Sheets no longer connected to the correct cells [closed]

I work for a recovery center and we have a lot of collaborative sheets. We have a master discharge list that we have functioned to bring data over from another sheet as well as filter it by different ...
0
votes
1answer
2k views

Add file submitted to specific folder based on answer in google forms

I'm trying to create different subfolders for uploaded files based on the multiple choice question i have in one of my google forms. The form is for certain locations, so based on the location that ...
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
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
98 views

Trying to change sharing access of team drive files(more than 2,000 files) and generate link on google sheet via google script

I have a lot of files on a team/shared drive that I want to generate links of. I managed to do it, but I also want to make the links viewable by anyone with the link. When I added the script to change ...
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 ...
0
votes
1answer
58 views

If I set the school to "School A" then only School A's classes should be visible

I have created a progress tracker for the Academy Trust I work in. The trust at the moment consist of 4 schools. Students move between the schools as the progress and between classes during the year ...
0
votes
1answer
6k views

Google Sheets macro for printing

I wrote the next macro, but isn't working. For example: I have a button on the sheet (invoerblad) for printing, the button must print the sheet (Printblad), and when the print action is finished, it ...
0
votes
2answers
122 views

Trigger for onChange on add new row only

I want the trigger which work for 'add new row' only, but not other edit function. Right now the changeType of the onChange are Edit(include add new row), INSERT_ROW (but not add new row), etc., which ...

1
2 3 4 5
32