One of productivity apps in Google Drive, that allows you to create and edit worksheets

learn more… | top users | synonyms (1)

0
votes
0answers
7 views

Google Spreadsheet forcing time format to non English language

I have created a sheet that has time point displayed for each record. Example: 2:30 PM, 4:30 AM As my sheet is going to be used in India, I changed location in the setting and right after that, it ...
2
votes
1answer
19 views

Google spreadsheet formula using If() And() Or() Statement

I need help with a Google spreadsheet formula. This is what I'm trying to do: If (A3 = X) and C3 is not any of the following choices in this list ("Ready for QA Testing on Stage","Deployed to ...
0
votes
0answers
7 views

Is there an online spreadsheet where I can share individual columns?

I sometimes use a spreadsheet when grading student assignments, where the leftmost columns describe the different parts of the assignments and possible points, and there is a column for each student. ...
0
votes
0answers
5 views

How do I transpose data in a Google Spreadsheet and keep the formatting?

If we select a empty line and we type: =TRANSPOSE(A1:C27) We will invert everything from A1 to C27. However, formatting will be lost. Is there anyway to keep the format too?
1
vote
0answers
22 views

How to combine and consolidate rows from multiple sheets into one and sort them?

I've few sheets where rows are populated dynamically via IMPORTXML and ImportJSON with the same columns, but they can't be sorted. So I'd like to generate new sheet which will populate rows from ...
1
vote
1answer
37 views

How to import JSON data into Google Spreadsheets?

There is IMPORTXML function to import data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. Is there any similar solution to import data in JSON ...
-1
votes
0answers
15 views

How can I transpose a row into a column in a new spreadsheet [duplicate]

I'd like to take an existing row from spreadsheet one and make it into a new column in spreadsheet two. Any suggestions or ideas? Thank you!
1
vote
1answer
52 views

How do I get a date formatted as YYY-MM-DD from a cell for using in a script?

I have a problem getting a date from a cell in my Google Spreadsheet. I would like to access A3 in the sheet Dates, which holds the date 01/12/2013, and re-use that as variable start-date in the below ...
-1
votes
0answers
9 views

How to get value from cell above cell that matches criteria

So, basically, I've got this table: A2:A =MIN(ARRAYFORMULA(IF(ISBLANK($D2:$G2);$D$1:$G$1;Temp!$C$89))) B2:B =MAX(ARRAYFORMULA(IF(ISBLANK($D2:$G2);$D$1:$G$1;Temp!$C$89))) C2:C =SUM(D2:2) and ...
1
vote
0answers
20 views

Is there a way to stop Google sheets from telling me to use Ctrl C?

I know the keyboard shortcuts for cut, copy and paste, and I use them frequently. But there are times when using the mouse is much more convenient. Especially if I want to copy a whole row, I prefer ...
1
vote
2answers
20 views

How to add adjacent cells in Google Sheets

I am looking for a way to add up cells under a name. For instance, I am trying to tally all of the assists the character "Annie" got in a few different games of League of Legends. I am looking for ...
-1
votes
0answers
13 views

Combine two COUNTIF formulae into single cell

