Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

0
votes
0answers
50 views

A Google Sheets Macro to Sort all Sheets by value in D4

I have dates that are entered in D4, across 10+ sheets in the file, and it would be great to have Google sheets auto sort all sheets upon onOpen by the oldest date. It might also be helpful to simply ...
0
votes
0answers
26 views

Auto date insert when opposite cell is populated on protected cell

I tried this code for automatic inserting date and it works but it doesn't work when cell is protected. I need a solution. Thanks. //------------------------------------------------------------ //...
0
votes
1answer
183 views

Data Validation Selection Modifies Conditional Formatting While Preserving Functions

Here is a copy of the document I'm working on: https://docs.google.com/spreadsheets/d/1amIjjQsA8sNKf7mZvE1GjsF-377YOWxVIRk6HRgQjfA/edit?usp=sharing I'd like the drop down menu (in purple--D3-L3) to ...
-1
votes
1answer
42 views

Imporxml is not price the data getting syntax error

importxml is working fine with manual insert but while updating with funtions getting syntax error. Kindly help me.. how to convert string to actual query. function Getdata() { var Technicals = ...
0
votes
1answer
1k views

How to run script on multiple Google Sheet tabs

Here's my code function saveRange(){ var ss=SpreadsheetApp.getActiveSpreadsheet(); var sheet=ss.getSheetByName('Sample_tab_1'); var range=sheet.getRange('A8:AE47').getValues(); sheet....
0
votes
1answer
216 views

Why doesn't this script populate sheet after parsing data from CSV file?

I got the below script which seems to work from time to time. It runs with no bugs reported, but it doesn't populate the sheet it is supposed to: function importCSVFromWeb(url) { // Provide the ...
0
votes
1answer
271 views

Get row and column of MAX(range)

I'm trying get the row and column numbers of a cell determined by =MAX(range). In the example above, =MAX(range) will return .02%. My first challenge is to get the row and column numbers of .02%. ...
1
vote
0answers
95 views

IMPORTHTML result is not updating [duplicate]

function Getdata() { var sheetName = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Main"); var Technicals = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Techinical"); var ...
0
votes
0answers
44 views

custom trigger not creating google sheets

The purpose of creating trigger to run everyday from 11 AM to 10:00 PM on every 5 minutes. the below script is running fine but not creating triggers. Please help me function createTimeBasedTrigger(...
0
votes
1answer
117 views

Script to Pull Data from Daily Data Sheets to One Summary Sheet Within the Same Workbook

Here is a copy of the document I'm working on: https://docs.google.com/spreadsheets/d/1amIjjQsA8sNKf7mZvE1GjsF-377YOWxVIRk6HRgQjfA/edit?usp=sharing Every day we (my non-profit school) duplicate the ...
0
votes
0answers
43 views

Prompt only working when running from editor

I'm trying to get a prompt to appear whenever a specific column is edited. Currently the prompt will only appear when I edit the column of interest, then run the script from the editor. It does not ...
2
votes
2answers
749 views

Automatically create link when pasting URL in Google Docs

Long story short, I regularly paste batches of hyperlinks into Google Docs. When they're copied, they're unlinked and purely raw text. When pasting it into Google Docs however, those links (...
0
votes
1answer
58 views

Importhtml data alert on new row updated

I am fetching data from ndtv profit, I would like to get an alert for any new row updated in the table. I have 'send mail' functions. which the event funtion needs to use to get the data on increase ...
1
vote
2answers
457 views

Share Google Sheets Anonymously

Is there a way to share Google Sheets(programmatically or otherwise) without revealing the Owner's name/Email address to the public/link receivers?
-3
votes
1answer
44 views

send mail from google sheet with given range content in simple html format to single email id— kindly help me

. I have developed the sheet with some condition the email should be lite then only it will deliver to me in short period based on the technical details will take desition on my trade. I have ...
0
votes
0answers
53 views

Run a script in Google Sheets Mobile

I have created a script for a rather simple spreadsheet that is tracking PO's for a small company. A couple different people have been granted permission to issue them, but these people are very ...
0
votes
1answer
172 views

Filling Google Form through Google Sheet

I have a database of name, phone number, address. And I have 3 questions in the form: name phone number address If someone filled his name, I want the form to auto-answer his phone number and ...
1
vote
1answer
204 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
70 views

How can you conditionally swap out a dropdown on a range of cells in Google Sheets?

I'm trying to work on a sheet that allows me to switch between a true/false value and based on that result it toggles between 2 different dropdown options in another cell. Desired Result Cell C2 ...
0
votes
0answers
83 views

How to find the last cell in a range in App Script

Here is what I have: // custom menu function function onOpen() { var ui = SpreadsheetApp.getUi(); ui.createMenu('Scripts') .addItem('Save Data','saveData') .addToUi(); } // ...
0
votes
0answers
806 views

Google App script delete specific range of column is blank

I'm currently working on a script that should do the following: Look at column G5 until G23 if one of those cells in that range is empty it should delete the content of that specific range of row. ...
0
votes
0answers
33 views

Is it possible to set a formula in google spreadsheet with two variables?

I want to set a formula to calculate an equation like Y=X+5 where Y is an calculated constant value generated by another formula depending on X. is there any solution.
0
votes
1answer
33 views

Script to call the sheets sharable link

Is there a script for google sheets that calls the sharable link of that specific sheets? I'm using the Mailapp.sendEmail function to send emails to our manufacturer whenever there is a revision to a ...
-2
votes
1answer
20 views

How could I declare my variable C58?

I made a document for work supposed to help my everyday life. It is working Ok but I would like to add some extra features BUT I don't know much about Google scripts. I searched on google docs help ...
0
votes
0answers
21 views

Add one user to all protected ranges in all sheets at once?

Is there a way/script to add one user to all protected ranges at once? Maybe through a script? Tedious as we have loads of workbooks with loads of sheets and I am required to enter one by one to add ...
3
votes
0answers
2k views

Set title of currently selected chart from named cell

There's a sample over here that will show how to set the first's chart title to the active cell: function onOpen(){ SpreadsheetApp.getUi().createMenu('Charts').addItem('Update title of the first ...
1
vote
1answer
2k views

Loop through all sheets, except for specific sheet names

I found the following code and want to use it to loop through all the sheets expect a few (that I don't want it to go through). My question is how can I edit this code in such a way that It does not ...
0
votes
0answers
50 views

Copying and Compiling Data Over Multiple Tabs

I am attempting to set up a method of copying data from multiple tabs in a Google spreadsheet. My spreadsheet is split up into a few separate item lists with each item having corresponding quantities....
0
votes
0answers
51 views

Time Stamp Every Last Date Each ROW is Updated [duplicate]

I've looked at other questions on this and I don't think this specific question has been asked. Is there any way to have a column, let's say column B, that could show the last date that particular ...
0
votes
0answers
75 views

Unable to collect email address

The script is unable to extract emails get body /get plain body. Can any one guide? function getEmails() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var labels = GmailApp.getUserLabels(), ...
4
votes
1answer
231 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 ...
0
votes
0answers
323 views

Google Sheets split multi-cell into new rows

My question is about merging multi-line cells into separate rows from a Google Forms responses doc. It looks like this question has been asked & answered, however, I have spent several hours over ...
1
vote
1answer
305 views

Google script to delete on condition

I'm trying to fix a script for a Google Spreadsheet, https://docs.google.com/spreadsheets/d/1J3VRBXkx5B3p1fmrVpkI3Y6F5EGns9Vao7FyxOQsSVo/edit?usp=sharing I wrote to following: function ...
0
votes
0answers
36 views

Two Timestamps in diffrent cells to update seperately when data is put into a cell

I am trying to get two separate timestamps to fix to two different cells when data is put into a separate column. E.g If i enter a number in B3 i get a timestamp in D3 I also enter a number in C3 and ...
0
votes
1answer
291 views

Steam Webapi & Hours played for a specific game - Google Sheets

So I have managed to get a list of owned games and total hours in each game with =importJson. The only issue is I only want data for one game. The json query returns all owned games. The api wiki says ...
0
votes
1answer
14 views

Can I eliminate redundent totals in google pivot tables?

Given the general difficulty of doing much with google pivot table, I expect the answer to be "No". In the snippet below I would like to keep lines with the totals in green shading and not see the ...
0
votes
0answers
325 views

Copy-Paste values to the bottom of a list every day

Let's say I have some rows of data that I have to backup every day. The amount of data can vary, if there is no data for a row, that row shows as empty. The area of possible data starts at row 8, and ...
0
votes
0answers
203 views

split multiple columns containing multi-line cell into new rows (+ duplicate surrounding row entries)

This is in addition to the question answered in an earlier post named Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries). The following code worked for me fine ...
0
votes
0answers
430 views

Insert timestamp and last changed timestamp in a Google Sheet

I've been trying to make these two functions to a Google Sheet; If any value in row C, then inject creation timestamp in ROW A (code 1) If any value from ROW D and further, then inject last modified ...
0
votes
2answers
48 views

Issues with a counter

I'm trying to create a button in Google sheets which, when pressed, imports a sheet from a separate spreadsheet into the current one and gives it a name of 'Miscellaneous' followed by the number 1 ...
2
votes
1answer
442 views

Using script to change the look of built-in paragraph styles in Google docs

I need to edit the look of the styles in Google docs. I'm using script to insert text into a blank document. Before I insert the text I define the look of new styles like this: var vedlegget = {}; ...
3
votes
1answer
590 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 ...
0
votes
0answers
121 views

Insert row in Google Sheets depending on cell value

I'd like to write a script to insert a row depending on a date value, but I'm having a tough time. The date is shown below. If the date in Col I changes, I'd like to insert a row above with some text ...
0
votes
0answers
652 views

Move row across different sheets based on value in specific column

I have this code that works to move a row of data to another sheet within the same spreadsheet when a certain answer is selected from a list of items in a specific column. function onEdit(e) { ...
2
votes
2answers
698 views

How do I get a script to cause an edit-based trigger?

I have a Google Sheets script that automatically edits a cell in my sheet with a timed trigger, and I would like a second part of the script to run once that edit is automatically made. However, the ...
0
votes
0answers
58 views

Creating scripts to add new columns and to pull data to another sheet

I am trying to make a delivery schedule for my work, my current one looks like this: I would like to create a script so that when I click a button, a new column is created next to the column furthest ...
1
vote
1answer
272 views

Script to display workbook title in Google Sheet

I read on here how to use the script =sheetName() to display the sheet name, but is there another script I can use to display the workbook title? I use daily sheets and the title for the sheets are ...
2
votes
1answer
576 views

Move row to different sheet based on answer in specific column

I have a Google Sheet the has 5 tabs (Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5). I am wanting to be able to automatically (on edit) move a single row of data based on the answer chosen from a list ...
1
vote
1answer
814 views

Conditional Google form email notification on submit

I have a script container-bound to a Google form with which I'm trying to send email notifications to departments in certain towns within my organization when a new response is submitted. The town is ...
0
votes
0answers
273 views

Convert hh:mm to mm:ss on entry

I would like to input time durations of minutes and seconds quickly (without needing to include an hours value). I have come to the conclusion the most convenient way to do this is to have a script ...