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)

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.

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.

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.

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.

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)

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 […]

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.

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.

Closed 2 days ago.