I am trying to make these two formulas into a single formula in a cell: countif(range,"open") and array formula(countif(year(range),2014) They both work on their own, but I would like to put ...
1
vote
1answer
15 views

Subclauses in formulas?

Quite often I end up including the same calculation in a formula twice, like this: =if(iserror(vlookup("lookup",SheetX!A2:X350,5,false)),"",vlookup("lookup",SheetX!A2:X350,5,false)) I'd like to ...
0
votes
1answer
16 views

Google spreadsheet thinks Chrome is Firefox

I am an Ubuntu user with Google Chrome 39.0 and whenever I enter a Google Spreadsheet-document (with Chrome), I get a warning header saying that "This version of Firefox is no longer supported, please ...
1
vote
0answers
5 views

“Trying to connect” error in Google Docs on Safari [migrated]

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 ...
4
votes
1answer
39 views

Is there a quick way to see when a cell in a Google Sheet was last edited?

Google Sheets has a revision history accessible from File / See revision history. However, it doesn't appear to easily allow you to see when a particular part of the sheet (e.g. a cell) was changed? ...
1
vote
0answers
18 views

How can one serve a single google spreadsheet cell content to a web page?

I can embed a Google Docs/Spreadsheet's whole tab/table on a web page. Is there a simple way to publish the (unformated) content of a single cell?
1
vote
0answers
16 views

How do I get the data in a cell of the last column of a row?

I'm using Google Sheets. Every week I add a column with new data, and I need the data from the latest column copied into another sheet. The formula needs to pull the cell of the last column in the ...
2
votes
0answers
33 views

Formula breaks subtly in ARRAYFORMULA in Google Sheets

I have a spreadsheet document with a formula comparing a list of URLs to lists on two other sheets within the document. I desire to know if each URL on the first list is present on the blocklist, ...
2
votes
2answers
22 views

How to count exclusive values in Google Sheets

Ok, so I have data in this format: A B C D 2 X X X 3 X X 4 X X X 5 X 6 X X ... I have a formula ...
0
votes
0answers
27 views

Can Google Forms & Sheets serve as a kind of DB?

Pardon the naive way I am expressing this question. I'm a teacher trying to create a database of grades. I'm trying to figure out if Google Sheets and Google Forms is sufficient for my task or if I ...
3
votes
0answers
17 views

How to select a cell from all spreadsheets?

I am trying to find a function that selects from a certain cell from all spreadsheets. For example, I want to calculate AVERAGE('Sheet1'!B3, 'Sheet2'!B3, 'Sheet3'!B3), but I don't want to explicitly ...
1
vote
0answers
48 views

If condition won't work Google Spreadsheets

I have this formula and it doesn't work: =IF(A1="oui","1",if(A1="non","0","")) I asked a couple of friends to test it, and oddly, it works fine with them! What did I do wrong? And how do I fix it?
1
vote
2answers
71 views

Google Sheets ARRAYFORMULA not copying form responses

So I have a form setup which sends data into a sheet labeled 'Form Responses'. I have another sheet that mimics the column layout of 'Form Responses' but has formatting applied to it, (called ...
0
votes
0answers
20 views

Moving data between columns in google sheets

I want to manage my tasks in Google Sheets. Right now I list all my tasks in column C (as shown below) Is there a way to 'indicate' that a field in column C has been done (like I have in Column A) - ...
1
vote
1answer
25 views

Google spreadsheet - QUERY changes time format

I have this column with amounts of time (format set to number > duration), if I made a query of that column I get it with a different time format and I'm not able to set the proper format back again. ...
1
vote
1answer
35 views

Google sheets VLOOKUP issues not finding a value thats is in its range

Heres a link to a copy of my spreadsheet I am attempting to do the same formula using a VLOOKUP in 4 sheets to do a calculation called LSI. In the first sheet I have the raw data from a form coming ...
-1
votes
0answers
22 views

Array in Google Spreadsheet that tracks totals per name [closed]

I am building a spreadsheet that tracks "stats" for a group of people that change from week to week but also have people participating in the sport on multiple weeks. In my array I have a column ...
1
vote
1answer
25 views

Google Sheets list key with highest value in key value pair

I have a some data in key-value pairs setup like so: A B 1 Key: Value: 2 Cars 5 3 Bikes 4 4 Vans 9 5 Trucks 6 What I can't seem to ...
1
vote
1answer
43 views

IMPORTXML: xpath to get non-distinct parent node data for each child node

Google Spreadsheets has an IMPORTXML function, which I am trying to use to maintain a list of TV episodes, based on the API at http://services.tvrage.com/feeds/episode_list.php?sid=3183. I am trying ...
0
votes
0answers
12 views

“Service using too much computer time for one day” Can I see computer time per sheet?

With my Google Spreadsheets I keep getting "Service using too much computer time for one day" messages. I have already tried removing some older sheets and reducing calls to custom functions and ...
2
votes
1answer
23 views

Had a google spreadsheet query that worked but now doesn't

I made a copy of the spreadsheet that I'm working on here. The query that I have on on the sheets "DSM", "DiveTank", "WarmUp", "Teach" all have pretty much the same query. That worked before but now ...
3
votes
1answer
56 views

How to force a page break in Google Spreadsheets

I want to force a page break after a certain row of a sheet. Is there some analogue of Google Docs’ (and Excel’s) “insert page break” for Spreadsheets? If there is no “native” way to do this, maybe ...
0
votes
1answer
44 views

Google spreadsheet query reference to several sheets

I have this formula: =ArrayFormula({query(query({A3:D,value(B3:B)}, "select Col1, sum(Col5), count(Col4), sum(Col3) where Col1<>'' group by Col1 format sum(Col5) 'h:mm:ss'"),"select* offset ...
1
vote
2answers
22 views

Associate cells to imported ones with importrange in Google Sheets

I have the following issue: I have table A with several columns and I use the following function to import some of data to table B: ...
1
vote
0answers
20 views

Why is there sometimes no “Move to trash”/“Move to bin”

I'm trying to clean up some old Google Sheets, but some of them don't have a "move to bin" menu option: Other spreadsheets do have it: What's the difference? How can I delete spreadsheets that ...
0
votes
0answers
20 views

Manage time series in Google Sheets

I'm working a data sheet that models some goods cost and benefit across a number of years. I have some values in a grid where row is a data point name and column is the year, relative to buy time. | ...
0
votes
1answer
32 views

Google Spreadsheet: How to fill in missing values (inbetween filled values) automatically

I made a spreadsheet for tracking weight, where each row is one day, and one column is weight. Although I've had Google Spreadsheet create a row for every date in the year, I only measure my weight a ...
1
vote
1answer
53 views

Google Sheets - Auto update table and auto add new data entries

I have a table in wich raw data is entered manually, with info about clients and the requests they made. And then I have this table in which I'm trying to analyze a bit the raw data (# of requests ...
1
vote
1answer
35 views

Can I use ArrayFormula with CountBlank or IsBlank if so how?

=IF( OR(COUNTBLANK($F3)>0, COUNTBLANK($G3)>0, COUNTBLANK($H3)>0, COUNTBLANK($I3)>0), "Missing Values", $E3+(index(LSI_Index!$B$4:$B$40,MATCH(VLOOKUP($G3, ...
0
votes
1answer
26 views

Tolerant Sum of column

I would like to make the sum of a column which might also contain cells which are not parseable as a number (strings, empty, etc). These cells should just be ignored. I've tried: ...
1
vote
1answer
28 views

How can I add hours in Google Sheets to show days?

I have 2 cells in Google Sheets with values: 22:00:00 22:00:00 and I have a cell which has the function sum to sum these values and it shows the value: 20:00:00 I am guessing it is trying to ...
2
votes
1answer
44 views

Google Sheets Query Get Row When Any of These Cells are Not Empty

So like my title states I would like to select via a Query only the rows where certain cells are not blank/empty. I have 4 pools that I have a form for collecting their chemistry. In separate sheets ...
1
vote
1answer
15 views

Convert table data into a list in Google Spreadsheet

I'm using Google Spreadsheet and would like to convert a table into a single column of values so I can paste them into another program. Original Data: x y z a b c Desired Outcome: x y z a b c ...
1
vote
1answer
40 views

How to skip blank cells in Google Spreadsheet/Excel when copying a range from source to destination by Formula

I have three levels of hierarchical data in Google Spreadsheet that looks something like this: As data is being entered in here, I want it collect in three separate sheets like this: And The ...
-1
votes
0answers
14 views

Google Spreadsheet - How to input a graphic in a Google doc and then update if I chnage it in Goolge Spredsheet

Maybe it's a dream...Google Spreadsheet <--> Google Doc In a Google Spreadsheet : I have a graphic .. (from statistic cells). I'd like to make a report in Google doc sheet: Text + import many ...
3
votes
1answer
65 views

Created a Google Form; can't find the Spreadsheet

Long ago, I created a survey that I sent out by email. The responses were recorded in a Google Spreadsheet by filling out a Google Form. I would like to use that data again, but I cannot find the ...
1
vote
1answer
21 views

Using a cell text as sheet reference

Is it possible to use a cell text as a sheet reference in Google sheets. I have a spreadsheet with many sheets and want to reference a sheet name from text in a cell rather than having to put the ...
4
votes
1answer
56 views

How do I copy cell values programatically?

How can I do this programmatically in Google Sheets? How can I copy cell values rather than references from one sheet to another in Google Docs? I have a RSS feed, that I am working along side, so ...
0
votes
1answer
35 views

Find the nth occurrence of variable, look at adjacent cell and organise in an array

I have a Google spreadsheet with two arrays: The first is a list of ~100 names (in a single column) with the adjacent column being the variable (A,B,C,D,E,F,G,H,I or J). The purpose is to group people ...