Skip to main content

Questions tagged [google-sheets]

For questions about Google's web application to create and edit spreadsheets on a web browser or app. Don't use it for the Google Drive Excel files editor. Please consider adding data as markdown table to your question; this will greatly increase the chance that you get a satisfactory answer.

Filter by
Sorted by
Tagged with
-1 votes
1 answer
33 views

Pulling data from most recent google sheet

I am currently working on a sales sheet for my team and have a question. I currently have each month separated into different sheets for ease of use with our current workflow and would like to be ...
bailey2092's user avatar
-1 votes
1 answer
416 views

Help with Google Script Editor and checking the value of all cells in a certain range

I am using google sheets to record our printer cartridge inventory, and using script editor to check the cells C2:C50, and send out an alert email if one cell falls below 1 after editing. I finally ...
Richard's user avatar
-1 votes
1 answer
67 views

Google Sheets: How to highlight the minimum value in a discontinuous range?

Here is a sample of my spreadsheet: I'd like to highlight with bold the earliest date in the yellow / red / blue ranges, without taking into account cells of the other two colours.
kazerniel's user avatar
-1 votes
2 answers
565 views

Is there a way to automate a priority table in Google Sheets based on another table?

I have a shared sheet where I have people list their classes by priority like below: StudentA StudentB StudentC StudentD Math Math Sci Eng Sci Eng Eng Math Eng ...
Arkuen's user avatar
  • 99
-1 votes
1 answer
6k views

Google Sheets ImportXML //div[@class= is not working

I am trying to scrape the div "tech-name" from this website https://www.whatruns.com/website/bestbuy.com with the following formula =index(importxml("https://www.whatruns.com/website/bestbuy.com","/...
gsupply's user avatar
-1 votes
1 answer
30 views

Extracting Titles to Sheets By Scraping

I am trying to write a formula that will scrape all of the titles of products from this page: https://www.1stdibs.com/fashion/ what am I doing wrong? =ARRAYFORMULA(REGEXEXTRACT(QUERY(ARRAY_CONSTRAIN(...
aud1one's user avatar
-1 votes
1 answer
36 views

Is it possible to acheive this in google sheets?

I want to implement the following in google sheets, but I don't know how to or if it is even possible I have a sheet, let's call it "products", in which every entry has an ID tag and a value I want ...
Francisco José Letterio's user avatar
-1 votes
1 answer
26 views

Google Sheets calendar script is timing out

function onEdit(e) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); if(sheet.getName() != "Sheet2") { return; } var lastColoum = sheet....
Peter Mash's user avatar
-1 votes
1 answer
296 views

Fix my script? How can I automatically create events in google calendar using dates from google sheets?

I read that it is possible to link a google sheet to google calendar, so dates can be used to create events in the calendar. I used script I found around about, but absolutely nothing happens. Can ...
Imogen's user avatar
  • 1
-1 votes
1 answer
1k views

How to prevent accidentally deletion of spreadsheets

I am using google drive sheets every day and today i deleted a folder by mistake so please share me the ways how to prevent the sheet deleting it
Manoj Pandiselvi's user avatar
-1 votes
1 answer
36 views

Why is this custom formula conditional formatting rule triggering wrongly?

In this (partially redacted) sheet I want to set rules based on the Q column: Q is date-formatted but clearly is not blank, so why is the formatting being applied? I've tried other rules like exact ...
Mr. Boy's user avatar
  • 568
-1 votes
1 answer
101 views

Change a date reference as text to Google Sheets date format

Need to change "December 23, 2019 at 08:31PM" to a date Google Sheets recognize.
Francis's user avatar
-1 votes
1 answer
261 views

No logger output in sheets

