Top "Google-sheets" questions

Set border color & style in spreadsheet programmatically

Google Spreadsheet has in the toolbar under the border button also a button to change the color and change the …

colors google-apps-script border google-sheets

TEXTJOIN only when the condition is met?

I tried using TextJoin function with IF in it, but it somehow doesn't seem to work. I think I've written …

if-statement google-sheets textjoin

Google finance 200 day moving average is getting as #NA in Apps Script

I'm calculating Google finance 200 day moving average formula in google sheet using formula =average(query(sort(GoogleFinance("GOOG","price", TODAY()…

google-apps-script google-sheets google-finance

How do you count cells with a certain partial string?

I have cells with dates that are formatted in different ways (and too messy to re-format, also lots of data) …

string google-sheets count wildcard google-sheets-formula

Google Sheets API: How to find a row by value and update it's content

I am working on an Android application that uses a Google Spreadsheet as a database. The application should GET, APPEND …

android google-sheets google-api google-sheets-api

How can I share my app script, between google spreadsheets?

I have a corporate google account (with a domain) and I've created a script to access a database, to share …

google-apps-script google-sheets google-workspace google-apps-script-addon

Create spreadsheet using Google Spreadsheets API in Google Drive

I have successfully created a new worksheet in an existing spreadsheet of My Google Drive account through a simple Java …

java google-sheets google-sheets-api google-docs-api

How do you create a "reverse pivot" in Google Sheets?

I am trying to produce a "reverse pivot" function. I have searched long and hard for such a function, but …

google-apps-script google-sheets pivot-table unpivot

Is there a way to retrieve Google Map Longitude & Latitude from Addresses in Spreadsheet?

I am currently working with a data listing and one of my columns of data is an address of the …

google-maps google-maps-api-3 latitude-longitude google-sheets geotagging

In Google Sheets, How do I find the row number of a cell with certain text in it?

In Google Sheets, What do I do if I want a cell to display the row number in which a …

google-sheets formulas google-sheets-query