Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
0
votes
0answers
3 views

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

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 ...
3
votes
2answers
13k views

Keep multiple sheets synchronised (both ways)

I need to have multiple Google Sheets be synced both ways. For example: I have a "master" sheet that has all of my information. And then I have multiple "filtered" sheets. Each filtered sheet only ...
5
votes
3answers
20k views

Menu option Insert -> Script... is missing in my Spreadsheet, how do I fix it?

I've two documents: in the first one I was able to add 'Script...' (as suggested here) from the Insert menu, but in the second one and all new which I'm creating I don't have this option present. Why ...
0
votes
0answers
12 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 ...
0
votes
1answer
859 views

Pull unique values from other sheets as new sheets keep getting added

I'm trying to get a unique list of values in a master sheet based on a list of values that appear in column A of other sheets. The tricky part is that every time a new column is added in the master ...
0
votes
2answers
2k views

How to Clear Cell(s) based on the Value of another Cell

I am looking for a script that will clear cell(s) when the value of another cell changes or is equal to ("X"). In the attachment I would like when Column "G" gets checked marked (TRUE), then ...
0
votes
1answer
12 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' ...
0
votes
1answer
37 views

Filter the data of two different column

I'm trying to filter down the data of two different columns. I have exported the Time Tracking Report from JIRA which consists of the following columns: Issue Type Key Status Priority Summary ...
1
vote
2answers
365 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 ...
0
votes
1answer
14 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 ...
0
votes
1answer
335 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 ...
-1
votes
1answer
26 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 ...
0
votes
1answer
103 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
29 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
225 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'...
1
vote
1answer
12 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 ...
29
votes
4answers
74k views

How to save temporary variables in Google Sheets formula?

I'm trying to create a formula in a Google spreadsheet which looks like this: if (x < 0, x + 1, x) It means if x is smaller than 0, return x + 1, else return x. However, x itself is an ...
0
votes
1answer
24 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
26 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
17 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 ...
0
votes
5answers
16k views

How to quickly re-arrange sheet order in Google Sheets?

If I have a Google Sheets document (Workbook in Excel terms) with 20 sheets (Worksheet in Excel terms) and I want to rearrange the order of the sheets currently the only way I know to do this is to ...
-1
votes
1answer
337 views

How to add 1 question in Google Forms which takes multiple inputs from the user and stores in a single column in Google sheets

I am struggling to create a custom question in Google forms which can ask the user for Multiple inputs or Short texts. For example If I ask a question to a shopkeeper: "Name all the vegetables ...
-1
votes
0answers
5 views

Old chat lost recovery options pls [closed]

Actually my old phone screen got broked so that. Am using another phone with same number but am afraid to say am unable to have my previous chat back in my other phone what to do any suggestions
0
votes
1answer
5 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 ...
0
votes
1answer
20 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 ...
0
votes
1answer
688 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
10 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 ...
0
votes
1answer
1k views

Embed an interactive calculator in my website using Google Sheets

I have implemented a calculator in a Google Sheet, and would like to embed it in my website. There will be multiple users. They should be able to enter numbers and see the result, perhaps with a chart,...
0
votes
1answer
388 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 ...
2
votes
1answer
61 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 &...
0
votes
1answer
41 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 ...
2
votes
1answer
112 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
35 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
35 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 ...
0
votes
1answer
25 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 ...
-2
votes
0answers
21 views

Have to get access to my database

Here is the I got: Error linking spreadsheets. Make sure you have access to the sheet you're trying to import from. Have can I have access to my DAtaBase spreadsheet. I am importing my contacts to my ...
0
votes
1answer
18 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 ...
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
133 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
24 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
2answers
22 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 ...
0
votes
1answer
18 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 + ...
40
votes
5answers
35k views

Cumulative Sum without Script

For this question, I've created a Google Apps Script function, that calculates the cumulative sum of a range. Martin Hawksey on Google+ made a comment about a more efficient way of calculating the ...
2
votes
2answers
3k views

google sheets sum of colored cells TypeError: Cannot read property 'pop' of null

I am using this gentlemans script: http://igoogledrive.blogspot.com/2015/11/google-spreadsheet-sum-of-colored-cells.html To sum up the value of only colored cells but I get an error message saying "...
1
vote
1answer
18k views

Cell last modified date & user stamp Google Sheets?

I want the cells of two columns in my Spreadsheet to auto-update with the date (m/d/y) and name of user when cells in a certain range are edited. For instance, Catherine goes to sheet on 3/6/2017 (...
0
votes
1answer
68 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 ?
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
20 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
38 views

How can I make this custom formula work with multiple columns?

I came across this script that is a custom formula: function result(range) { var splitCol = 1; // split on column B var output2 = []; for(var i=0, iLen=range.length; i<iLen; i++) { var s =...
0
votes
1answer
39 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'...

1
2 3 4 5
33