Part of the Google Docs suite, a web app that allows you to create and edit worksheets
1
vote
1answer
24 views
How to count the occurrences of 'STRING' in a row, but only if that row begins with 'IFTEXT'
I have a sheet with employee time logs, as follows:
Name Day1 Day2 Subtotal of 'OFF' days this period
Jess PRESENT OFF 1
Bob PRESENT PRESENT 0
Name Day3 ...
0
votes
0answers
11 views
Link to a cell in a Google Spreadsheet via URL?
One can link to a google docs document via key and via key and worksheet id:
https://docs.google.com/spreadsheet/ccc?key=SOME_KEY
...
0
votes
0answers
11 views
Google Spreadsheet Form Responses in to an already made sheet
I have a template form and matching spreadsheet that need to be copied multiple times. When I make copies of the two, the copies are not linked for the form responses to go to the newly copied ...
1
vote
1answer
15 views
Using INDIRECT() in sheet reference range
I have a separate sheet with some data where a user's input will reference the row number of a sheet. I'm trying to reference that sheet by inserting the column letter and taking a number input from a ...
0
votes
0answers
16 views
How to set hot keys to a customized menu item in a Google Spreadsheet?
I am working with Google Spreadsheet APIs, and found that customized menu item is highly useful. I created some but am now wondering whether I can specify a hot key for each?
0
votes
0answers
14 views
How do I populate a cell in one spreadsheet to a cell in another spreadsheet in the same workbook in google docs?
In Google Spreadsheet, I have created a master spreadsheet that I complete with the amounts of the items needed. I would like those numbers to auto populate in each individual spreadsheet in the ...
0
votes
0answers
34 views
Download list of contact information and check if Google Account
I'm looking for a way I could:
retrieve a list of all my contacts and their email's and
In order to retrieve a list of all of my contacts into a Google spreadsheet, I exported them as a Google CSV ...
0
votes
1answer
31 views
Google spreadsheet multiple auto-sorting
In a Google Spreadsheet I have different group of cells to auto-sort ascending i.e.
table range a3:c16 columntosortby = 2
table range d18:f31
columntosortby = 5
table range g33:i46 columntosortby = ...
0
votes
0answers
30 views
how to put in a column how time person worked date by date per month
in this file i have in "foglio 2" column B every date worked for every person... i would like to take for every month the date the person worked. for example person "marco" and in "jauary" column ...
0
votes
1answer
19 views
Google Spreadsheets Filtering data in another page and changing data in the original
I have a lot of data that I need to filter. I did it in another page and that's good... but now I need to put some values in that page... and transfer that data to the original.
This is the formula ...
0
votes
0answers
20 views
Google Docs Changing the A B C-“Tabs” in Excel
The picture above is explaining. I'm looking for a way to change these " A B C " to a more describe way of what the content below is containing, etc A would contain what date, B is what length I run ...
0
votes
1answer
53 views
Google Spreadsheet: how to get value of cell by row key and column key
Suppose I have a workbook with two worksheets, data and view. data is structured in "database" style, i.e. with a single header row and unique keys in the first column, e.g.:
Country GDP ...
0
votes
0answers
24 views
Google Docs spreadsheets: how to specify entire sheet as range?
The best workaround I have found so far is:
worksheet_name!$A$1:$YY
but ideally I would like to be able to simply write, e.g.:
worksheet_name!
So, does anyone know: is there a syntax for ...
1
vote
1answer
32 views
How to have Google Spreadsheets automatically complete cells with previously used data
I'm using a Google Spreadsheet to fill in my mileage. Since I'm using many addresses more than once, I want to make the process of filling in easier by (like Excel or Open Office) having the ...
0
votes
0answers
37 views
copy google document table of contents links into google spreadsheet cells
I have a large google document where each table of contents item links to the header of a food recipe further down in the document.
How do I copy each TOC link+title into cells in a google ...
0
votes
0answers
27 views
Google drive spreadsheet refuses to leave out commas
On the spreadsheet in question there is a column that contains plain numbers in a particular sequence. As an example: 3040513, 3050513, 3060513 etc.
Sometimes when typing in the next sequenced number ...
0
votes
1answer
30 views
Google spreadsheet: Importing only certain rows
Regarding Google spreadsheets, document 1 has many rows of data. How do I import into document 2 only those rows that have a certain value in column C?
0
votes
1answer
35 views
Google Spreedsheet, Auto sort in categories
So I want to sort my Spreadsheet on Google but it remain in the Categories that it's laid out. I can get to it sort double columns but the categories get messed up as they move away from where they ...
0
votes
2answers
57 views
How to SUM() a column from one Google Spreadsheet in another spreadsheet
Has anyone been able to return the SUM() result of a column in one Google Spreadsheet to a different spreadsheet?
I am trying the ImportRange(key, criteria) but I am not having any success. I am just ...
0
votes
0answers
40 views
ARRAYFORMULA Using Row Above - Google Spreadsheet
I would like to create a column that contains a running decrementing tally, but is decremented by an amount from a different column on the same spreadsheet. Also, I would like to be able to add rows, ...
0
votes
1answer
28 views
autofill the 'Average' function in Google Spreadsheets
I have a column of data. Each cell in the column represents a new day. So the 1st cell is for the 1st day and the Nth cell is for the Nth day. I want to add a 2nd column where the Nth cell in that ...
0
votes
1answer
56 views
Google Spreadsheets mixing up x- and y-axis on line chart, no option to change it
For some reason Google Spreadsheet insists on using the data I wish to have for my x-axis as my y-axis. Here I'll show what happens when I try to use my data to form a chart, and what happens when I ...
2
votes
1answer
43 views
Compute average over month when measurement is irregular
I want to measure my power consumption. So once in a month I note my meter reading.
So I got the following data:
2012-12-01| 893.8| | |31
2013-01-05| 977.2|34|2.45|31
...
0
votes
1answer
34 views
How to get the Elapsed time of two cells hh:mm in Google Spreadsheet
In columns K and L I have time stamps.
Let's say 03:30 is in column K and 04:30 is in column L.
I want the total elapsed amount of time in hh:mm in column P.
I have tried the average function, ...
0
votes
0answers
54 views
IMPORTRANGE formula query per query in another file
Is it possible to create two different file where in the first i put the data and in the second the references query?? i used the IMPORTRANGE but this method gives me "=CONTINUE(A1; 2; 1)"... I want ...
1
vote
1answer
37 views
Summing a column based on another column in Google Spreadsheet
I have the following data in a Google Spreadsheet:
+------+---------+
| Time | Include |
+------+---------+
| 0:30 | No |
| 1:00 | Yes |
| 0:30 | Yes |
| 0:30 | No |
| 0:30 | Yes ...
1
vote
0answers
31 views
Looping through the range of cells to test the dates
I am trying to create a function to check the dates in 'Dt' sheet and return Match or Not Match.
It works fine with when I display my answer in MsgBox, but when I try to do it in one of the ...
3
votes
1answer
40 views
How to report which checkboxes were left unchecked on a Google Forms submission?
I have a Google form that stores its responses in a Google spreadsheet. It's set up so that whenever someone submits the form, I receive an email report of the responses. There are many places in the ...
3
votes
1answer
70 views
Conditionally format by day of the week
How can I conditionally format cells in Google spreadsheets containing dates to have a different background according to the day of the week, e.g highlight the Saturdays and Sundays in a column ...
3
votes
2answers
54 views
How to sort a sheet in Google Spreadsheet by multiple columns?
Having a table with data like:
- + + -
- - - -
+ + - -
where + and - are created via '-, '+ commands, How to sort it recursively (probably other word shall be used) meaning sort ...
2
votes
1answer
126 views
Conditional formatting based on cell values in same column
In Google Spreadsheet, how do I change a cell's background color to red if the date in the cell matches the date in another cell in the same column? Column E in my spreadsheet is a list of due dates ...
2
votes
0answers
47 views
How to do a date formula in Google Spreadsheets
I have to do a query that increments automatically the date year by year. For example I use this formula:
=INDEX(query('Scheda Intervento'!C3:K14;"select sum (K) where (F >= date '2013-01-01' ...
1
vote
1answer
62 views
Stop content from making cell two lines
In Excel if you have a long piece of text like a URL in a cell you can stop the cell from becoming a double-line cell and messing up the rest of your layout.
It does this by just clipping the info ...
1
vote
0answers
69 views
how to make Google Docs spreadsheet recognize data as numeric
I have the opposite of a fairly standard problem -- how do I force Google Docs spreadsheet to understand that a value is numeric?
It seemed like using Format > Number should do the right thing, but ...
1
vote
1answer
50 views
Problem QUERY function in Google Spreadsheets formula
I tried this formula:
=concatenate(query('Scheda Intervento'!C2:K14;"select SUM (K) where (F>= date '2013-01-01' and F <= date '2013-01-31' and C = '" & A2 &"')";0))
The result is ...
1
vote
1answer
47 views
Iterated variable (i) for argument on range in Google Scripts API
for (i=0; i<numItems; i++) {
var cell = sheet.getRange(12,i);
cell.setFormula(i);
}
This simple formula should go to every place on the column 12 where there is data, and replace it ...
1
vote
1answer
23 views
Share individual copies of a Google spreadsheet
I created a Google Spreadsheet file which I want to share with my coworkers so each one has his own copy. So far the only way I found is to share the file, however these doesn't work for me because ...
2
votes
1answer
71 views
“Yes” if a value partially matches in a range of values, blank otherwise
I have a column of values (column A for this example) like such:
Phytophora sojae
Phytophora ramorum
Cryptococcus neoformans
Coccidioides posadasii
And I'd like to create a new formula column (B) ...
-1
votes
1answer
49 views
How to use multi-line text in Google Spreadsheet?
When I try to enter multi-line text, I see void cell as fast as I leave a cell. How can I overcome this?
2
votes
1answer
50 views
Google Spreadsheet Sort Two Columns
So I've found the following answer in regards to auto-sorting by one column, which works great
How can I make some data on a Google Spreadsheet auto-sorting?
However, my use case requires the sorting ...
1
vote
0answers
43 views
delay in updating referenced cells when using importrange in google drive
Im using the importrange() function in Google drive to reference data from 'spreadsheet1' and display in it 'spreadsheet2'.
This works fine, but 'spreadsheet1' and then go to 'spreadsheet2' its not ...
0
votes
0answers
35 views
Copying cells in Google Spreadsheets and pasting into text file adds quotes around each cell
Copying cells in Google Spreadsheets and pasting into text file (tried with XCode, Notes, Text Edit - the below applies to all) adds quotes around each cell.
How can I avoid those extra quotes? Also, ...
0
votes
0answers
18 views
lock sheet from external viewers but let the view the rest of the spreadsheet - google docs
Ive got a multi sheet, spreadsheet that i want to give out to clients so that they can write in their comment directly into my spreadsheet.
There is nothing i don't want them see in the spreadsheet, ...
0
votes
1answer
137 views
Reference data from another 'spreadsheet' in google docs / drive [duplicate]
Is there a way i can reference data from another google spreadsheet in google docs / drive ?
ie. spreadsheet-A, sheet 1, column A is a dynamic reference of spreadsheet-B, sheet 1, column E
Im not ...
3
votes
2answers
54 views
How to count entries based on timestamp
I'm trying to count how many entries with a particular timestamp or range are in my table and although it’s pretty simple, I cannot find the proper way to do that.
Example data:
A
...
2
votes
1answer
60 views
How do I reference multiple cells in one sheet in one cell in another sheet?
I am using Google Sheets and I have two sheets in one document (SHEET1 and SHEET2). I want to be able to use a formula that allows me to:
If cell A1, B1, D1 and F1 in SHEET1 have an s in them
Then ...
0
votes
1answer
57 views
How to apply formula to WHOLE column and automatically add this formula to new created rows in this column?
I need some kind of "autoincrement field" in my spreadsheet. I've added =ROW() formula to first column. But as I'm adding new rows - I have to apply this formula to new created rows as well. Is there ...
1
vote
2answers
91 views
Google Spreadsheets formula question: do not include cell in a formula if blank
I am a music teacher and I use the following formula to calculate my students performance grades:
=100-SUM(F3-5)*-7
How can I change the formula so it only calculates a grade if there is data in ...
0
votes
2answers
83 views
display google docs spreadsheet in mobile mode in desktop browser
When viewing a google docs spreadsheet in a mobile browser you have handy filter buttons at the top. How do I display mobile version of the page in a desktop browser? Preferrably Firefox. Edit: I seek ...
1
vote
0answers
27 views
Question about pulling multiple numbers from a single cell
I'm trying to cut down on the number of columns my spreadsheet has, to made it easier to pull data from, and to make the general appearance better.
What I'm trying to do is put two numbers in a ...
