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
11 views

Sync dropdown cells and edit it

Sorry english is not my native language but I can't find anything to this topic and I hope you understand my writing/problem and can help me. I have a huge google sheet with many columns. But for this ...
0
votes
1answer
11 views

How do I code 3 series dependent drop down on multiple sheets?

I have a code to run a 3 tier dependent drop down list - it currently works for one sheet in my workbook named "BlankNode" but I need it to work for ~20 different sheets. I tried adding a ...
6
votes
3answers
12k views

Setting multiple protected ranges with one range value inputted

Id like to set protected ranges over several sheets and ranges of the same spreadsheet in a Google spreadsheet. The normal way to do a range is 'Sheet One'!A:L What id like to do is be able to ...
0
votes
1answer
55 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
15 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
413 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
1k 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
0answers
10 views

How to get columns added automatically every Monday with previous week dates [closed]

I want our team to update data for the previous week every Monday. it's getting difficult to add columns and dates every week, is there any possibility to get the columns added automatically with ...
0
votes
2answers
524 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 ...
1
vote
1answer
258 views

How do I run multiple onEdit functions in the same spreadsheet in Google Sheets?

all! I hope I can count on your expertise to help me with a project I'm working on. I want to call different functions based on which spreadsheet the event happened. Ex. Typing 1 in B6 on "Room ...
0
votes
1answer
15 views

Trying to run two functions onEdit

I have found two scripts that work independently, but fail when combined. I get this error message ReferenceError: myfunction2 is not defined onEdit @ Code.gs:3. I want one field to populate the ...
0
votes
1answer
68 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
501 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
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 ...
0
votes
1answer
80 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
57 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 ...
1
vote
2answers
4k views

Move cursor to cell in all sheets

