Ask Question
Use this tag for questions about interacting with Google Sheets programmatically. Use with: [google-apps-script] for questions relating to inbuilt scripting language, [google-sheets-formula] for questions relating to formula design or [google-sheets-api] and the tag of language (eg:[python]) for questions relating to sheets api usage.
44,838 questions 1- Bountied 1
- Unanswered
- Frequent
- Score
- Unanswered (my tags)
Google Sheet Query Function - Combine 2 Steps together in Query
Pl. refer the Sheet shared below - Rank for diff. factors is calculated in Rank Sheet in Table A. ... google-sheets google-sheets-formula- 21
Reverse sort data in Google Sheet
Google Forms linked to Google Sheets record submissions oldest to newest. We must scroll to the bottom of the sheet for the newest submission. I'd like to reverse that behavior so the newest ... forms sorting google-sheets- 166
Using SUMIF/SUMIFS for a Column with both Numbers and Strings
I'm making somewhat of a bill tracker of my own in Google Sheets. This is snippet so far what I have. Google Sheet Example Image What I want to accomplish is on cell K2, you can see that if the cell ... google-sheets google-sheets-formula- 11
How to list non-empty cells when the adjacent cell is empty in google sheets?
Hellooo I need help ;'( How do you make the result such that the all values in the column beside the adjacent empty column be listed out like this? I dont mind if its coded inside the app script too. ... javascript google-sheets google-sheets-formula- 3
EXCEL: How to automatically create groups based on sum being less than X and not greater than Y
I have table in Excel with some information, the main column is Weight (in KG). I need Excel to group Rows into groups, where each group's sum of Weight (in KG) is less than 24000 kg and greater than ... excel google-sheets excel-formula- 1
I need prevent and alert users whenever their entry is a duplicate in google sheets
I'm managing a tracker in google sheets, where users should enter new IDs in column A. I need to prevent them, as well as alert them, whenever their entry is a duplicate (so the ID already exists in ... google-apps-script google-sheets google-sheets-formula- 1
Data import for drop down menu scripts
I gone through the formula... =IMPORTHTML("","Table",1) but failed to get any output saying formula parse error.When I'm going to ... google-sheets google-sheets-formula- 33
Google Sheet Lock Data On closure of Sheet
I want to design an app script for Google Sheets which protects the data upto last row when the sheet is closed. E.g. If I am working on the sheet and data is till Row No. 100 then, when I close the ... google-apps-script google-sheets- 55
Google Spreadsheet Arrayformula with IF and AND condition
I need some help with google spreadsheet. I tried everything but somehow I am not able to figure out how to solve this. I have 5 columns, 4 of them are "Blue, Yellow, Green and White" and ... google-sheets- 1
I want few reference material related to how to log sensor value to a google sheet using lua language
i want to upload mt sensor values to google sheet i am using nodemcu so I have to code it with language lua google-sheets lua iot nodemcu esplorer- 3
Google spreadsheet Query function parse error on 1 column
I have a query to fetch data from another sheet. One of the columns contains Yes/No in most rows. I have made the format of the column text but the query will not parse this column. If I omit the ... google-sheets- 1
Get Unique Value Based on Multiple Columns from Spreadsheet using Google Apps Script and JavaScript
So, Basically what I want is to get unique data from a 2d array where I can pass multiple column values which I have stored in an array. Like I want to get unique based on column 1 and 2 so, I can ... javascript arrays google-apps-script google-sheets multidimensional-array- 13
Is there a better way to email a range on Sheets?
Here's what I have so far and it functions perfectly. The thing I'm having trouble with is that this is the only way to have the range email to Outlook with each cell in the column on a new line. If I ... email google-apps-script google-sheets- 15
Getting specific strings from cell in google sheet
I have a cell that i'm trying to get info out of. This is the value of the cell C7 "(Liverpool-CAM) Firstname 'Nickname' Lastname" =IFERROR(REGEXEXTRACT(C7,"\'(.*?)\'")) My ... arrays regex google-sheets replace re2- 31
Export users and permissions of all google analytics properties with Apps script
I would like to be able to automate with script apps to extract from each property that I have the users and the permissions they have regarding the property, administrator, editor, reader, etc... I ... google-apps-script google-sheets google-analytics google-analytics-api google-analytics-4- 1
15 30 50 per page12345…2990 Next
