Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

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

A way to "lock" and "unlock" a Google Sheet's contents

How can I create a cell lock / unlock mechanic in Google Sheets similar to Excel? NOTE: I know how to protect a google sheet and limit editing permissions to certain users. There are many similar and/...
user avatar
  • 113
-1 votes
1 answer
17 views

Both importrange and script are failing to copy all records

I have a Google sheet which uses an importrange function and has worked for several years. for some reason, it has suddenly started to fail to copy a couple of rows in the middle of other data and is ...
user avatar
0 votes
1 answer
72 views

Sort sheet tabs name alphabetically

This is a script I located to sort my sheet tab names alphabetically. Is it safe for me to use in my free version of Google Sheets? function sortSheets () { var ss = SpreadsheetApp....
user avatar
0 votes
1 answer
99 views

Google Sheets App Script Sorting

I'm trying to have an auto sort function only impact one sheet in a workbook rather than all of them. I've done this in other projects and def messed this up along the way - any help is appreciated!! ...
user avatar
0 votes
0 answers
21 views

Is it possible to generate response url of google forms without editing permissions?

I know, that there is a getEditResponseUrl() function, but it generates URL with editing permission. Is there any way to have this URL without editing permission, just response?
user avatar
0 votes
1 answer
24 views

Error on multiple myfunction in onEdit

I am getting an error ReferenceError: options is not defined at myfunctionFDI(OverallScript.gs:39:48)at onEdit(OverallScript.gs:3:1), when I am trying to run multiple myfunctions within onEdit, what ...
user avatar
0 votes
1 answer
52 views

Automatically apply a formula and a when a new row gets added via a form API

Hi I have a wordpress form, linked to a google sheet that transfers over entries as they come in, now I have some formulas applied, but I don't want to have to add the formula to each new row that ...
user avatar
  • 3
0 votes
0 answers
60 views

How to make a macro in Google Sheets that runs when a cell changes value and then formats a range based on the value in the cell

I have some formulas that pulls out data for different graphs in Google Sheets. These data can either be in full numbers (e.g. Revenue) or in %. I have a dropdown for each graph where the user can ...
user avatar
0 votes
1 answer
76 views

Improve script performance

I wanted to ask, if I can do anymore improvements regarding my runtime, currently it takes roughly 100s to finish my script(since adding the formatting script below). Before adding additional ...
user avatar
  • 3
0 votes
1 answer
162 views

"#NUM!" error in Google Sheets Script

When trying to Run the following script the result is always a #NUM! error - (Result is not a number) in cell "O5" Both the cells are in currency format and I've tried changing them to ...
user avatar
1 vote
1 answer
44 views

Google Script Substract Function

I want to create a script function that I will use with daily triggers: function will subtract "Daily Fees" (a cell value that changes daily from "Open Trades" sheet) / from "...
user avatar
0 votes
1 answer
20 views

Can You Create A Google Site From An Existing Google Docs Folder?

I already have an extensive Google Drive "site" containing around 100 documents, which contain links to each other. Is there anyway to transfer these files to Google Sites, to at least seed ...
user avatar
0 votes
1 answer
16 views

I am trying to figure out how to change a column of many dates so that any date that is "less than" 1/1/2021 will automatically change to 1/1/2021

I have the conditional formatting set to change the color of the cell. But I need the actual value to change to 1/1/2021. But only if it's less than. If it's more than that, then I don't want it to ...
user avatar
  • 1
0 votes
1 answer
18 views

How to do an internal search in google apps script and not just with a specific link [closed]

I saw here How to Create Find and Replace Function for Google Drive File Names with Google Scripts how to change Name in Google Drive I want to know how to do an internal search (within folders) and ...
user avatar
0 votes
0 answers
136 views

How do I change textStyle of labels in radar chart?

I'm making a radar chart using Google Apps Script and I don't know how to change the font size of the "labels" (see the picture). So far I've tried hAxis, ticks, legend and none of them ...
user avatar
  • 3
0 votes
1 answer
1k views

Type error: cannot read property getid of null in google script

When I run this script it show me this error. I can't understand what I do. Its function is to transfer results from html form to Google Sheet. Can anyone solve this problem? var sheetName = 'Sheet1' ...
user avatar
0 votes
1 answer
201 views

Avoid keeping adding numbers in headings in Google Docs

I am using a modified version taken from this useful answer to get numbers in my Google Docs Header 2: function myFunction() { var pars = DocumentApp.getActiveDocument().getParagraphs(); var ...
user avatar
  • 103
1 vote
1 answer
40 views

Activating cell after button click (remove focus from the button)

I have a sheet with one button (a shape) which is associated with an Apps Script function. When I click the button it inserts a row and activates a cell in that row. Then if I try typing, nothing ...
user avatar
  • 1,388
0 votes
1 answer
30 views

Auto add a row based off a check box

I'm a new user to Sheets! I'm reaching out for help on a problem that I have with trying to create row. I've read a ton of blogs, and watched more Youtube videos than I care to admit without finding a ...
user avatar
  • 1
-1 votes
1 answer
92 views

Google Sheets clearing every other cell with a script

I have a sheet that have formulas on column B at every other Row starting from B3, so it's B3, B5 and up to B101, I have the following script to clear the rest of the sheet except for column B, How ...
user avatar
0 votes
1 answer
27 views

Need help editing Google Scripts for multiple sheets in workbook

I am attempting to use this script to choose multiple selections in 1 cell for data validation in google sheets. I cannot get the script to work on the 200+ sheets within the workbook. Is there a way ...
user avatar
  • 1
0 votes
1 answer
233 views

Apply simple script to specific tabs in a Google Sheet (I know zero code)

I would like to run the following script to all but the last tab in a Google Sheet: function ClearAll() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheetname = 'ScriptTest'; var ...
user avatar
2 votes
1 answer
460 views

How to pass multiple comma separated values in a cell to a custom function?

Suppose, there are values such as 1,A, 2,B, 3,D in certain cells. My intention is to add 1,2,3 (LHS) separately and A,B,D (RHS) separately. To achieve that, I have written certain custom function in &...
user avatar
  • 173
0 votes
1 answer
82 views

Exporting Google Sheet to PDF

I'm trying to export the current active Google Sheet to a PDF. The below nearly does what I want but I would like a few changes. Changes. Save the PDF in the same folder as the main spreadsheet ...
user avatar
0 votes
1 answer
47 views

Combining Separate Scripts into One

I've been trying to figure out a solution to this for a few weeks & I think I'm at the home stretch, but having some trouble piecing it together. With great help, I have a script (below) that ...
user avatar
-1 votes
1 answer
106 views

vlookup and paste in App Script?

Not sure if this is even possible, but would anyone know if theres a way of using app script to move cell data to a specified area. Sort of a reverse Vlookup? I want it to send a cell's data to an ...
user avatar
0 votes
1 answer
61 views

How to emulate behavior or cmd + down arrow in Google Sheets Macros?

If there is a column of 10 full cells in a row, and you go to the top of the column and hit command + down arrow, it activates the lowest non-empty cell. I tried to record a macro while using cmd + ...
user avatar
0 votes
1 answer
62 views

ImportHTML Script at Bulk

With great help, this script is working to pull in the 2nd table on the below link. The table cannot be scraped with IMPORTHTML unlike the first table (Regular Season works, Playoffs doesn't). https:/...
user avatar
0 votes
1 answer
47 views

Google Sheets Entries into Google Calendar in same date

I am trying to create full day event in google calendar using google sheet. I have used the following script and it is working fine with my sheet but it has added event in the previous date: // ...
user avatar
0 votes
2 answers
59 views

How does Google Slides identify "title slides"

When adding slide numbers to a Google Slides deck, there is an option to "skip title slides." When I choose this option, the numbers stay only on my title slides and disappear from my ...
user avatar
0 votes
1 answer
331 views

Google script to getValue AND keep formatting (not just text)

I'm writing a gmailApp script that looks at a spreadsheet and will send some emails out based on a sheet of names and emails. I'm trying to make it as user-friendly as possible. I'm aware I can use ...
user avatar
  • 107
0 votes
0 answers
35 views

Timestamp on change google sheets 3rd party data entry

i have been looking for a way to timestamp my google sheet, its working if i edit the cell and it work great exactly how i want it, however. im not the on editing the sheet, its through a 3rd party ...
user avatar
0 votes
1 answer
37 views

Clear cells script

So I have a google sheet document which houses figured for each hour of the day from 6 - 16:00 (each hour in a different tab. I’m looking to add a script and a button that will allow me to clear all ...
user avatar
0 votes
1 answer
28 views

How to identify specific data in a column in AppScript

I'm doing my first App Scripts and I'm able to have them working... but I remain dependant on some Sheets formulas to identify data. This impacts the speed of my script dramatically. As a basic ...
user avatar
0 votes
1 answer
26 views

Multiple functions updating datetime stamp in multiple cells [duplicate]

I am trying to update multiple cells based on input in each. The first works fine with a specific text from dropdown but I get no results on the other remaining 3. Here is the script I have: function ...
user avatar
0 votes
1 answer
52 views

Where it goes the paper size information in a script

I'm using this scrip to save to pdf but I need to make it Size A5 and Landscape Orientated I have found some parameters but I don't know how to combine function checkSheet() { var sheetName = "OS&...
user avatar
1 vote
1 answer
419 views

Check Google script quota usage in real time

I'd like to have stats on my quota usage for google scripts (those accessible from https://script.google.com/) Since there are a lot of quota enforcements (see https://developers.google.com/apps-...
user avatar
  • 257
0 votes
1 answer
31 views

Counting repetition with associated quantity

I would like to count the number of times my products are sold. I tried COUNTIF, but it does not take into account the quantity associated obviously. In the columns E G I I have the number of products ...
user avatar
  • 1
2 votes
1 answer
210 views

Gmail bulk Emails manipulation

I am trying to deal with 600,000+ emails in inbox, my goal is to either delete or archive emails before 1/1/2021. Doing a search and select all search results and then delete or archive as most people ...
user avatar
  • 21
0 votes
1 answer
47 views

How to run a function everyday at 11 PM?

Currently the function runs every day at 11pm but it runs twice. I'm only needing it to run once though. function functionsToRun () { appendValues(); clearCells(); addZeros(); } function ...
user avatar
  • 17
0 votes
0 answers
141 views

Convert input text into duration values with script on Google Sheets

I'm setting up a sheet to help coworkers keep track of their appointments. For now the only way to get those times is to copy-paste the numbers from a different program used to track the info. The ...
user avatar
  • 1
0 votes
1 answer
33 views

How to use / refer to a named range when defining another named range in a Google Apps Script?

I have the following script in a Google Sheet Apps Script macro. It is meant to identify & delete a range of rows on a sheet. This was created by originally recording a macro & then attempting ...
user avatar
0 votes
2 answers
273 views

Google Sheets - QUERY - SUM() based on empty column

I need to obtain the sum(B) if the column has empty values I want to reflect 0. I am automating this process for multiple sheets using app-script and need to use QUERY. Any suggestions?
user avatar
0 votes
1 answer
369 views

Calling MailApp.sendEmail from a time-triggered script fails due to insufficient permissions. How to fix this?

My sheet runs some calculations on a chart of numbers which updates automatically from a time-driven script. Within that script I put at its very end a function which compares two of the resulting ...
user avatar
  • 5
-1 votes
1 answer
35 views

Script to Automatically Email Every Morning

I have a Google Form which links to a Google Sheet "Form responses 3". Crew have to check in to our job sites each day and I want to write a script to automatically email our supervisors ...
user avatar
  • 1
0 votes
0 answers
236 views

Google Apps Script "Range not found" error

function _1() { var spreadsheet = SpreadsheetApp.getActive(); var numSheets = SpreadsheetApp.getActiveSpreadsheet().getSheets().length var s1 = numSheets-1 var s2 = numSheets-2 spreadsheet....
user avatar
  • 1
0 votes
0 answers
137 views

How to fix "Limit Exceeded: Email Total Attachments Size" with Google App script?

I've been running this amazing script (provided in full, below) with great success (thanks to user tedinoz!) but have recently been getting an error that reads "Exception: Limit Exceeded: Email ...
user avatar
0 votes
1 answer
928 views

Loop with dates "don't match the method signature for Utilities.formatDate"

My internet research was vain. Getting the range of dates & comparing them with today's date. After running the script #1 below I receive Exception: The parameters (String,String,String) don't ...
user avatar
  • 15
0 votes
1 answer
191 views

How to freeze Google Sheet columns based on date

I am using Google Sheets, and my columns are set up for each month (Jan, Feb, March, etc). I have several rows that are pulling data from other tabs in the sheet to create an at a glance master list. ...
user avatar
0 votes
2 answers
657 views

Preventing Google Sheets from refreshing a custom formula when opening the spreadsheet?

I'll begin with the specific question: Is it possible to stop function-containing cell from autorefreshing on open? Or perhaps is it possible to apply a function (which itself calls other functions ...
user avatar
  • 5

1 2
3
4 5
35