I am using SpreadsheetApp.getActiveRange().getValues(); to get the value of a range of cells, but it doesn't return the hyperlink associated with that cell, only the text. Is there any way to get t...

I would like to display easily an image on Gsheet cell based from URL of image stored in Gdrive. I have tried with the Gsheet function =IMAGE("URL") and it does not work. The objective is to disp...

I have a range of cells in one column, some contain text and some are blank cells. I want to search the range for the first occurrence of a word. I know that it's possible to combine Index and Matc...

I have a conditional formatting rule (color scale) applied to a row (e.g. A1:Z1). I want the to duplicate this rule for another row, but when I use Paste Special -> Paste Conditional Formatting ...

I'm using Google App Script for the first time. I'm using it on a Google Doc spreadsheet. I'm trying very simple functions, just to learn the basics. For example this works: function test_hello()...

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...

In google sheet I have 2 ranges of variable length with some data,i.e. column A: aa, ab, ac; and column B: ba, bb, bc. I would like to combine them in one long list in column C with a some form...

I have created a google sheet and have converted it into JSON using the URL. example: https://spreadsheets.google.com/feeds/list/SHEETID/od6/public/values?alt=json I want to add a api key to this g...

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...

I can't find any reference to an API that enables Rest API clients to export an existing Google Sheet to a csv file. https://developers.google.com/sheets/ I believe there should be a way to expor...

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 use GOOGLEFINANCE() to query the historical USD/GBP exchange rate at a set of fixed dates. This works fine, except sometimes GOOGLEFINANCE returns #N/A, for whatever temporary upstream reason. W...

Can someone help me figure out how Google Sheets' inbuilt Lambda function works? There is no official documentation for it and the only information available is as in the below snapshot. When usin...

How to use a formula to determine the current timezone? The formula I use gives an unexpected result. My spreadsheet settings (File > Spreadsheet settings...): Time zone: (GMT+01:00) Amsterdam ...

I'm having trouble stopping the googlefinance function on a specific date to use "that" specific exchange rate to convert currency from GBP to EUR. Here is my formulae: =Finance!B4*GOOGLEFINANCE("...

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 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'm looking for a way to convert standard UTC timestamps into a valid Date Time values of local timezone with daylight saving oscillation in mind. ...using this unnamed calendar app, that does not ...

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...

The following illustration should help:

I'm wondered if it's possible in google sheet to convert Gregorian calendar to jalali using a function. In fact, I have some date such as : February 20, 2021 4:30 AM I need to display this date in...

Is it possible to do an array formula with index match: e.g: =arrayformula(if(len(A3:A),INDEX('SheetB'!E:E,MATCH(A3:A,'SheetB'!H:H,0)))) If not, is there a solution that doesn't involve google...