Google App: Match order numbers between 2 Sheets and overwrite date column with updated dates
I have sheet1 with 17 columns of data. Order number in in Column H, date & time is in Column L. Sheet2 has 12 columns of data imported with importrange. Order Number is in Col K, Date & Time in in Col I (shown in script as Col L but would like to move it to Col I)
Exception: Those columns are out of bounds. – For-loops stops unexpected
I got this code implemented in a bigger function. Basically it searches for hidden columns to hide them in a new formed sheet that will be exported as a pdf. What happens is that at every hidden column above 30 it just stops, when columnHidden
is true
. Under that it just works fine.
Can’t get the data from Spreadsheet for Sending Email Notifications by Google App Script
I have a spreadsheet data containing Name, Start Contract, End Contract. I want to send email notifications to gmail if the End Contract ends within 1 month. I got the email but i can’t get the value of ValueA, ValueB, ValueC, and ValueH in email body.
What is triggering a Custom Function execution?
I have a function that is supposed to only run when called by a menu click
. But it is being executed many many times, and even without even clicking on the menu item
on the sheet itself.
What is triggering a Custom Function execution?
I have a function that is supposed to only run when called by a menu click
. But it is being executed many many times, and even without even clicking on the menu item
on the sheet itself.
Get the number of max values in a minute
I’d like to get the number of max values in a minute based on the data in my Sheets (this is my array of my Sheet above)
Changing a value in a cell without changing the active sheet [duplicate]
This question already has an answer here: Alter sheet within Google spreadsheet without making it active (1 answer) Closed last month. This is a very simple question but I’m not being able to do it in GoogleSheets. I want to execute an appscript that is able to read and write values in cells in different […]
Compare two cells and input timestamp in third if they do not match Google Apps Script
I have two lists that include IDs that I’d like to include a timestamp to a cell if the two columns don’t match. I am able to do this easily with a function, but I need something that will act as a trigger for another action and a formula solution won’t do that.
Problems with Google apps script in add-on. Running script/add-on on laptop works, running same script on Gmailapp (mobile) throws error
I have a function (addEmailsOfStudentsToBCC(e)) which fetches e-mail adresses from a Google sheet pending on the choices of the user on a formInput (select). If gets the e-mailadress of each selected student, pushes in a array and in the end the array gets pushed to the BCC of a draft e-mail.
How can I save the datas by name from 1 spreadsheet to another using apps script? [closed]
Closed 2 days ago.