Tagged Questions

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

learn more… | top users | synonyms (1)

3
votes
1answer
2k views

Figuring out who is the owner of a Google Spreadsheets form

I have noticed that Google spreadsheet form's have URLs in the form of http://spreadsheets.google.com/viewform?formkey=.... I don't see anything that relates to the Google account in the URL. There ...
3
votes
2answers
690 views

Graphs with Google Spreadsheets - collapse data into one 'category'

I have a set of data which is similar to the following: Groceries 5.00 Groceries 14.75 Groceries 6.37 Dinner Out 43.50 Dinner Out 15.00 I'd like to be able to use this data to ...
5
votes
4answers
2k 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 ...
2
votes
3answers
804 views

Calculated range based upon some criteria

Given this layout: +--------+ +--------+ | A | B | | A | B | +----+---+ +----+---+ | 1 | | | 1 | 6 | | 2 | | | 2 | | | 3 | | => | 3 | | | | | ...
10
votes
6answers
18k views

Google Docs Time report - How to add hours?

I use a Google Docs spreadsheet to keep track of the time I spend on projects. It's formatted in 3 columns: the time I started, the time I finished, and the total hours spent for that session ...
6
votes
2answers
3k views

How can I change the input format for dates in Google Docs' spreadsheet?

The input string for dates in Google Docs's spreadsheet app seems to be set to en_US, which is quite unnatural to me. How can I change the input format?
2
votes
1answer
942 views

Google Spreadsheets Enter/Return Key Behavior

In Microsoft Excel, the default behavior of pressing the Enter (return) key is this: If you are in a cell, and tab over as you input data, at the end of the series when you click Enter, the ...
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
30k 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
137k 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
353 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
55k 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 ...