Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

For questions about the Google's web application to create and edit spreadsheets on a web browser. Don't use it for the Google Drive Excel files editor.

-1
votes
0answers
4 views

Issues with graphing a line in Google sheets

A scatter plot with the point (0,0) does not go through the origin when plotted with google sheets. The equation for the line also appears to have an incorrect slope.
0
votes
1answer
7 views

Conditional formatting based on another Sheet

I have a column on sheet1 with a list of names. I need conditional formatting on it to turn it red if that name does not show up anywhere on sheet2.
0
votes
0answers
12 views

Google Sheets + ImportXML

Can someone help me import https://rotogrinders.com/lineups/nfl?site=draftkings or https://www.rotowire.com/football/lineups.php into Google Sheets in a format similar to how it is displayed on the ...
0
votes
1answer
14 views

How can I create a filter view with MOD custom formula?

I want to split a spreadsheet tab (called main) so to have (say) N = 3 people working on it without interfering with each other. For the purpose, I thought to create 3 filter views, each containing ...
0
votes
0answers
14 views

How to concatenate columns for multiple rows simultaneously in Google Sheets?

I have the following 3 rows of data in cells A1:A3 in Google Sheets: Doe, Jane Doe, Joe John Doe I want the following in B1:B3: Jane Doe Joe Doe John Doe Essentially, I'm creating a new column ...
-2
votes
0answers
14 views

return the current week is for a set of dates

Using google sheets: I have a start date and and end date. I want to show what week I am in. For the start date this is week 1. Then the following week will be 2, then 3, all the way to the week ...
0
votes
0answers
12 views

Google Sheets Date Organizer by Year-Month-Day [on hold]

I'm using Google Sheet to organize music. I need to include year-month-day for tracking. These dates will be needed to parallel recordings during practicing sessions. These dates will be typed ...
0
votes
0answers
22 views

Google Sheets - Importrange

Currently we have one summary sheet called Order_Summary which collects data, one day per column and someone at work creates a new column daily. We now have another google sheet which now records an ...
-1
votes
0answers
14 views

How to remove conditional Formatting of a given cell in Google Sheets with Python? [on hold]

I am trying to use Google Sheets for a project. I'm interacting with the project through Python. I have been able to do a lot Including reading data and write data. My original Google sheets have ...
0
votes
0answers
10 views

Count Seconds on Sheet Update

When you change any value in a cell, some functions automatically generate new update. One of these functions is NOW(). I currently have =SECOND(NOW()) in A2. I also have a checkbox made with data ...
0
votes
1answer
11 views

How to create a 3 column chart in Google Sheets with one numerical column and two text columns with customization?

Consider this data: +---------+----------+-----------+--+--+ | Food | Quantity | Type | | | +---------+----------+-----------+--+--+ | Apple | 3 | Fruit | | | +---------+-----...
0
votes
0answers
10 views

Range as a Sheet

I am trying to use Google site and Google sheet so that as people put in an application, it goes to a Spreadsheet & that range on the sheet then becomes its own sheet which I can link to the site. ...
0
votes
0answers
11 views

Google sheets script copying formatting *but not* merged cell status

I would like to write a script that copies the formatting, and the conditional formatting, that is applied to cell A1, and applies it to all of the other cells in the sheet. However, I do not want ...
0
votes
0answers
11 views

Conditional choices from a list

I have 8 different fee rates in a spreadsheet. Only one will be chosen from the list. I want to find a total of various fees that includes one of these. Is there a way to right a conditional without ...
0
votes
0answers
14 views

Can you link a cell to show data from a specific part of a PDF document?

I work in the inventory department of an auto-repair shop, and I'm trying to set up my Google Sheet document so the prices are always updated with the prices on the manufacturer's website so I don't ...
0
votes
0answers
7 views

How do I conditionally format date ranges in a dynamic calendar with multiple criteria?

