Part of the Google Docs suite, a web app that allows you to create and edit worksheets
4
votes
2answers
964 views
Creating an online form - by Importing the questions from a spreadsheet?
I've got a spreadsheet where each row of the first column is a question, and the next 4 columns are the optional 4 answers to that question.
I want to turn these questions into an online form (like ...
3
votes
2answers
320 views
Partial sum of columns based on row identifier
I have a spreadsheet with list of persons ("players"), and for a each person I have following values:
ID number (unique)
Name (just text)
Score from round 1
Score from round 2
...
Score from round ...
2
votes
2answers
199 views
Is there a way to link a “Choose from a list” style question in a Google Form to a list of data (e.g. in a spreadsheet)?
Would really appreciate some help from any experts in Google Forms.
Is there a way to link a "Choose from a list" style question in a form to a list of data (e.g. in a spreadsheet)?
This would mean ...
2
votes
2answers
313 views
Google spreadsheets editing of a VLOOKUP formula that references a pivot table
After inserting a vlookup formula in a Google spreadsheet, where the array parameter references acolumns of a pivot table, how do I edit the formula again?
When I enter the formula, it just displays ...
0
votes
2answers
61 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
2answers
153 views
Selecting Values from separate sheets and aggregating the results with google spreadsheet
I would like to use the query function to select values from two separate sheets add them together and do a less then comparison to another value. I have used named ranges for the data that I am ...
0
votes
2answers
784 views
Create a dropdown list of options from VLOOKUP
What I'd like to do is get a dropdown list of options from a VLOOKUP type function where I can select the value for the next lookup.
Example
Here the data I'm using for reference. Notice "AAA" ...
2
votes
1answer
174 views
Auto date insert when opposite cell is populated
I am creating a spreadsheet which will contain records of my daily expenditure. Something like the following:
A | B
----------
0 | 50.04
0 | 20.00
0 | 19.99
0 | 2.40
What I am trying to ...
2
votes
1answer
332 views
How to use a named column in a calculation based on a cell value in Google Spreadsheet
Playing with named ranges, I discovered it is possible to name a whole column (say "September") and use it in rows:
=September*K4
What I'm trying to achieve now is that the value of the column ...
2
votes
1answer
586 views
Google spreadsheet: box plots?
I want to create a simple boxplot from 1D data, which doesn't seem to be supported by the default Inesrt>Charts. There is a histogram gadget but I haven't seen any boxplot gadgets. Do I have to make ...
1
vote
1answer
30 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 ...
1
vote
1answer
22 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 ...
1
vote
1answer
36 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 ...
1
vote
1answer
38 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
1answer
138 views
Google spreadsheet: named range built upon formula
I have a list of items (cells A1 to A7) that are counted in cell B2 (whose value is currently 7), B2's formula is something like =COUNTA(A1:A10000).
That way if I add some value in cell A8, the count ...
1
vote
1answer
97 views
Count related to date items in a google Spreadsheet
I have a spreadsheet that shows how many are still completing a task at two and 8 weeks.
Col A Name
col B has Start a date
Col C is the WeekNumber of the date from col A (Using WeekNumber Script)
...
1
vote
1answer
129 views
google spreadsheet question about data linking between sheets
Here is my spreadsheet:
https://docs.google.com/spreadsheet/ccc?key=0AgmD6-Z4d2aVdE9pR095OTJrVE1wS3FIZzZpVFRJMmc#gid=4
What I want to happen is I enter data in the sheets marked Head, Neck, Shoulders ...
1
vote
1answer
520 views
How can I set conditional formatting on particular cells that depend on another cell's value in Google Spreadsheets?
I would like to colour the background of a row in Google Spreadsheets:
For example:
If cell Dx = title 'To do' or 'title 'Done' then cells Fx to Nx are filled colour black.
If cell Dx = title ...
1
vote
1answer
502 views
Is it possible to add conditional formatting when number changes?
This is probably not possible but...
I'm looking to update cells in a Google spreadsheet using the conditional formatting tool.(Changes to SERPs rankings)
So when the number in a cell is changed, ...
1
vote
1answer
111 views
How to search an embedded Google Spreadsheet in Google Sites?
I would like to know how I can make embedded spreadsheets searchable in Google Sites.
0
votes
1answer
13 views
In Google Drive, how to search something in a Spreadsheet while using Android Tablet?
I have a 1000 rows Google Spreadsheet in my Google Drive and using the Google Drive app on my Nexus tablet. I can't perform a search or use Ctrl+F option.
Any ideas or alternative ways to achieve ...
0
votes
1answer
34 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
1answer
23 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
1answer
61 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
1answer
36 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
1answer
37 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
1answer
180 views
Google spreadsheet connect with database and fetch data to cells
I have been wondering about this for a while. We are using those google spreadsheet a lot with my colleagues and the thing is that we always have to write down data that we already have in our MySQL ...
0
votes
1answer
83 views
Google Spreadsheet: FILTER(condition OR condition) syntax?
I am using FILTER() to display a value from Sheet 2 where the Name columns match.
My problem is where I want FILTER(Sheet2!A:F, Sheet2!A:A="Combat Medic" OR Sheet2!A:A="Universal"), as "OR" results ...
0
votes
1answer
204 views
Query multiple Google spreadsheets
I have the following sheets:
ListA
ListB
ListC
Note: at each sheet I have a column which contains YES or NO.
How do I query all my lists (spreadsheets) where myBooleanColumn equals to YES/NO?
0
votes
1answer
68 views
Avoiding duplicates when adding cells in column one by one in Google Spreadsheets
How can I have a kind warning if I am adding a text to the cell which was already added somewhere in previous cells of the same column?
0
votes
1answer
417 views
Google spreadsheet validation data empty cell
So i'm struggling with the following:
I have this formula (i know it's huge but it works so far :P)
=IF(AND(COUNTIF(basictier1;"*"&A4&"*"));"T1 Basic"; IF ...
-1
votes
1answer
52 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?
-1
votes
1answer
579 views
Simple row references in Google Spreadsheets and resorting data
This is my scenario
Users are entering data into rows with several columns
Last column is calculated on values of few previous columns (so it's row number independent).
While entering new and ...
