Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
429
questions with no upvoted or accepted answers
6
votes
2
answers
633
views
Unable to operate script in my work computer and home computer, on other computers it works fine
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 ...
- 226
6
votes
3
answers
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 ...
- 161
5
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 ...
- 51
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 ...
4
votes
0
answers
168
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 ...
- 41
4
votes
0
answers
663
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,...
- 1,110
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 ...
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 ...
- 41
3
votes
2
answers
5k
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 ...
- 31
3
votes
1
answer
160
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 ...
- 31
3
votes
1
answer
2k
views
Reference Cells in Sorted Filter View
I have a Google Sheet that looks like this:
That Google Sheet has some Google Script that looks like Google This:
function myFunction() {
var ss = SpreadsheetApp.getActiveSheet();
var rng = ss....
- 353
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 ...
- 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, ...
- 31
2
votes
0
answers
88
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 ...
- 179
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 ...
- 43
2
votes
1
answer
71
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 ...
- 21
2
votes
1
answer
432
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 ...
- 143
2
votes
0
answers
330
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 ...
- 250
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 ...
2
votes
1
answer
380
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. ...
- 21
2
votes
1
answer
1k
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 ...
- 21
2
votes
0
answers
64
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' ...
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 ...
- 21
2
votes
1
answer
111
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 "," ...
2
votes
2
answers
644
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"
...
- 33
2
votes
0
answers
357
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 ...
- 120
2
votes
1
answer
429
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 ...
- 120
2
votes
1
answer
481
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 ...
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 ...
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 ...
- 21
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 ...
- 21
2
votes
1
answer
101
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 =...
- 21
2
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, ...
- 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 ...
- 21
2
votes
1
answer
385
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 ...
- 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 ...
- 21
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 ...
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. ...
- 21
2
votes
0
answers
593
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 ...
2
votes
1
answer
854
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 ...
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 = ...
- 145
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 ...
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 ...
- 3,051
2
votes
1
answer
708
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 ...
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 ...
- 21
2
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 ...
- 21
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 ...
- 21
2
votes
0
answers
629
views
Chart in Google Sheets is duplicating data labels
I'm using Google Sheets and a triggered Apps Script function to create a waterfall chart. Basically this involves breaking apart each value into a base (either visible or invisible), a falling value (...
- 141
2
votes
1
answer
1k
views
How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?
I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
- 29
2
votes
2
answers
666
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 ...
