We work using Google Drive, Docs, etc. Background of the problem: One of our departments needs to print hundreds of emails to file away, with page information included. We currently have a Google...

I know this looks simple. In a Google spreadsheet, I have a column where I enter time in one timezone (GMT) And another column should automatically get time in another time zone (Pacific Time) G...

Is there a way to get the identification (i.e. A1 notation) of a selected cell or range in Google Sheets? Something like: =SELECTION(['Sheet1']) -> "D6"

I have a few Simple Custom Functions that I use all the time. I have recently run into a spreadsheet that I desperately need to use them in, but when I try to use even the most basic custom functio...

I'm trying to calculate the rate of change in Google finances' data. For example if price of AMD was 2 dollar and tomorrow it was 1 dollars, then the result I want is -0.5. I called the Google fina...

I have a code that converts range from the spreadsheet into a image and send it as a repot. It works well but the quality of the image is low. The PDF I am getting is in really good quality but the...

Suppose I want to color scale complete rows on the basis of values in a column (using Google Sheets inbuilt color scale option in the conditional formatting menu). How do I achieve this?

I have a simple script in Google Sheets which is trigger by a command in Slack and just adds the Slack message as a new row. It is quite a simple function and is deployed as a web app and does work...

I am trying to combine two codes that I found here: Google Sheet Range mail pdf Convert a gdoc into image I want to achieve something that will send an email with the inline picture of specific ran...

I have two Apps Script Code.gs and Code2.gs I would like to import function A in Code2.gs and use it in function B in Code.gs. Any ideas ?

I found the below code of @Tanaike which works for me perfect but I would like to add some parameters to exporting like size of the page or exporting in landscape etc. I know that I need to add par...

I created Browser.inputBox which accepts only a single text. However I need to make a drop down list where I can choose from the list instead of typing the string myself. A screenshot of the inpu...

I am trying to produce a "reverse pivot" function. I have searched long and hard for such a function, but cannot find one that is already out there. I have a summary table with anywhere u...

I am searching for the answer for a couple of months now. Any browser redirects to downloading the Google Sheets app, which doesn't have the script editor. Stack Overflow redirects to a question...

I'm looking for some assistance on find the row number for a cell that contains a specific value. The spreadsheet has lots of data across multiple rows & columns. I'm looping over the .getData...

I created in google sheets a custom menu linked to a custom function that pops up a dialog window with a youtube video in it. All this i did on my PC in a browser. I now installed google sheets o...

Situation: Example Spreadsheet Sheet: Support Column: H has the following function "=IF(D:D>0;IF($B$1>=$G:G;"Call";"In Time");" ")" that changes the value depending on the result. Problem:...

Problem: When I run the script, Google tells me, You do not have permission to call openById I had copied a script from another one of my Google spreadsheets and changed the target_ssKey vari...

I have a legacy database system (not web accessible) on a server which generates CSV or XLS reports to a Google Drive folder. Currently, I am manually opening those files in Drive web interface and...

The Google Spreadsheet looks like can only select one value in the dropdown list. Is there any way to select multiple values from a dropdown list in google spreadsheet?

Is it possible to create apps script using Dart and the Dart->JS translator? I'm guessing the answer is no, but I'd be interested in learning of any plans to integrate the two development environm...

I have this issue: I download a excell file, upload it (converting it to google spreadsheet format) and I have to adapt it to a structure with which I can use it with my scripts. To do that, I hav...

I am working with google forms via app script. I want to determine if the current form that is being submitted is in edit mode or a new response? How can I check this in the onSubmit event. If ye...

I want to be able to format and adjust the size of the rows programmatically when creating a report in Google Sheets so that I don't have the header stuck on one page and then content on the next w...

I already developed applicaton for google app script that can send email messages, but right now there is a need for me to send gtalk chat/xmpp message to user from my script. my question is, is it...