Questions tagged [google-spreadsheets]

Google Spreadsheets is a part of the Google Docs web app suite. Questions about Google Spreadsheets are off topic and should be asked on webapps.stackexchange.com, unless they specifically involve your computer or browser.

138 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
2answers
5k views

“Trying to connect” error in Google Docs on Safari

Beginning a few months ago, I started receiving a significant number of "Trying to connect" errors when using Google Docs in Safari. I can load the page fine, and I can even start using it, but ...
3
votes
0answers
404 views

How to open .gdocs and .gsheets from browser, when no Google client installed?

On a computer that has Backup and Sync (formerly Google Drive) client installed, file associations are tweaked in a way that when double clicking on a document with a Google extension (for instance ....
3
votes
0answers
1k views

Shortcut keys in Google Sheet don't work?

Background: I have version 45.0.2454.85 m of Chrome (the latest when writing this question). I have a Swedish version of Logitech MX 5500 physical wireless Bluetooth keyboard. Problem: My problem is ...
3
votes
0answers
2k views

Histogram of dates in Google Sheets or OpenOffice

I have a list of dates that I would like create a histogram of. date 5/21/2014 5/20/2014 9/16/2014 5/28/2014 6/8/2014 6/8/2014 5/28/2014 5/20/2014 8/11/2014 7/19/2014 8/11/2014 The chart's x-axis ...
2
votes
0answers
82 views

Chromebook - Sort and Filter in Google Sheets while Offline

I have spreadsheets stored offline on a Chromebook that I would like to sort and filter without needing to go online. They were created by downloading from Google Sheets, but when I open them locally ...
2
votes
1answer
274 views

Major FIREFOX Redirect Error Problem (Error Code 11156)

I would appreciate some help please. When I try to log into some website, im being redirected to the members only page (e.g. dashboard, main account, etc) but instead of successfully landing there as ...
2
votes
1answer
821 views

Store Values from a Dynamic Cell Elsewhere in the Spreadsheet - Building a Database with Excel/Google spreadsheets

I have a list of values that updates as new data becomes available on a website using importXML (cells A1-A25). I want to store those values elsewhere in the spreadsheet so that when the values ...
2
votes
0answers
216 views

Merging CSVs with some common columns (though columns are in different places)?

I'm looking to merge CSVs that have common columns, but the columns aren't always necessarily in the same place. The CSVs do have a header row. I just want to try to get the data appended to the ...
1
vote
0answers
27 views

Optimizing sales in excel/google sheets

I have a table that looks like that: investment p1 p2 p3 1000 100 50 80 2000 200 60 95 3000 300 70 110 4000 400 80 125 5000 500 90 140 6000 600 100 155 7000 700 110 170 8000 800 120 185 ...
1
vote
0answers
14 views

Specific format on multiple cells depending on the values of other cells

Let suppose I have A1:C3 for instance that I want to have a specific format (for instance blue borders) depending on another value of the spreadsheet, for MWE, A5:C8. A5:C8 could be binary values and ...
1
vote
1answer
28 views

Extracting text between two repeated sets of values in Excel

I have campaign names that conform to the following structure: [Network] - [Language] - [Country] - [Channel] - [Campaign Type] - [Free Text] This could look like: Google - English - India - Display -...
1
vote
0answers
38 views

How to edit Google Spreadsheets file directly in Google Chat window?

How can I edit sheets directly in chat window as shown in this commercial video?
1
vote
0answers
14 views

How to show different type of legend below specific columns under X axis on stacked bar chart

I have drawn a stacked column chart in Google sheet. I want to put different legends below specific columns as secondary label under the x-axis; here is my spradesheet link: https://docs.google.com/...
1
vote
2answers
58 views

Is it possible to reuse the same sumif range?

In the following table, I constantly reevaluate a2:a4 to run different calculations against it. In a real table it would have been thousands of rows like it. Is there a way to somehow store a2:a4 in a ...
1
vote
0answers
19 views

In Excel/Google Sheets, how can I get the rows between two strings/headings which are in the first column?

I have a sheet which is formatted like this: original_sheet Header1 Row 1 Row 2 Row 3 Row 4 Header2 Row 6 Row 7 Row 8 Header3 Row Row Row I am looking to copy the rows under each header into their ...
1
vote
0answers
43 views

In a spreadsheet, can you force pasting from the system clipboard?

I've noticed what seems to be new behavior the past several months in a few spreadsheets on Windows 10. Actions Taken: Select and Copy a cell in a spreadsheet. Observed in Windows 10 / Microsoft ...
1
vote
1answer
57 views

Counting from & to specific dates & times on a spreadsheet - mostly done, but some bugs

I wanted to make a spreadsheet that I could enter a date & time and calculate how much time (in years/dates/months/weeks/hours/minutes/seconds...) I kept expanding on it. it serves very little ...
1
vote
0answers
13 views

finding difference in two columns of a spread sheet?

lets say I have 3 columns A B C 1 2 2 3 4 5 and i will go on entering numbers in A and B, in C I need to have the difference between col B and col A, can I write a single formula for ...
1
vote
1answer
19 views

Multiple values same line COUNTIF

I have a table as follows for a musical instrument casting sheet [titled Song Casting) Here's an MWE: +--------+------+--------+-------+------+--------+---------+ | Song | Bass | Guitar | Drums | ...
1
vote
0answers
81 views

Use scientific notation in log spreadsheet labels

I have a chart with a normal X axis, but a logarithmic Y axis. The range for the Y axis is between about 10−19 to 1. After adjusting the Y axis label to show each power of ten, the Y axis label column ...
1
vote
1answer
20 views

How to conditional format a column

I am trying to create a conditional formatting rule for a column of dates. The column of dates is a list of move out dates. I would like dates that are within 30 days to be red, dates between 30 to 90 ...
1
vote
0answers
77 views

Google Combo Chart veritcal axis with percentage sign and right axis without percentage sign

I want to create Google Stacking (100%) Combo Chart with a veritcal axis with percentage sign and right axis without percentage sign for a line serie. The nearest I have come is to set scale factor ...
1
vote
1answer
20 views

A tricky Data Merge or Mail merge

I am looking for a solution where I can convert the spreadsheet data about [who] has [how many of] [what item] to PDF pages that contains a grid of item name with item picture. It's easiest for me to ...
1
vote
1answer
3k views

What could cause 429 errors in Google Sheets?

We have a Google Sheet (implementing Import Range) randomly giving these errors in the developer console: Failed to load resource: the server responded with a status of 429 () When this occurs, the ...
1
vote
1answer
201 views

SUMIFS and EOMONTH formula to calculate monthly spending

I’d love some advice on combining two formulas in Google Sheets. Goal: I want to calculate my monthly spending based on a dropdown list of categories I've set up (e.g. Food/Groceries, Shopping, ...
1
vote
0answers
41 views

How could I create a filter custom formula that returns a match for cells CONTAINING a word/phrase OR another word/phrase?

I'd like to create a filter using a custom formula that will display only cells that contain the word "Red" or "Blue" (as an example) as part of a longer string. These words are mutually exclusive so ...
1
vote
0answers
23 views

I want to push either a TSV file or JSON up to a Google Sheet

I have several large files of key/value pairs delimited by an equal sign ("="). One file is the master file. For each file, I want to populate columns A, B, and C as follows: A: The unique key for ...
1
vote
0answers
99 views

How to work Google Sheets?

I am working in Google sheets which is the same as the excel program. How do you make it so that when one cell is changed in a column all of the cells in that column are also changed so that they all ...
1
vote
0answers
223 views

Have Multiple Selected Elements in a Cell Dropdown

I would like to select items from a pre-created list of possibilities. This is why I use a data-validation dropdown. But I would like to select more than one dropdown element. How can I implement in ...
1
vote
1answer
65 views

Formula Needed: How to calculate Time Escaped

We have an escape room business. We're trying to get a leaderboard setup but we can't seem to figure out how to set the times in excel. Can someone please help? Format is (minutes:seconds) A 35:06 ...
1
vote
0answers
558 views

How to parse JSON array data from GMail to Google Spreadsheet?

OK, I hope to be clear while explaining what I would like to do... I've setup a personal ADSB station (helping me with other tasks, too) putting antenna for 1090, Raspberry Pi 3B, filter and amplifier ...
1
vote
0answers
660 views

Create a student contact directory using google sheets?

I'm planning to create a spreadsheet containing the following student details: names, chosen subject, group letter, time slot, student bio, student cover letter. I would like to know if there is an ...
1
vote
1answer
795 views

Populate Spreadsheet with files within a folder

I need to manage a lot of files within folder related to a project, at the moment these files reside in Dropbox. So, I will like to find a way in which I can have a Spreadsheet populate itself with ...
1
vote
1answer
2k views

Convert duration text to duration value

I need help on Google Sheets/Excel. I extracted sports results data with the IMPORTHTML function of Google Sheets. All the cells in the Result column contain a duration in the form of "m:ss.00" but ...
1
vote
1answer
599 views

Can I add rows to a Google Drive spreadhseet from a local text file?

Is there a way to automatically add rows to a Google spreadsheet documents by editing a local text file? Maybe via DropBox or GoogleCL?
1
vote
1answer
1k views

Alternative, more efficient scraping method for a noncoder, than Google doc's importxml and xpath?

I've searched throughout the net for a simple solution, but it seems everyone has their own unique method (coding language) of achieving this. I'm only just beginning to learn Linux, and my coding ...
1
vote
2answers
3k views

When a Google Sheet is exported to Excel the line heights of wrapped text are not maintained - any way to change this?

Ive got an issue when exporting an Excel file form a Google Drive Sheet. If i have a large amount of text / data in a cell in Google Sheets i use the wrap text feature so that all the text is ...
1
vote
2answers
25k views

Automatically import data into excel from Google sheets

I use the importrange feature to import data from one Google sheet workbook to another. Does anybody know if it's possible to import and populate a cell from a Google sheet workbook cell into an excel ...
0
votes
0answers
21 views

Importing Fair Value from simplywall.st via importXML to Google Sheets

I'm trying to import the fair value from https://simplywall.st/stocks/us/tech/nasdaq-aapl/apple via the importXML function in Google Sheets using the XPATH for the FV. The formula: =importXML("...
0
votes
0answers
16 views

How to get a vertical bar chart with the sum of rows grouped by month

I have a spreadsheet with over 300 rows, and in each row I have a Created At column with this date format: 20/Apr/21 5:34PM. I would like to have a vertical chart that is the sum of the rows for each ...
0
votes
1answer
15 views

Using IF to apply different rounding rules based on value range - error with too many IF arguments

I am trying to build a formula that will round a value in a cell based on these requirements round to 0 if less than 2% round to the nearest 2% increment up to and including 10% round to nearest 5% ...
0
votes
0answers
42 views

How to apply Text cell format permanently on a google sheet's column?

I recently added IDs as Number in a column those are basically built as alphanumeric. Then I've applied Text cell format on those IDs to keep their data consistent with the other cells in that column, ...
0
votes
0answers
11 views

Check duplicate then copy $ cell next to duplicate

I have a large dataset with duplicates in multiple columns the only exception is that for every duplicate the cell (email) is different. I want to copy that email and place in the same row as the ...
0
votes
0answers
28 views

Copying names from one sheet to another based on 1 of 6 criteria in another cell

I have a google sheets workbook with 3 tabs. 1st tab is the main tab I'm pulling from I have a column for names and a column of states the users are from. 2nd tab is for all users from the West and ...
0
votes
0answers
17 views

How to reference “This” Column?

Maybe I'm dumb, but how do you just reference "This" or "Current" column? For example, counting entries in a column. I know you can enter a formula & drag it, or copy it & ...
0
votes
0answers
14 views

How to return the sheet name of a given cell of a query result

I have scrubbed the internet for answer to this and and either I am asking the question the wrong way or it isn't possible. Here is a example template of what I am wondering about: https://docs.google....
0
votes
0answers
29 views

Excel sheet to read data in real time from *shared* spreadsheet

I have an online quiz setup using Google Sheets, and I want to transfer it to Excel. Here's what I have: Team1,...,Team9 have their own 'Answer Sheets' which are Sheets with a cell, A2, where they ...
0
votes
0answers
28 views

Convert automatic values into raw data in Spreadsheets

I receive data automatically from a website into a Google Spreadsheet. So each new entry gets a new row. Within that spreadsheet I added a new tab to re-layout the data "nicely". I do that ...
0
votes
0answers
11 views

Google Sheet “View only” - add my own comments (for my own viewing only)?

I have access to a Google Sheet that's "View only" (so I can't edit or comment). I was wondering though if I could nonetheless add my own comments and other annotations for myself? (So for ...
0
votes
0answers
19 views

How to average different % values depending on drop down list text value

I am trying to have a function that takes the %'s of a column and average them only if the text value of another column on the same row is a certain text value, over multiple rows in sheets I tried ...