I am getting no output from the logger in sheets. I am a noob, although a 30+ year programmer. Here is my function: function onChange(e) { var spreadsheet = e.source; var cell = spreadsheet....
user3670606's user avatar
-1 votes
1 answer
2k views

How to add Print buttom in a sheet to print other sheet

I need a script to, adding a print button in a sheet1, to print the entire sheet2. How can I do this? Many thanks
Mario Inacio's user avatar
-1 votes
1 answer
204 views

ImportRange and Query Function Data is condensing into one cell

I am trying to create a spreadsheet that imports data from one spreadsheet into another and then sorts that data by a key phrase. Here is the formula I am using: =Query(Importrange("URL","...
the_Jo_Bro's user avatar
-1 votes
1 answer
41 views

I would like to use conditional formatting with references to another sheet

In a sheet of a Sheet doc, I would like to use conditional formatting : Which applies to my sheet1, range E8: UH49 Custom formula: = OR (COUNTIF (Holiday1; E5); COUNTIF(Holiday2; E5)) With Holiday1 ...
Niniy's user avatar
  • 1
-1 votes
1 answer
16 views

IF THEN Google Sheets - referencing different workbook

I'm hoping to do the following: Spreadsheet 1, cell A1: pull in data from cell A1 in Spreadsheet 2, but ONLY if cell B1 contains exact text of "partner". Is this possible?
Kenna CB's user avatar
-1 votes
1 answer
34 views

google sheet need formula to go backward directory of URL link

example i have data in colum https://www.mybookStore.com/images/products/80/1020/40422/2/279/howtocookegg8.jpg https://www.mybookStore.com/images/products/80/1020/40422/2/279/howtocookegg9.jpg i ...
extreemblank's user avatar
-1 votes
1 answer
165 views

Google Sheet - Hide cell value if not authorize

I had a GSheet file with a vote system like this |user1|1|4|6| |user2|5|4|1| |user3|2|4|4| ... Actually, each user can only edit his line with cell authorization. We want to "hide" cells of other ...
Krishnak's user avatar
-1 votes
1 answer
53 views

Goggle sheets linking different sheets

Using Google Drive can I link a whole worksheet from a shared with me file to insert it as a sheet into a workbook that I created in my drive. I don't want to link cell range values, I want the whole ...
Aggie's user avatar
  • 1
-1 votes
1 answer
36 views

White pages while printing

I've made a simple sheet to generate a random list of words to be printed. I don't know why but even if I've made the formula to check the number of words in column A of "lista" tab, on the print tab, ...
Simone Rosmarino's user avatar
-1 votes
1 answer
735 views

Importrange a formula?

My question is: I've a lot of files, like 30+, that I need to maintain periodically. My idea was to create a master file, where I will modify formulas only 1 time, and then the formulas will be ...
Simone Rosmarino's user avatar
-1 votes
1 answer
3k views

UNIQUE ,INDEX AND IMPORTRANGE

I am stuck. I use the import range to get a set of data however now I need to the unique values that that matches the import range that I have. Say for example below is randome sample. I have import ...
Lulu's user avatar
  • 1
-1 votes
1 answer
46 views

Copy cell info on account of cell matching specific te

Edited as response to comment: I had to copy data into a new sheet, which is why it doesnt entirely match your answer. Here is where Im at now: attached screendump is new. Hope you can help with ...
Lasse Hanberg's user avatar
-1 votes
1 answer
39 views

Is there a way to sum a bunch of IMPORTDATA() outputs?

I am attempting to sum quite a few different ranges of IMPORTDATA() I want to do something like: =SUM(N9:N14,N16:N21,N23:N36,N38:N53,N55:N106,N108:N113) My issue is it can't sum up a bunch of ...
Christian's user avatar
-1 votes
1 answer
26 views

How to read a long text in a cell that's a result of a formula?

I have a text cell that needs to in the "Clipping" wrap mode, cutting most of it away from view. Or is at the end of the range. Or is too long to be displayed. Normally, I would read the cell by ...
Petr Doležal's user avatar
-1 votes
1 answer
283 views

How do I only select non-empty cells in function?

I use this function to find a random content of a cell: =index(A3:A100, randbetween(1, counta(A3:A100) ) ) Some of the cells in A are empty. How can I change this function so that only those cells ...
Felix Unterwegs's user avatar
-1 votes
1 answer
22 views

How do you reference the entire google spreadsheet into another?

So, I have two workbooks, one with multiple sheets(W1) and one empty(W2) I want the empty one (W2) to have all the data (all strings, chars, and SHEETS) that (W1) has. IMPORTRANGE only takes data ...
Theodor Moise's user avatar
-1 votes
1 answer
485 views

Aggregate Formula in Google Sheet using wildcards

I'm trying to copy and paste an excel formula I use to categorize data into Google Sheets and struggle as the formula doesn't work. I have two sheets: The Referral sheet contains all the referral ...
Dlinen's user avatar
  • 1
-1 votes
1 answer
1k views

GAS MailApp.SendEmail - include multiple attachments using ss cell value

I have file names separated by commas (no spaces) in a google sheets cell 'filez1.pdf,filez2.pdf'. If I assign a variable as a string; flist = "filez1.pdf,filez2.pdf" or an array flist = ["filez1....
Steve Fairweather's user avatar
-1 votes
1 answer
372 views

Is it possible to set a timer on Google Sheets ui.alert()?

So I have a ui.alert that triggers and asks for confirmation before making an edit on a Google Sheet. function confirmation(){ //Call Spreadsheet alert and give it a variable var ui = ...
Newbie Scripter's user avatar
-1 votes
2 answers
412 views

Mark all line if checkbox is true

I will give an example: I have checkboxes in B3:G3. This is a checklist, I want to change the background color to green for A3:H3 if B3:G3 boxes are checked. Can someone please tell me how to do ...
Aviran's user avatar
  • 1
-1 votes
3 answers
1k views

How do I sort data by size and not in ABC order

I am new to Google Sheets and have only used Excel a little, so Google Sheets is a bit different. I want to sort our band uniforms in size order from smallest to largest but Google Sheets only sorts ...
user225620's user avatar
-1 votes
1 answer
218 views

Sequential numbers via formula - Google sheets - IF & MAX

I use this formula to find highest value in column A of other sheet, and then add 1 to it to get new unique number for a record ID, and I use... =if(B3<>"",max(Backend!A3:A)+1,) with this ...
Ceebee86's user avatar
  • 145
-1 votes
1 answer
279 views

How can I group rows in Google Sheets and sort

I have been trying to group rows in Google Sheets. I have a heading (name) and then the information that must be included on the sheet without losing the spacing or lines. How can I do this ...
Nick's user avatar
  • 1
-1 votes
1 answer
315 views

Google Spreadsheet Trigger which will fire when the active selection changes for a given sheet

This would be equivalent to the Excel Worksheet_SelectionChange event.
gssi's user avatar
  • 107
-1 votes
1 answer
302 views

How to categorize/tag cells containing long text according to a list of phrases?

I have cells in a google sheet which have long abstracts. I need to mark/categorize these abstracts in an adjacent column, according to a table of phrases and corresponding tags in another sheet. As ...
Haryy's user avatar
  • 1
-1 votes
1 answer
35 views

How can I extract specific information from the cells?

How can I extract just the: Brand, Showroom Only Product, etc.
audry's user avatar
  • 1
-1 votes
2 answers
498 views

Query the result of a query in the same cell

I don't know how else to put it of phrase it, I am really stumped here. I will put what I have down below and hopefully, someone will understand what I am getting at. =QUERY(Sheet3!A:B,"select B ...
Asofa's user avatar
  • 1
-1 votes
1 answer
53 views

Conditional formatting for passed dates

I need the formula to highlight a cell if the date in that cell has passed. Cell U3 had 6/29/19 today is 7/1/19 - I want to have the cell turn red after 6/29 to alert me to follow up.
Joanne Gabriel's user avatar
-1 votes
1 answer
346 views

Cut and paste data from a row of cells from one tab to another tab in Google Sheets and repeat with new data

The below code works for Q3 but not for Q5. I'm relatively new to sheets and writing code and I'm sure that you can't have two functions with the same name but am unsure how to resolve so that I can ...
Steve's user avatar
  • 1
-1 votes
2 answers
204 views

How to archive cell changes in new tab?

I have a Google sheet that I'm collecting some statistics in. There is a particular cell that I'd like to track changes in a separate tab. I'm looking for a function to copy cell if the cell data ...
Kevin Moran's user avatar
-1 votes
2 answers
102 views

Help with a Vlookup function to return multiple results of not exact match

I am trying to run the following code to return all the matches of column A from column C in a set of rows. In this situation, cell A1, is contained in a few iterations of column C, however, these are ...
user222813's user avatar
-1 votes
1 answer
29 views

Conditional formatting skipping colors after the same large value

Looks like the conditional formatting skipping large formula because of the same large values. Help me please how can I get the order what is on the picture in the column "What I would like".
Gina's user avatar
  • 1
-1 votes
1 answer
27 views

Process visualization based on data

I am trying to use a Google spreadsheet to visualize a customer journey. I am trying to create the following graphic: I have created the following example spreadsheet: https://docs.google.com/...
Carol.Kar's user avatar
  • 209
-1 votes
1 answer
287 views

Google Sheets images

When I insert an image in a cell in Google Sheets from my camera how is that image stored in the cell? I know it creates an image in my phone in a folder called images, but if I want to link that ...
Curtis Lloyd's user avatar
-1 votes
1 answer
33 views

Which event can I use to detect remote form submission into sheet?

I'm using the WordPress Contact Form 7 plugin as a website contact form. The user's date is submitted to a google spreadsheet and stored as a new row. Which event can detect that that information was ...
Saeed's user avatar
  • 1
-1 votes
1 answer
461 views

Scraping currency conversion rate from Oanda.com

A currency conversation formula for example: =GOOGLEFINANCE("CURRENCY:"&C$2, "price", A3,) Will display the closing price by default under "price". There is no option for the Average price. ...
James Blake's user avatar
-1 votes
1 answer
89 views

Auto-jump on today's date upon upening the spreadsheet [duplicate]

I use a spreadsheet with a date in a row per column. I would like to have the sheet open on the current date when opening. How can I make this?
Carl van t Klooster's user avatar
-1 votes
1 answer
336 views

Script sometimes it works sometimes it dosent

I have 2 columns to enter Lat and Long coordinates in ( E and F ), those also contain the Formulas (for all rows, I just happened to choose row 768below) =IFERROR("N"&left(index(Split(D768,"N"),1)...
Fred S's user avatar
  • 9

1
172 173
174
175 176
179