Part of the Google Docs suite, a web app that allows you to create and edit worksheets
0
votes
1answer
31 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
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 ...
8
votes
3answers
2k views
Google Docs Spreadsheet - Multiuser filter issue
When two or more users view the same Google Docs spreadsheet and one of them filters the data by a column, that filter is immediately applied for the other users as well.
Is there a way to avoid this ...
3
votes
3answers
3k views
How to set a Google Docs Spreadsheet cell format to bare text?
I am to store an international standard phone numbers (starting with a plus sign followed, usually, by plain numbers) in a Google spreadsheet column. An example of such a phone is
+420123456789
...
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
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
...
7
votes
3answers
13k views
How can I make some data on a Google Spreadsheet auto-sorting?
Let's say I want Google Doc to automagically sort some data, for example Coloumn C. How do I do that?
I know that I can manually sort data by right-clicking and selecting "sort data", but this is not ...
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
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 ...
0
votes
2answers
147 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 ...
12
votes
8answers
15k views
Is there any way to create a timestamp in a Google Spreadsheet?
I use PSPad as a text editor, which allows you to press Alt + D to insert a timestamp, e.g.:
2010-07-17 23:45:44
Is there a way to do this in a Google Spreadsheet?
3
votes
1answer
446 views
Auto create and name new sheet in Google Spreadsheet
How can I automatically create and name new sheets in a google spreadsheet from a list of names, such as a student roll sheet? I would like each new sheet to be created when I add corresponding names ...
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
2answers
535 views
Google Docs Spreadsheet ImportHtml() with Basic Auth
Within a Google Docs spreadsheet, I need to access external data that requires basic authentication. Usually I would include external data by putting this in a cell:
...
2
votes
1answer
576 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 ...
2
votes
1answer
164 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 ...
1
vote
1answer
129 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 ...
0
votes
1answer
32 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
61 views
Google spreadsheet revision history — too much detail
For word processing, Google Docs revision history is great.
However, for some of my spreadsheets, something isn't working right:
Revisions are not grouped together, multiple for each minute.
"Show ...
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 ...
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
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
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 ...
1
vote
1answer
860 views
Repeat last action Google Spreadsheets
I want to know if there is a shortcut in Google Docs Spreadsheets for repeating the last action, like F4 in MS Office.
I found that there was no shortcut for this on Google Forums but the post were ...
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 ...
2
votes
2answers
540 views
Google Spreadsheets URL Syntax and Display Options?
I recently came across a Google Spreadsheet that had a slightly different syntax in the URL. I found these tags after the Spreadsheet Key:
...
0
votes
1answer
165 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
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
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?
7
votes
2answers
14k views
Link to specific sheet in Google spreadsheet
I have a complicated Google spreadsheet with many sheets and a table of contents. Is there some way to create a link to the sheet names so that with a click one can go directly to the sheet? That is: ...
2
votes
2answers
184 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 ...
9
votes
2answers
15k views
Is it possible to add a checkbox/button equivalent to a Google Docs spreadsheet?
I know there's no checkbox functionality in a Google Docs spreadsheet but I was wondering if there's a way to get equivalent functionality somehow. What I'm looking for is a one click enable/disable ...
1
vote
0answers
108 views
Google Drive Form doesn't display on Google sites if not signed in on chrome
I have a site, hosted by google sites that includes a Spreadsheet Form from google drive.
Normally, the page loads, then a second or so later the form loads.
In the problem case the page loads, but ...
1
vote
1answer
110 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.
2
votes
1answer
64 views
Exclude cell from sum in Google Spreadsheet
I am using my Google Spreadsheet to keep tabs of my incomming and outgoing money. I've made a row with ~19 cells in it, in those 19 cells I have the monthly what comes in and what goes out. At the end ...
5
votes
3answers
5k views
Adding a datepicker in Google Spreadsheet
Is it possible to insert a datepicker in every cell of a column in Google Spreadsheet so that anyone can click (with a single click) on that cell and get a datepicker calendar to select a date?
2
votes
1answer
67 views
How to check if value is in range of cells?
I want to check if the value of a cell exists in a range of cells. How can I do this?
Just like you would be able to do "if value in list_of_values" in Python for example.
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 ...
1
vote
1answer
513 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 ...
2
votes
1answer
79 views
How get last added text from column into different sheet
How can I get the last added plain text from a column in sheet1, which also has empty rows, into a cell of a sheet2?
With help I managed to do this with the last added date, but with plain text I am ...
2
votes
3answers
629 views
COUNTIF but when multiple conditions are met
I'm trying to create a GDocs spreadsheet to collate data from a survey. I'm fairly new to the advanced features of GDocs/Excel but here's what I'd like to achieve. I've tried Googling but it's a tough ...
1
vote
1answer
128 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 ...
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
57 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
2answers
3k views
How can I automatically set “last updated” cell in row Google Docs Spreadsheets?
How can I automatically set "last updated" cell in row Google Docs Spreadsheets ?
I want to create a column where the cells' value will be automatically set to when that row was last amended. Is this ...
2
votes
1answer
185 views
Calculate monthly sum() on pivote table
I have a Google Form. Upon submit following fields are populated:
Timestamp
Product Description
Unit Price
Quanitity
I have generated a pivot table from this data, in a Google Spreadsheet. The ...