I have the following script: function setActiveCells() { var wb = SpreadsheetApp.getActiveSpreadsheet(); var ws_names = wb.getRangeByName('an_sheets').getValues(); var ws_cells = wb....
0
votes
0answers
17 views

Want Google Drive to display the very page of pdf where the search word is located [closed]

I know Google drive can fetch and display the list of pdf files which includes the search word. However, it displays only files. I want to let it display the page where the search word is located ...
-1
votes
1answer
21 views

Trigger fails when executing sendEmails function

I created a script to send emails with calculated information from a sheet. The script works beautifully when run manually. I would like this to trigger every minute, but when I try to create any kind ...
6
votes
9answers
29k views

Importing data into a Google Forms response sheet

I have some Google Forms and would like to import legacy survey data into the responses spreadsheet, so as to benefit from the data presentation features (having the combined data set) but I've been ...
0
votes
1answer
97 views

Fine tuning a find and replace code

I have this code that works to find the word “Yes” and replace it with a 1. How do I also add in a line for it to find “No” and replace it with a 0? function fandr() { var ss=SpreadsheetApp....
1
vote
1answer
625 views

Linking multiple script created forms to 1 sheet in pre-existing spreadsheet

I work in manufacturing. I have created a Google form for our leadership safety audits which requires unique information (name(s), area being audited, and date) and also includes 25 multiple choice ...
0
votes
1answer
14 views

Adding Multiple timestamps, One with Checkbox

I am looking to add a second timestamp, connected to a checkbox. I currently have it set to put a timestamp in Column D when B is filled in. I would also like a timestamp in Column O when Column A ...
1
vote
1answer
131 views

ImportHTML Altering Data Format/URL Fetch Issue

4/17 6PM Update *** I am now trying to use the URL Fetch App. I've been playing with this for hours, but can't seem to figure out the issue. I am just trying to get the info from this site as plain ...
0
votes
1answer
608 views

How to extract a link URL from one word within a paragraph element in Google Docs with Google Apps Script

I'm trying to pull the URL of a hyperlinked word from within a paragraph element in a Google Document using Google Apps Script. Below are two GAS functions. The 1st doesn't work. The hyperlink is only ...
0
votes
1answer
48 views

How do you delete certain cells before copying?

I want to copy IDs and dates and have written this script so far. function copy(){ var s1=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); var s2=SpreadsheetApp....
-1
votes
1answer
19 views

Sort rows from highest to lower value problem

So i'm using a script that is sorting my rows from the lowest number to the highest but I want it to do upside down, gonna try to explain it better, the script now sort the rows like this And I want ...
9
votes
2answers
11k views

How can I automate Find & Replace to change font colours in Google Docs?

How can I automate a find & replace function to change the font colour of all suit symbols document wide? I write bridge articles (card game), and I need to automate this formatting constantly: ...
0
votes
0answers
14 views

When uploading a file on Google Forms, I would like the file uploads to go into a custom folder based on the form response (their name)

Ex. someone submitting the form with a file upload and on form submit it creates a custom folder based on their form response (their name) on google drive with their submission in it. Using this ...
2
votes
1answer
653 views

Add a new row to a spreadsheet, copying down formulas when a certain cell reaches a particular value

I've got a simple Google Sheet (it's literally one line), that has in A2 =now() to calculate the current time, and then a series of formulas calculating various dates/times based on the current date ...
0
votes
2answers
87 views

Duplicating sheets with simple date from a named range

When I run the script to duplicate sheets with a date is give the tab a long date name Thu Oct 18 2018 00:00:00 GMT-0400 (EDT). I would like it to read in a 10/18/18 format.
0
votes
1answer
14 views

Google Sheets sorting and lookup

I have a table like this : Now I would like to perform a column lookup on this where I give the Client(B) and get return value from Status(C) but the latest date from Date (A). I tried using vlookup ...
-1
votes
1answer
26 views

how to select and automate “copy by value” to persist data in Google Sheet

I would like to use Google Sheets as a form to query for data, select and store the data I'm interested in. Below what I'd like to try. Please let me know if feasible, and if so, could you tell how to?...
2
votes
1answer
4k views

How do I get Google forms edit url to work

I want to generate an edit url link in the google sheet for a google form which is linked to it. There are already instructions on how to do it. However they do not work for me. I have followed the ...
0
votes
0answers
11 views

Session maintain in the Google App Script [closed]

I need to maintain session in Google App Script for login user for atleast one hour, i have done login screen in the below attached link. When i refresh the page the user is automatically logged out,i ...
2
votes
1answer
117 views

Make function only work on first sheet, not in whole Google Sheets file

I have the following code which is for tracking the date of any edit made in a particular row. However, this code applies to the whole spreadsheet file, I would like to change this to be for the 1st ...
0
votes
2answers
29 views

Generate sequential numbers in first column based on value in other column

I'm having a problem implementing a spreadsheet with several sheets that use data registered continuously on the first. I found a solution with this script on the forum but I don't know how to edit, I'...
0
votes
1answer
455 views

Help needed with script that auto-updates cells in column in Google Spreadsheet showing last modify date

I'm looking for some help with a script for a spreadsheet. I found a script (see below) that does half the trick for me, but I encounter two difficulties. What I am trying to accomplish is the ...
1
vote
1answer
1k views

Script for GoogleSheets that inserts date, time, and user names of everyone entering text in a specified cell?

I wanted to ask for your help in building a script in Google spreadsheet that would allow users to respond to comments left by different users in the same cell (cell where the initial comment was ...
1
vote
1answer
2k views

Extract Google Calendar data to Google Sheets

I'd like to extract events from Google Calendar for a dynamic range: from (today) to (today+28), giving me a 29 day range of data. How can I specify that using Google Apps Script?
0
votes
2answers
71 views

Remember each user's last cell cursor location?

Is it possible to have Google Sheets remember each user's either last cursor location or last edited cell or preferably the value of the cell in Row2 that matches the current date? (In Row1 I have the ...
0
votes
1answer
314 views

Calculating Ranks in Google Sheets

I have a spreadsheet that has three tabs: The first tab is raw data imported from a website. it's about 10 columns and up to 300 rows. it has a mix of numbers in decimal form and percent. it all ...
-1
votes
2answers
27 views

ReferenceError: MONTH is not defined

Using the following Google Sheets script: var currentMonth = MONTH(TODAY); I receive the error ReferenceError: MONTH is not defined. Why is MONTH not defined?
1
vote
1answer
31 views

ReferenceError: CONCATENATE is not defined [duplicate]

I am receiving an error when manually running this function: function updateCells() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var spreadsheetSummary = ss.getSheetByName('Summary'); const ...
1
vote
1answer
43 views

Find and replace Google Script

I've read a lot of questions and I tried several Script for Google Sheets but nothing works for a very simple case: I would love to replace all the points "." with the commas "," ...
0
votes
1answer
36 views

How can I make some data on a Google Sheets auto-sorting but in different columns in every sheet?

If i want to sort different columns in every sheet, what do i have to change? function onEdit(event){ var sheet = SpreadsheetApp.getActiveSpreadsheet(); var editedCell = sheet.getActiveCell(); ...
-1
votes
1answer
92 views

Script sometimes it works sometimes it dosent

I have 2 columns to enter Lat and Long coordinates in ( E and F ), those also contain the Formulas (for all rows, I just happened to choose row 768below) =IFERROR("N"&left(index(Split(D768,"N"),1)...
2
votes
4answers
5k views

How to execute a trigger only when one of the sheets is changed

When I have multiple sheets in a spreadsheet, I want to execute a trigger only when One of the Sheets is changed, not the others. OnChange() or OnEdit() is executing the trigger for any data change. ...

1
2 3 4 5
30