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 ...
