Stack Overflow
Stack Overflow

Questions tagged [google-sheets]

Do NOT share spreadsheets/images as the only source of data. Use markdown TEXT tables instead. Use this tag for questions about programmatically interacting with Google Sheets. Use with: [google-apps-script] for questions relating to the built-in scripting language, [google-sheets-formula] for questions relating to formula design or [google-sheets-api] and a language tag (eg:[python]) for questions relating to sheets API usage. Do NOT use with [excel].

Google Sheets is a cloud-based application and service for creating and collaborating on spreadsheet documents. The service supports an internal API for Google Apps Script as well as an External API.

Sharing your data:

Sharing your data helps other community members in visualizing your data. This can be done through

  • Tables(Mandatory):
    Markdown help can be found here. You can easily create a table using the formula: =ARRAYFORMULA("|"&A1:G20), if you want to share A1:G20. However, the first row A1:G1 must be a header row AND the second row A2:G2 should only contain dashes -- in all the cells.

  • CSV:
    Use File > Export to csv

  • Published Google sheets(in addition to text table):
    In the sheets file, click File > Share > Publish to web.

  • Share to others(in addition to text table):
    In the sheets file, click File > Share to others > Anyone with link. Note, however that sharing Google sheets this way makes your email address visible to public.

  • Screenshots(in addition to text table):
    This shows your data structure but makes it hard for anyone to copy data from the question for testing

If questions depends on external links/images, they will be closed. Text tables is mandatory.

Related tags:

52687 questions
4
votes
3 answers

Finding the top 3 values and returning the column ID

Thank you beforehand for your kind response. Problem: I am trying to do a sheet to sort out the 3 top categories of a given range as shown by the attached screen grab. enter image description here I only managed to get the results by using the…
O'Neil Chung
  • 45
  • 3
4
votes
2 answers

FLATTEN skipping blank cells without using UNIQUE

I'm trying to turn an array into a single column without blank cells, considering that the input will always have some blank cells and that there might be repeated values. I'm trying to use FLATTEN but it keeps the blanks and UNIQUE would kill the…
aabujamra
  • 4,494
  • 13
  • 51
  • 101
4
votes
2 answers

google sheet : Conditional format to match error "#N/A" in a cell

We will see "#N/A" in the cell when we use formula that return error . i want to make a conditional format which will detect this error so if the cell contains #N/A then it will change the cell color. I tried to use 'Text is exactly' or 'equal to'…
andio
  • 1,574
  • 9
  • 26
  • 45
4
votes
2 answers

Using Data Validation in Google Sheets to only allow numbers, commas and spaces

I am creating an input google sheet to accept just numbers, commas & spaces - examples listed below. - At a basic level, I just want to exclude the use of A-Z / a-z. 80092382 800 800,876 98672102,20192210 I would like it to exclude anything…
Paul Marvell
  • 47
  • 7
4
votes
1 answer

Notification when data already exists in a Google Sheet

I am a beginner to app script. I am making a web app using Google app script to add resident's information to the google sheet. The web app to add residents but I should like the app to notify me if a record with the same house number and street…
Mathavan Krishnan
  • 149
  • 9
4
votes
1 answer

How To Copy Formulas Only In Google Sheets (without values or formatting) in few steps?

I've found a way to copy formulas only in Google Sheets through Search and Replace Ctrl + H feature workaround as follows: STEP 1: Cells with Formulas to be copied STEP 2: Press Ctrl + H and Tick Also search within formulas STEP 3: Copy Formulas…
Lod
  • 657
  • 1
  • 9
  • 30
4
votes
3 answers

Google Apps Script - Remove duplicates in large spreadsheets

Using the basic tutorial code from Google works fine for removing duplicates in GoogleSheets. However, since the maximum execution time is 6minutes, I'm running into timedout issues with larger spreadsheets that have thousands of rows. How would I…
Michael Hawk
  • 65
  • 1
  • 3
4
votes
1 answer

Using Google API Java Client for Uploading Database to Google Spreadsheet

I wanted to get some feedback before I jumped into this. I am interested in making my Android Application upload my SQLite database to Google Spreadsheet. I have gotten some mixed feedback from several people so I wanted to make sure I am going in…
gtdevel
  • 1,513
  • 6
  • 21
  • 38
4
votes
2 answers

Trying to Extract the Words after the Specific Value in a cell

I have been trying to extract the words after this DONE=> sign using REGEX. But its not working. Your help will be highly appreciated. I have tried with these formula but its not working =TRIM(REGEXEXTRACT(A3," => \…
user15169505
4
votes
1 answer

Google Sheets v4 Update Effect JSON Endpoint Data? Shut down on June 8, 2021

I read this article about a Google Sheet API v4 update. Do I need to change the current code structure? I am using simple JSON data for displaying Google sheet data on the web. I made some PHP and JavaScript base project on the web, using the below…
Manish S
  • 111
  • 1
  • 7
4
votes
1 answer

Google Sheets: Move a row of data to another sheet based on cell value

I am trying to move a row of data to another sheet based on cell value. I use this code that i found after researching on the Internet. /** * Moves row of data to another spreadsheet based on criteria in column 6 to sheet with same name as the…
wolfbooy
  • 43
  • 7
4
votes
1 answer

Google App Script check if the edited cell contains space

The following code is not working when I put a value with space in editedCellValue function onEdit(e) { var editedCellRange = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Test").getActiveRange(); var editedCellValue = …
user13854773
  • 43
  • 3
4
votes
2 answers

How to transfer ownership of a Google spreadsheet and to be a viewer

Is it possible to hand over the owner permission to the other user and change the former owner to a viewer using apps script? Transferring the owner permission to another user and being a viewer I'm trying to make a script that hands over the owner…
nkink
  • 120
  • 1
  • 10
4
votes
1 answer

How can I adjust row width & column width of google sheet dynamically using apps script?

I am about to design a structure in Google sheet. How can I adjust row width & column width dynamically using apps script? Note: To adjust the width of column or row, I mean giving width some pixels or inch size. I don't mean auto-size to fit…
k.b
  • 157
  • 1
  • 2
  • 13
4
votes
1 answer

Send a POST request using Google Apps Script

I am trying to send a POST request using Google Apps Script. According to the documentation, the request consists of three parts: Url Header Data But UrlFetchApp.fetch only allows 2 parameters. I tried to implement it in completely different…
Elazzi
  • 41
  • 1
  • 4
1 2 3
…
99 100