Skip to main content

Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

414 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6 votes
3 answers
7k views

Why would I be getting the error: Too many simultaneous invocations: Spreadsheets on a simple once a day trigger?

I've searched around and still can't find anything directly related to the failure message I'm receiving. The script hasn't changed and it used to run just fine, but now in the past week or so it's ...
Micah Kuiper's user avatar
4 votes
0 answers
1k views

How to check if there is any Data Validation error in the whole spreadsheet?

Is there a way to check in a Google Sheets spreadsheet, if there is at least one cell violating a Data Validation rule? If such functionality is not built-into the app, how can I write a Google Apps ...
Federico DTales's user avatar
4 votes
0 answers
171 views

How to automatically convert all Microsoft Office file attachments in Gmail to Google Docs?

My Gmail has thousands of emails. Each email will have several attachments as Microsoft Office files (.doc, .docx, .xls, .xlsx, .ppt, .pptx). Currently, I want to automatically convert all Microsoft ...
fuongtd's user avatar
  • 41
4 votes
0 answers
789 views

Numbered list with Cyrillic letters

In Google Docs, I would like to have a numbered list using Cyrillic letters, such as: а б в г д The regular choices for numbered lists offer the options of Arabic numerals, Latin lowercase,...
gerrit's user avatar
  • 1,130
4 votes
1 answer
1k views

How can I create a Google Spreadsheets whose name and cells auto-complete with cells completed on another sheet?

