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

learn more… | top users | synonyms (1)

4
votes
2answers
1k views

Plot Multiple Graph in Google Spreadsheet

I know how to plot a graph in google spreadsheet. But how to plot multiple graphs, with different X and Y values in Google Spreadsheet?
4
votes
4answers
3k views

Is there a way to link E-mails from Google Docs/Spreadsheets?

I'm trying to find a way to link to an e-mail from my Google Spreadsheet. We use our spreadsheet as a way to track bugs, issues, to-dos, and milestone timelines (we've tried other apps, this works ...
5
votes
4answers
14k views

How do I make a field display a calendar for picking a date

Previously, in Google Spreadsheet, I've seen date fields that, when clicked on, display a calender for selecting a date. How can I reproduce this?
14
votes
8answers
29k 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?
7
votes
5answers
343 views

Web apps for managing financial portfolios [closed]

I've been looking for a decent online portfolio manager for a while and not found anything. I'd like something that: Is UK based, i.e. can price in GBP and can get UK fund prices Can access a large ...
27
votes
2answers
16k views

Embed Google Spreadsheet in Google Document

Is it possible to embed a Google Spreadsheet into a Google Document à la Microsoft Excel and Microsoft Word? How about a chart from a Spreadsheet?
3
votes
2answers
788 views

No force-reload tip on google spreadsheets?

So I'm running nightly tasks to generate some custom stats for my site and copy the stats in csv format to separate server via scp. Then I use these csv files in google spreadsheets to display them in ...
2
votes
1answer
7k views

Take SUM of colored cells in a column in Google Spreadsheets?

I have a column of numbers, where I've changed the background color of some of the cells to blue. All of the other cells in the column have the regular white background. Is it possible to create a ...
61
votes
6answers
136k 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?
6
votes
2answers
11k 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
352 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 ...
52
votes
4answers
83k 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
3answers
54k 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
9k 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 ...