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

learn more… | top users | synonyms (1)

65
votes
6answers
150k views

How do I link a cell in Google Spreadsheets to a cell in another document?

I have a monthly spreadsheet that relies on figures from the previous month. I'd like to import these values dynamically rather than cutting and pasting them. Is this possible? How do I do it?
7
votes
2answers
12k views

How to Plot Time Series Graph in Google Spreadsheet?

I know it is possible to plot graph or chart in Google Spreadsheet. But the problem with current plotting way is that you can only specify the Y, but not the X. And as such, there is no way to plot a ...
3
votes
3answers
1k views

Where is a good tutorial to use Google Spreadsheets?

The help system of Google Spreadsheets is a bit short (to put it nicely). Are there any good tutorials / documentation to explain a non-Excel-savy user how the formulas work, how one should use them ...
2
votes
2answers
366 views

Is there a way to limit a column's data to a list in Google Spreadsheets?

I'm looking for a way to create a drop-down combobox for a column, so that it easier for data entry. I know about using a form, but are there any other ways to do this in spreadsheet view? For ...
26
votes
8answers
13k views

What limitations does Google Spreadsheets have in relation to Microsoft Excel [closed]

Office licenses are expensive. What features of Microsoft Office are missing from Google Spreadsheets that would be of value in ordinary personal or business use?
12
votes
4answers
3k views

Is there any way to script a Google Docs spreadsheet?

I have a really complex spreadsheet in Google Docs, and while it works, having the ability to script it a bit (à la VBA in Microsoft Office) would make it a lot cleaner. I heard that this is doable in ...
54
votes
4answers
87k views

Google Spreadsheets conditional formatting based on another cell's content

How can I set conditional formatting on a particular cell that depends on another cell's value? A | B 1 | x 2 | 3 | 1 | x 1 | x 4 | 8 | // X can be any value and is here merely to // mark the ...
28
votes
4answers
59k views

Google Spreadsheets ISEMPTY() formula function

Is there any way I can check whether a cell is empty? There is a function ISBLANK() but it returns false when there's a formula in a cell even thought the formula doesn't return anything (or an empty ...
3
votes
6answers
10k views

Google Spreadsheets function to find distance between cities

I'm working with Google Docs and want to create a spreadsheet of the following form: Point A Point B Mileage Los Angeles Miami 292100 Palo Alto San Francisco ...