I would like to differentiate with conditional formatting the different types of Leave employees can take (VAC, TIL, STAT, LOA etc as well as the status of their request "Approved", "Pending", "Denied"...
0
votes
1answer
28 views

How can I make a hyperlink from Google Spreadsheet cell to an Excel file?

How can I make a hyperlink from Google Spreadsheet cell to an Excel file? For example the hyperlink is in Google Spreadsheet and opens the Excel file. The Excel file is on the hard disk not on Google ...
0
votes
1answer
30 views

Can you set a cell to have a price on it linked to the main website?

I work in the parts department of an auto-repair shop and have been charged with organizing everything and creating an inventory sheet. I have done all of that and am now trying to improve the system ...
0
votes
0answers
11 views

Mail Google Sheet as Excel table with script

I want to mail Google Spreadsheet as excel attachment, and I also want to multiple people to look in (To. & CC), And also I want to write some message in the body. I have the script and when I use ...
1
vote
1answer
13 views

Conditional Formatting based on other column

I have a timesheet log with columns DATE | HOURS | DESCRIPTION OF WORK | PROJECT An employee may enter several rows for the same date to log the different amount of time with respect to the ...
0
votes
1answer
17 views

Absolute References

I've been looking for answers to my need, but seem to keep finding answers to the opposite problem. Here is my challenge. I have a google sheet to process payroll. On the first tab is data ...
0
votes
0answers
33 views

How to create a timestamp based on multiple cells' values?

I've referred to this example from 2017 but need a modification: it works but I'd like to modify it so 1) a date is NOT automatically populated without the cell 2) being populated with specfic text "...
0
votes
1answer
46 views

Match range to closest of 1 of 3 variables

consider the following sheet ID Hours 1 16 2 24 3 50 4 36 now I need to match the values in Col B to one of 3 variables 16, 25, 30 so what I'm trying to do is match the number in B2:B to the ...
1
vote
2answers
19 views

IFS formula with OR condition inside

Why is the following formula not working? =IFS($B$29=(OR(1;4;10));8310;$B$29=6;9510;$B$29>0;"") When $B$29 is 10, should display 8310, but becomes the empty result.
1
vote
1answer
14 views

Google Sheets query column=column

I am not familiar with google sheets, but I have been sent an assignment and I don't want to take the time to convert the whole thing over to an actual database. Is a way to take one column of values (...
0
votes
1answer
17 views

Dependant Multi Conditional Formatting

So I am building a spreadsheet and everything was working fine but then I kept tinkering with it and making it more intuitive (and less work on the user) and ran into a snag. What I am trying to do ...
0
votes
1answer
25 views

Extracting / scraping specific information off a website programatically

I have a public website link from which I need to extract a certain field programmatically. https://echa.europa.eu/fr/registration-dossier/-/registered-dossier/14500 e.g. The section that says "...
1
vote
3answers
21 views

Pulling data from one sheet to another if

My knowledge is pretty basic when it comes to excel and Google Sheets. I'll explain what I'm trying to do. I'm trying to find a way to filter information from 1 sheet to another in Google Sheets. ...
0
votes
0answers
15 views

How to see Sparkline for Mutual Funds using googlefinance?

In Google sheets when I try to plot the mutual fund price for the last one year using sparkline function, I keep getting an error. When evaluating GOOGLEFINANCE, the query for the symbol: ...
0
votes
0answers
11 views

Random PIN for each entry on a Sheet

There's a list of people that could change in size from time to time. I have a column that I want to contain a unique 5-digit PIN for each person on the list. I want to write a script that will create ...
0
votes
0answers
37 views

Is there a way to just pull out all of a certain index without going through the results and rebuilding a 2nd temp array?

I've got multiple sheets with anywhere from 500 - 10,000 rows each that I need to find specific values in a given column. Ex. Sheet A, B, C have information about a bunch of products. I search for ...
-1
votes
1answer
43 views

Link Google Form responses To Already Existing Google Spreadsheet Tab

I have a Google Form. I had all of my Google Form responses linked to a specific tab in my Google Spreadsheet. Somehow my form responses were unlinked from my tab. When I go to re-link my form ...
2
votes
2answers
41 views

Google Sheets, how to sort query results manually (Not in query)

My google sheet is importing data from another tab just for sorting purpose, however, when the sort is done manually (through Google Sheet menus), results are unpredictable. The sheet is populated ...
1
vote
1answer
13 views

Add values between two dates in Google Sheets

