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 a demo spreadsheet to your question; this will greatly increase the chance that you get a satisfactory answer.
6,994
questions
0
votes
0answers
4 views
Google Sheet suddenly “Unable to load file” if I expand my pivot table on desktop
Possibly the strangest and most confounding issue I've ever run into with Google sheets, has just begun today.
I have a spreadsheet I've been building for a couple of months now. I work in it ...
0
votes
0answers
2 views
Google sheets “series selector” color doesn't match line color
How do I force the google sheets "series selector" color (in settings for series) to match the color assigned to the lines for the series?
In my sheet, when I change the line color, the ...
0
votes
0answers
3 views
“Could not fetch URL” ImportHTML/ImportXML Error [duplicate]
I've seen a few responses on this subject, but I've tried everything & have yet to have luck. I'm looking to import the "Game Box Score" tables into Google Sheets for this link:
https://...
0
votes
1answer
4 views
Can I assign two functions to a single menu item in Google sheet app script?
Is it possible to assign two function names into a single custom menu item like this script:
function onOpen() {
var menuItems = [
{name: 'Draw Borders', functionName: 'borders'},
{name: '...
0
votes
0answers
3 views
GOOGLEFINANCE is not showing the end date price within a date range
----please note that this has nothing to do with stock quote time delay-----
the picture speaks for itself, when I try to fetch the highest price for a stock within a range of dates (doesn't matter ...
0
votes
1answer
9 views
Google Sheets: Joined queries registering as two arguments in IFERROR() function
I'm joining two queries together using an array: ={query(A1:B,"Select A where B is not null");query(C1:D,"Select C where D is not null")}. I have it wrapped in an iferror() that, ...
0
votes
0answers
5 views
How can I view my Google Sheets documents after downloading them to a zip file? [closed]
I created a backup from some important Google Sheets and compressed them into a zip file, then proceeded to delete the files from Drive to keep anyone from accessing them, which was stupid of me. Now ...
0
votes
0answers
5 views
How is Google Sheet able to allow user to scroll page while dragging? [closed]
According to HTML spec dragging operation shouldn't fire mouse events while dragging:
From the moment that the user agent is to initiate the drag-and-drop operation, until the end of the drag-and-...
0
votes
1answer
13 views
Creating a multiselect lookup row in Google sheets
I have a sheet of activities that looks something like this
Activity Name
Category Ids
Activity 1
123456, 98756, 345677
I have a second sheet of category ids
Category Id
Category Name
123456
...
0
votes
1answer
11 views
Script to Copy multiple sheets from an Excel file and convert it to a Google Sheets file
I have an Excel file with 3 tabs (Sheet1, Sheet2, Sheet3) attached to a Gmail message and I would like these to copy to a Google Sheet file with 3 tabs (SheetA, SheetB, SheetC). The problem I am ...
0
votes
1answer
9 views
How to set a max number of days and then increment one day for each over
I am trying to build a list where a column automatically pulls a date for a service (Painting) based on the Move-Out Date it will assign 8/1/2021 as the Paint Date for the first 10, then will graduate ...
1
vote
2answers
19 views
Delete rows in Google Sheet after 30 days
I have a Google Form that populates a Google Sheet with rider registrations for a local cycling club. The sheet has a filter in place to display only the riders for the current day. This filter ...
-1
votes
1answer
16 views
Google Sheets Pie Graph Aggregation Merges Completely Different Categories
I've been trying to make a basic chart in google sheets that puts together the time taken for various activities to make a pie chart. Since the same activities appear multiple times I need to ...
0
votes
1answer
25 views
QUERY syntax using cell reference more than 1
I'm having trouble figuring out a fairly simple QUERY statement in Google Spreadsheets. I'm trying to use a cell reference instead of static values and I'm running into trouble.
=QUERY(Responses!B1:I, ...
0
votes
2answers
17 views
Split a column and rearrange it on Google Sheets
I have a column with three codes separated by space. These codes are M, N or T followed by a one digit number (e.g M1 N3 T2, or N2 T1, or just M1), always in the same order: first M, then N, then T, ...
0
votes
0answers
33 views
Notification when a Google Sheet is not being updated [closed]
I have an integration process running from another tool that is populating a Google Sheet every 15 minutes (00, 15, 30, 45).
Every night when the job runs at midnight, it will create a new tab with ...
0
votes
1answer
15 views
Google Sheets: How to have conditional formatting based on each individual cell?
I have a Google Sheet where it's a table full of people's Euro Cup soccer picks. I want to have a column at the end where I type the winning team into a cell. If that value matches then I want the ...
0
votes
0answers
10 views
Goto specific page in embeded google drive document? [duplicate]
Hi amazing HeroStacks
So as title suggest, I have an embedded google drive document (.pdf), where my webpage loads a window with a 36 page interactive brochure.
My goal is to be able to link to a ...
0
votes
1answer
10 views
Google Sheets conditional formatting multiple columns with ignoring blank cells
I want to highlight the cells in E/F/G columns when they exactly match the score in column D, but I want formatting to ignore blank D cells. Can I do this somehow?
0
votes
1answer
11 views
Keeping manually entered data side-by-side with pivot table data — row misalignment issue
I have a Pivot Table (columns 1 and 2), and I also have manually inserted data (columns 3 and 4):
But when more data gets added to the pivot table, the manually entered columns won't follow "...
0
votes
3answers
36 views
Add a new row each time a new response is added to the Google Form
I have a Google Sheet linked to a Google Form. In the second page I added a formula to clean up the data, since one of the questions allows to chose multiple options and it results in a column with ...
0
votes
1answer
20 views
Copy data from one sheet to another at the end of every month [closed]
I have a Google Sheet where I track the performance of multiple campaigns.
I want to copy the completion value to another sheet at the end of every month. Each month should have it's own column. This ...
0
votes
1answer
7 views
How to jump to a specific customer name in a Google Sheet
I am trying to create a Google Sheet that lists all payments made for tuition by family. I would like to use only one tab (not create a tab for each family) as I have about 120 families to keep track ...
0
votes
1answer
13 views
Run Script in Google Sheets without Activating Sheet
I have a spreadsheet that uses IMPORTHTML to pull information from a table into a worksheet called "Data". On a separate worksheet I run some calculations and display results. I have a macro ...
0
votes
0answers
20 views
Is there a way to copy a tab to multiple Google-spreadsheet files at once?
I have hundreds of Google sheets that I want to add a unified extra tab to them all at once. Instead of copying the tab to an existing sheet ID repeatedly for all IDs, is there a way to tell Google to ...
1
vote
1answer
13 views
Cell formula which returns the number of sheets
I'm trying to add some "validation" to a google sheet to prevent errors from creeping in as the sheet is edited (think assertion when programming).
Because of the way my sheet is structured ...
2
votes
1answer
12 views
Using Vlookup with Dates
Here's the set up to the problem I'm having.
I have a column of dates and a column of truck numbers. I'm trying to use VLOOKUP to find what truck numbers correspond to the dates. There are multiple ...
0
votes
0answers
17 views
“IMPORTRANGE” function not recognizing data from a cell that has a formula in it
In the screenshot, the circled numbers are being pulled from another sheet that has a formula of
=IF(G12="White","1716","2727") in the original cell it was pulled from. ...
0
votes
0answers
9 views
Stock managing my inventory [closed]
I would like to make a spreadsheet where I keep track of my stock. The two operations that I want to perform on my stock are deduction if I sell from my stock and addition if I buy more stock. This is ...
0
votes
1answer
19 views
Google Sheets - fill a cell with a hyperlink based on dropdown menu selection
so I have a spreadsheet i'm using to track clients workouts. To make life easier and faster when creating the workouts i created a series of dropdowns with exercises, body parts associated with that ...
0
votes
1answer
11 views
Using query as a text join
A few days ago I reach the limit of 50000 characters in one cell, I found a solution with "query" but I need a delimiter inside the formula that I haven't been able to find:
This is the ...
0
votes
0answers
19 views
How can I build a Predictive Model (analysis)? [closed]
https://docs.google.com/spreadsheets/d/1K2Hm1GGLPtjl327zaQdhQbIPOspIgloQZ5Elv8eai4A/edit?usp=drivesdk
In the above spreadsheet...I have imported table containing daily state lotteries results from a ...
0
votes
1answer
18 views
Minimum value across multiple rows, conditionally formatted
I need help understanding how the MIN formula mixes with conditional formatting, cause I can't wrap my head around it.
Here's specific situation:
I've successfully got formatting for minimum across ...
0
votes
1answer
13 views
Google Sheets IF formula
Have a sheet where B column is "purchase date". C column is a drop down that can be "Weekly" or "Monthly". D column either 7 or 30 days from B column depending on what is ...
0
votes
0answers
26 views
google sheets get stock in specific currency
To track stocks I made an overview of bought and sold stocks, and generate a pivot table with the current amount of stocks owned.
I want to calculate the total value of my stocks.
The problem I have ...
1
vote
1answer
18 views
How to copy column but repeat cell content in new column
I stumped on how to copy a column with unique cell contents into another column but with repeated N entries of each row with Google Sheets.
In sheet 1:
A1:A
A2:AA
A3:AAC
A4:AACQ
A5:AAIC
A6:AAL
...
0
votes
2answers
23 views
Google Sheets formula to calculate how much time will take for money to get specific value in the future
Let's assume that I have 100$, and I put it in the bank and I get 4% per year. (every day I get part of it)
How much time it will take until I have 150$?
What is the formula in Google Sheet for that?
...
0
votes
1answer
26 views
Google SpreadSheets query: how to join “grouped by” cells in a list?
Suppose I have this table:
| Name | Amount | Category |
| name_1 | 10 | A |
| name_2 | 2 | B |
| name_3 | 3 | B |
| name_4 | 6 | C |
Thanks to this ...
0
votes
1answer
14 views
Apply custom formula across all columns using Array Formula
I have trouble applying my custom formula across all columns using Array Formula. My custom formula is named getCountry where it could get the country based on an address. The address components e.g. ...
1
vote
1answer
18 views
Make a copy of a column of images omitting blank cells in Google Sheets
I need to convert column A to column B (without blank cells between the flag images) using a formula.
1
vote
1answer
34 views
How to set a locale to use comma as decimal separator and Euro as currency symbol by default
Here is my issue :
We work in English
We are a French company : we want Euro as default currency...
... and the "French formatting" for dates (dd/mm/yyyy) and numbers (1 thousand = 1 000,00 ...
0
votes
0answers
10 views
How to return column B data when writing column A word?
I'm trying to create a program using Google Sheets in which, when I write any word of the column A, the program would return the word written next to the previous word (same row, different column). In ...
0
votes
1answer
9 views
Stepped prices in Google sheets
I looking for a formula to create stepped prices based on the buying value.
Like this:
0.10 until 0.20 = $0.50<br>
0.20 until 0.30 = $0.75 <br>
... with $0.25 steps<br>
1.00 and up, $...
0
votes
1answer
32 views
Google Sheets data validation using hidden lookup value?
Let's say we have a Google Sheet used as a data validation "table"
********************************
ID | Name
********************************
1 | Mike
2 | Sue
3 | Bob
4 ...
0
votes
1answer
11 views
How to publish to the web a Google spreadsheet without gridlines?
I want to publish my sheet to web but i don't want to see the gridlines. I have tried to hide gridlines in my sheet. But the gridlines is still visible when i publish to web.
Can anyone help ?
0
votes
1answer
14 views
Conditionally Format Non-Blank Cell in Range When Adjacent Cell on Same Row Contains Either or Both of Two Specific Values
Building on a question I asked here, I am trying to conditionally format the non-blank cell within a range when an adjacent cell on the same row contains either or both of two specific values ("...
0
votes
0answers
17 views
Update column based on a cell on another sheet
I'll do my best to describe my problem and what I want to achieve. As it stands, I have two sheets. One called "First Sheet" and another called "Secondary Sheet". On Secondary ...
0
votes
1answer
16 views
Problem with query data range if a value is TRUE
https://docs.google.com/spreadsheets/d/1XFbSKOgwFlsRahaOOCq1-EZPR4JcmaT2ywUc2RQffnk/edit?usp=drivesdk
I use this sheet to list data of patients in my hospital. Also in the last tab (Possible_Discharge)...
0
votes
1answer
11 views
How do I transform raw time series data to a form that would suit a time series chart with lines named for values in the data itself?
This the data I have -
A B C
12/15/2019 Apple 37
12/15/2019 Banana 11
12/15/2019 Carrot 1
12/15/2019 Damson 4
12/15/2019 Fig 1
12/16/2019 ...
0
votes
1answer
15 views
Pull data from one tab to the other
I have 2 tabs and I want to get the information from TAB2 to TAB1. I want to get the RETAIL Price from TAB2 and place it in TAB1. The condition to get the correct price is that it should be based on ...