I'm using Google Spreadsheets to manage projects, and I'm not familiar with scripts or macros. What is: 1) I have a Gantt spreadsheet which lists all the ongoing and foreseen project as follows (by ...
Phil's user avatar
  • 41
4 votes
2 answers
1k views

How to Modify Matched Cells Across Multiple Sheets with Google Script

My question is a fairly complex one, but I'll do my best to clarify exactly what I'd like to do and this requires some background: I have a Google Spreadsheet used for user administration in my ...
Mattoverton20's user avatar
3 votes
1 answer
412 views

Apply custom formula across all columns using Array Formula

I have trouble applying my custom formula across all columns using Array Formula. My custom formula is named getCountry where it could get the country based on an address. The address components e.g. ...
Carmad94's user avatar
3 votes
1 answer
2k views

Writing a macro to create a new tab and name that tab based on a cell value in Google Sheets

I would like to have a Macro that generates a new tab and names that tab based on a cell value. There is a tab called 'Dashboard'! on which the user enters information in assigned cells. Afterwards, ...
Othello's user avatar
  • 31
3 votes
2 answers
6k 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 ...
Jamil's user avatar
  • 31
3 votes
1 answer
169 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 ...
Tamarissa's user avatar
3 votes
1 answer
2k views

Any way to separately Validate and create a Dropdowns in Google Sheets?

Sample Scenario: Sheet 1 has a 3 Dropdowns from sheet 2 Sheet 2 has two lists, {"A";"B"}, and a second dynamic list that copies the first IF the value doesn't already appear on sheet 1 The behaviour ...
Void Singer's user avatar
3 votes
0 answers
6k views

Google sheets query returns "loading..."

I've put together a web application that relies on a series of Google components. Google Forms collects data from users Google sheets saves the data (automatically) Additional "calculated" columns ...
grayob's user avatar
  • 229
3 votes
1 answer
2k views

Simultaneously sort multiple ranges on a single sheet in varying orders

I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, ...
Max's user avatar
  • 31
2 votes
1 answer
564 views

function no longer working on mobile

I have a function that uses the onEdit trigger. It was working great both on PC and mobile yesterday, but today it no longer works on mobile but still functions on my PC. Not sure what is going on. ...
Chris Mcghee's user avatar
2 votes
0 answers
109 views

Is it possible to make clickable links using Logger.log?

Is it possible to make clickable links using Logger.log? I have this code that log url Logger.log(url); that logs text in console. I wonder if this is possible to make that url clickable by using ...
user2926340's user avatar
2 votes
1 answer
197 views

Google Sheets - Button link to script with a range input

Is there a way to write a script, assign it to a button, and press the button to execute the script AFTER selection a cell range that serves as an input parameter to the script in question?
Jeff's user avatar
  • 21
2 votes
0 answers
1k views

Google Sheets / Maps - Exception: Service invoked too many times for one day

I have the following script in my Google spreadsheet to calculate the distance in miles and time driving between two addresses. It works perfect until I get an error "Exception: Service invoked ...
Joe Wright's user avatar
2 votes
1 answer
78 views

can you track how long a cell has been the same in google sheets?

I am making a filtered list of trade proposals in this google sheet. I would like to remove those that have been put online in the last 5-10 minutes and only show older ones. I would like to avoid ...
Postlim Fort's user avatar
2 votes
1 answer
637 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 ...
spcsLrg's user avatar
  • 143
2 votes
0 answers
439 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 ...
user345394's user avatar
2 votes
2 answers
1k views

Delete rows in Google Sheet after 30 days

I have a Google Form that populates a Google Sheet with rider registrations for a local cycling club. The sheet has a filter in place to display only the riders for the current day. This filter ...
Paul Taverner's user avatar
2 votes
1 answer
686 views

How can you use a Gmail script to attach more than one image at a time?

I'm trying to set up a Google Sheet with some data to email images. I have the code I found online working below to send a single image attachment but I would like to send more than one image at a ...
Brett's user avatar
  • 21
2 votes
1 answer
1k 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'...
Mike Wielgus's user avatar
2 votes
1 answer
2k 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 ...
Mady's user avatar
  • 21
2 votes
0 answers
76 views

Content control or invisible placeholders

Related to this question dated 5 years ago and where it is stated that "Google Docs doesn't have invisible placeholders at this time, but it has bookmarks." MS Word has 'content controls' ...
Mark Grimshaw-Aagaard's user avatar
2 votes
1 answer
33 views

Function to create a calendar for one year with gaps (date and days in separate cells)

Is it possible to have a function within a Google Docs spreadsheet which I can link to a button which will create a calendar in the following format: Number will be 1 - 365 for the days Date will be ...
Simsphonx's user avatar
2 votes
0 answers
152 views

How to Use Google Sheets' Macro to Copy Data from Volatile (randbetween) Cell

What I would like to be able to do is execute a macro that copies the data from a cell with a randbetween formula, and pastes that data (copy/paste values only) into another cell. When I attempt this ...
Abyssal Spark's user avatar
2 votes
2 answers
671 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" ...
Stephanie's user avatar
2 votes
1 answer
39 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 ...
dkay's user avatar
  • 21
2 votes
1 answer
166 views

Google Sheet Script for automatically entering date/time stamp when the adjacent column

I've found a script on here for entering a timestamp in a column based on edits to the adjacent column: Date and time stamp automatically added in column if(e.source.getActiveSheet().getName() == &...
Alan's user avatar
  • 21
2 votes
0 answers
423 views

How to Group Set of Rows & Skip One Every Time

I'm currently working in a Google Sheet that has about 12,000 rows. Because of the layout, I want to group every 5 rows, then skip one, then group the next 5. Right now, I have as script that is ...
Anthony Madle's user avatar
2 votes
1 answer
549 views

How do I copy data from multiple Google sheets and paste into master Google sheet while maintaining format?

Each day I paste assignments to employees in each employees respective sheet. These assignments have hyperlinks in portions of the data. At the end of each day I copy their assignments for that day ...
Garrett Boulware's user avatar
2 votes
1 answer
1k views

Auto sorting by multiple columns in Google Sheets

I have a data-set which I would like to have sorted with first column 6 and then column 7. From this post: How can I make some data on a Google Sheets auto-sorting? I have gotten ideas about making a ...
Jesper Homann 's user avatar
2 votes
1 answer
1k views

Importing data into Google Form response sheet with date, list, grid

I have a normal Google Form that is filling answers into a response spreadsheet but I want to import pre-existing data stored on another Google Sheet (100 entries) that match the Google Form responses ...
Taylor Lewis's user avatar
2 votes
0 answers
81 views

IMPORTRANGE, where range shifts often, to different spreadsheet

What I have: a client information spreadsheet that contains company information including their last order date following the status of their account (active/follow-up). What I need: the last order ...
lily.v.n.'s user avatar
2 votes
1 answer
107 views

Reference formulas from one sheet into multiple sheets

I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced. For example, if I have =...
Rwhite118's user avatar
2 votes
2 answers
52 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 ...
Erin's user avatar
  • 21
2 votes
1 answer
4k views

Need to get a list of Drive files several subfolders deep

I need to get a list of all the files in my Drive with all of the nested folder names where the files reside. I found this very helpful answer which is almost exactly what I need: Get a list of Drive ...
Rick's user avatar
  • 21
2 votes
1 answer
400 views

Google Forms sending me duplicate email on automatical email

So, I've used this code, just reworked for my needs: Can Google Forms send emails automatically? The problem I have is that the account that sends those emails also receives them. Is there a way to ...
Jarek N's user avatar
  • 21
2 votes
1 answer
1k views

Run a Script When Tab Programmatically added to a Google Spreadsheet

I'm trying to pull data from an Adwords report to a Google Sheet through an Adwords script. This will be done on a daily basis. Every time the Adwords script runs, a new tab is created (and an old one ...
Sanket Dhume's user avatar
2 votes
1 answer
278 views

Send email notification when a data in column matches a certain value

I am trying to make Google Sheets send a notification to a particular person/s when one of the fields on column Q is equal to the word "High". I want the email to be sent when it is high ...
Glynn Jones's user avatar
2 votes
2 answers
1k views

Jump to today's date when opened

I have found a similar question here: How to make Google Sheet jump to today's column when opened? I want to do a similar thing, but I have the dates in row 5 not in the column. I tried several ...
Carlo Della Schiava's user avatar
2 votes
0 answers
3k views

Change tab color based on cell value that is a formula OR cell background color

1st time question asker, so I'm apologizing in advance if my question is worded wrong or doesn't make sense or is, frankly, to wordy (I tend to over explain). I have a sheet with, currently, 10 tabs. ...
Jason Weiss's user avatar
2 votes
0 answers
620 views

How to pass a parameter allow= “geolocation” when embedding Google Apps Script in a Google site?

The target is to embed a Google Apps Script gadget into my Google site. The function of this script is to show a google map, determin the location of the client and center the map to the found ...
Peter Mattheisen's user avatar
2 votes
1 answer
855 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 ...
HR DataReporting's user avatar
2 votes
1 answer
4k views

Update Cell If another cell is not empty

There are two columns N and O. When any cell in column N is filled the adjoining cell in column O needs to filled with "Yes" if not it stays empty. This is the script I'm using. var s = ...
user2240778's user avatar
2 votes
1 answer
2k views

How to automatically forward Gmail messages when a label is applied?

I have found this question that is answered: How can I automatically forward Gmail emails when a label is applied? However I'm using that exact script and have replaced the label and recipient with ...
Robert Greenstreet's user avatar
2 votes
1 answer
1k views

How to send Google Form results to a particular sheet ("tab") of a Spreadsheet

Is there a way to create a Form that submits to a particular TAB of a Google Sheet? Use Case: We are using this for meeting pre-check-in. There's standard form. I'd like the results for each ...
Clay Nichols's user avatar
  • 3,111
2 votes
1 answer
1k views

Put the timestamp of last edit on master sheet, next to edited sheet's name

I'm trying to come up with a script that will print a timestamp of the last edit made to a specific tab within a google sheet. Imagine you have 17 retail stores, each one having its own tab with a set ...
Alex Farmer's user avatar
2 votes
1 answer
1k views

Email notification if cell value goes below set amount

I'm having trouble finding a Google sheet script that does what I need so I figured I would ask if someone could help me. Basically I have a simple sheet setup to track inventory of one item. There is ...
aggienick06's user avatar

1
2 3 4 5
9