So I've already found this question answered several times around here but for some reason, despite essentially copy and pasting the answers it still doesn't work for me. I'm trying to add ...
-2
votes
0answers
21 views

Google Sheet copy and paste the last row

this my code in Excel VBA I want to convert it in the javascript Google Sheet Sheets(3).Activate Range("E2").Copy Sheets(2).Activate Range("B" & [B100000].End(xlUp).Row + 1).Select Selection....
1
vote
2answers
38 views

Nested IFs and SUMIFs for numbers and text in Google Sheets

I have a very specific thing I want the google sheets to give me, but I'm unsure which approach would be best. Client ID Amount Status Is delivered 56691668 10.00 USD Sent ...
0
votes
1answer
13 views

Date Query in Google Sheets with importrange

I have two tables. Table A= Customer Feedback Table B= KPI In Table A I have a column for a date with format mm/dd/yyyy and in Table B I have 2 columns as from date and to date with the format. I ...
0
votes
1answer
14 views

Syntax problem in ImportXML function [duplicate]

This is related to an earlier question regarding syntax issues with ImportXML function in Google Sheets relating to data from this providers web site: https://www.asxenergy.com.au/futures_au/N The ...
1
vote
1answer
16 views

How to sum max from date range in one cell?

I have a column with dates which looks like this: 24-7-2002 25-4-2004 13-4-2012 6-9-2018 25-4-2004 8-11-2022 etc... I would like to find out how many times the highest date appear and sum them ...
1
vote
1answer
26 views

Adding a Generated QR Code from Google Sheet to an Avery “Mail merge” template in Google Docs

Using the Avery Google Docs Add-on I am attempting to make some labels with QR codes on them. You will need to open Google Docs then install the add-on in docs. you will also need a spreadsheet ...
1
vote
1answer
31 views

How do I insert an image from Google Drive into email body with script

Could anyone help me? I've created a Google Form that uploads a file (image) to a private drive folder, the form also sends responses to a Google Sheet including the image's URL. The code below gets ...
1
vote
1answer
21 views

Google Sheets-Match IDs in different tabs to fill column

I have a Google Sheet with two tabs. Tab A has IDs and a place where I want to fill a column. Tab B has the Same IDs and the data I want to fill into Tab As blank column. I want to auto-populate the ...
1
vote
1answer
14 views

Linked spreadsheet data to document

I have created a Google document that links to tables in a Google spreadsheet. Now I want to copy both the spreadsheet and the document. However, the link remains to the original spreadsheet. Where ...
0
votes
1answer
17 views

User defined Series in Google Sheets

I have a series which is like 1,1,1,1,1,1,1,2,2,2,2,2,2,2... I have filled 1(*8) times and 2(*8) times, how do I continue this series by drag-drop option in Google Sheets?
0
votes
1answer
21 views

How can I get ''OHLC'' data rather the Close only?

=GoogleFinance("CURRENCY:EURUSD","all","1/23/2005","50") The code above just fetch the close rate and leaves the other columns blank. How to fix that?
1
vote
1answer
24 views

Is it possible to create a Named Range that is the union of two other Named Ranges?

Say I have two named ranges, team_a_coaches team_a_players Is it possible to have another named range, team_a and define it as the union of the first two named ranges? The goal would be that if I ...
1
vote
1answer
28 views

How to sum up occurrences from range?

I am attempting to calculate how many same duration between two timestamps I have in a given range. The range is Sheet1!A1:B10. I have two columns - first consists of starting time and second ...
0
votes
1answer
22 views

Examine for overlap in Google Sheets?

Let's say I have the following start and end days/times: SHEET1 Resulting in a range of time from Mon 10am through Tues at 11:59pm. I'd like to know whether this range of time overlaps another ...
0
votes
2answers
21 views

Scanning a column and partitioning information to other sheets in Google Sheets

I am a membership manager in an international organization and I was hoping to get some help optimizing our members' contact list. There are three kinds of members, NCs, LCs, and IMs. I have a ...
1
vote
1answer
20 views

Convert cell containing days of the week in first-letter format to day names in Google Sheets

I created a schedule of events in Google Sheets. I have a cell that contains MWF, indicating that the event is every Monday, Wednesday, and Friday. I have a different cell that reports the word ...