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

learn more… | top users | synonyms (2)

0
votes
0answers
23 views

Google Spreadsheets “Share with others” notification popup

How can I disable or stop from appearing the “Share with user” popup? This notification appears each time I start my script and only on one user, which already confirmed the sharing invitation.
0
votes
0answers
39 views

Freezing formula values in Google Spreadsheets

I have a spreadsheet that will receive new values pulled from an email via Apps Script once a day. I'd like to be able to "log" certain values over a specific length by loading them into a new cell ...
2
votes
1answer
301 views

Google Sheets - how to VLOOKUP in a QUERY

I Have this sheet with raw data, basically names, dates, amounts of money and if they paid or not (this is the most important). What I am trying to do is to have in another sheet the same table but ...
-1
votes
1answer
125 views

Numeric before query, query results not a number

I have a column of values, let's say column A, that if I do =isnumber on any of the column data it returns TRUE. Now after I =query and select A, the query gives me the right values, but the type ...
1
vote
0answers
65 views

Help me check if this URL is ok to query with Google Chart

For the last couple of hours been trying to get this work. I setup a demo sheet with just two colums: Name Value A 22 B 33 C 44 D 12 And want to plot it. I put this URL into ...
0
votes
0answers
26 views

Query in google spreadsheets

I have the following problem: In Sheet2 I have some dates and names like: A B C D E F G .... March April May .... 1 2 3 4 5 .... 1 2 3 4 ...
1
vote
1answer
285 views

Auto increment ID in Google Forms

I am designing a Google Form for managing a congress registration process. I need to have a unique ID number for each registration and I found an answear here: Can I add an autoincrement field to a ...
3
votes
1answer
118 views

How to show “Last edited” date and user on Google Sheets?

I've got a Google sheet that is updated quite regularly by a few people. I'd like to be able to view the doc, and at a glance—have a cell that shows a date (last modified) and another cell (user that ...
1
vote
2answers
52 views

Google Spreadsheets: Using conditional formatting from date in another cell

I have two columns side by side containing dates. The dates in column A are based on when a project is due. The dates in column B are based on when a project is completed. What I want to do is show ...
0
votes
0answers
13 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
100 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
1answer
52 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
61 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
1answer
136 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
0answers
11 views

Detect column D changes with Google Apps Scripts

I would like to detect if the column D rows in my spreadsheet are becoming a date (at the beginning those column rows are empty), so if D1, D2, D3 become a date their text or colors should blink. Now ...
2
votes
1answer
2k 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
vote
1answer
125 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 ...
2
votes
1answer
64 views

Posting more than 2000 lines from IFTTT to a Google Spreadsheet

I have an IFTTT trigger set up whose action is to add a row to a Google Drive spreadsheet. Once the spreadsheet reaches 2000 rows, IFTTT creates a new document with the title: Document Title (1) ...
1
vote
0answers
25 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 ...
2
votes
2answers
50 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
vote
1answer
18 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
45 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 ...
4
votes
1answer
56 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
39 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
2answers
111 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
1answer
75 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, ...
3
votes
1answer
79 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
3answers
207 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
1answer
35 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
59 views

If condition won't work Google Spreadsheets [duplicate]

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?
2
votes
2answers
258 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
29 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
160 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
484 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
vote
1answer
46 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
168 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
70 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
52 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 ...
0
votes
0answers
21 views

capture & Log Range into new sheet on a weekly basis

I'm using =IMPORTHTML to import a set of values into a spreadsheet and I would like to have those values captured and stored in a different sheet once a week. I'm not all that familiar with scripts ...
3
votes
1answer
2k 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
208 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
1answer
56 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
30 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
1answer
148 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
107 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
120 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
36 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
62 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
705 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 ...
2
votes
1answer
52 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 ...