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

learn more… | top users | synonyms (1)

6
votes
2answers
15k views

How to easily select multiple cells in Google Spreadsheets?

How do I select multiple cells in Google Spreadsheets (non related cells, other cells between them)? In MS Excel I just press Ctrl and click on all the cells, in Google Spreadsheets it doesn't work. ...
2
votes
1answer
751 views

Google Apps Script - Want to email specific spreadsheet row data on event

Scenario Basic support ticket clone: Users submit a form (e.g. answering fault reporting questions) Data is obviously stored as rows in the corresponding spreadsheet I've added an onEvent trigger ...
2
votes
5answers
2k views

Importing responses into a Google Docs Form (spreadsheet)

I have some Google Docs Forms and I would like to import legacy survery data into the responses spreadsheet, so as to benefit from the data presentation features (having the combined data set) but ...
1
vote
0answers
208 views

how to input a date into a Google spreadsheet cell and have the item show up in Google calendar [closed]

I'm building a To-Do list in a Google spreadsheet. I'd like to add a date, such as a due date, to a Google spreadsheet cell and have the due date auto-magically show up in my Google calendar. ...
6
votes
1answer
4k views

Add average line to scatter graph in Google Spreadsheet

I have the following scatter plot in Google Spreadsheet, and I would like to add a line that averages all my points. Can I do that? And if yes how?
22
votes
6answers
32k views

Alternating colors for lines in Google docs spreadsheet

I have a shared Google spreadsheet where several users have already filled out parts. It would be useful to have alternately colored lines to facilitate correct placement of additional data. Is ...
3
votes
1answer
4k views

How can I highlight selected text in a cell and not the whole cell? [duplicate]

In my Google Spreadsheet, I have a lot of text in a cell and want to highlight a small portion of this text with a particular colour. But, whenever I try to do this, the formatting gets applied to ...
0
votes
2answers
1k views

Editable google spreadsheet on Google site - assign username

So here is what I am trying to do: Have a Google site that has an embedded editable Google spreadsheet on that allows end users (if they have been given permission) to edit the spreadsheet. Here is ...
3
votes
1answer
14k views

'Lock' part of formula when copying from one cell to another

I have the following formula in a Google Spreadsheet: =IF(I11="VSS";G11;IF(I11="MCS";0;G11*Totais!C30)) I would like to freeze Totais!C30 when I click on bottom right of cell and drag down. ...
3
votes
1answer
2k views

Can we do a link between two Google Docs spreadsheets?

I want to make a link between two spreadsheets, like if I click on a code in a cell, it opens the spreadsheet which the code refers/links to.
0
votes
2answers
2k views

Sum of numerical values excluding formulas in a Google Spreadsheet

I have a long column of numbers in Google Spreadsheet, and occasionally there exists a cell that sums some of the cells below it. For example: =SUM(2:4) 5 10 30 =SUM(6:8) 40 10 10 ...
1
vote
2answers
4k views

Pasting text with line breaks into Google Spreadsheets creates multiple cells

If I copy text with a line break in it, like this... 1st line 2nd line ...and then paste in into a Google Docs spreadsheet cell, then it pastes '2nd line' into the cell below. What are the easiest ...
2
votes
2answers
548 views

Allow users to use my online spreadsheet in Google Docs without saving their edits

I made an online spreadsheet in to calculate grades. I want my users to use it without Google Docs showing it real-time to other users. How do I do this? It seems if I allow people to edit the ...
2
votes
1answer
2k views

How to escape a double-quote in a TSV file for import into a GoogleDocs spreadsheet?

How does one specify a cell to contain exactly one double-quote character in a TSV file so that it will be handled correctly when imported (as a spreadsheet) into GoogleDocs? (Note: when importing ...
1
vote
1answer
167 views

How do I get the unique number of days in a datetime column in Google Spreadsheets?

I have a column full of datetime values in a Google Spreadsheet. I want to get a count of how many unique days there are. As in 8pm and 7pm today would count as 1. Tomorrow at 9pm, 3pm and 4pm would ...
3
votes
2answers
2k views

share certain columns

I have a form that gets filled. This obviously goes into Google Spreadsheets. I want a summery of this information to be publicly viewed. Kind of like the summery page in sheets but I want only ...
1
vote
1answer
1k views

How can I make some data on a Google Spreadsheet auto-sorting using onOpen?

I was working with @W0lf here but I am unable to comment/continue the conversation anymore. I am trying to use autosort function onOpen but is not working: function onOpen(event) { var ss = ...
0
votes
1answer
339 views

Working with names in Google Docs Spreadsheet

I have created a spreadsheet to keep track of my players on my team, I would like to sum all of their individual times playing regardless of who they played (different players). Is this possible? ...
3
votes
1answer
387 views

Having units in Google Spreadsheets?

I want to be able to input plain numbers like 200, or 3000 and have the cell display 200g, 3kg, etc... But still be able to add the values in the cells. So if I add the two above I'd get 3.2kg on the ...
4
votes
2answers
4k views

Google Docs speadsheet auto-fill: control what increments [duplicate]

Possible Duplicate: 'Lock' part of formula when copying from one cell to another Is there a way to control which variables in a formula get incremented when you use auto-fill in a ...
0
votes
2answers
3k views

Format a date fetched from another cell for display using concatenate

Given say 2 different dates in A1 and B1, what I want to do is just show the range of dates as a label in A2 by using =concatenate(A1, " - ", A2) However, A1 is in the default format (MM/DD/YYYY) and ...
0
votes
2answers
819 views

Is there a limit on functions in Google Spreadsheets?

As to answer a question on SuperUser, I was making a sample spreadsheet on google docs. Now I made it first in Excel 2010 on my computer to copy/paste it later on. When I tried to copy a formula that ...
7
votes
4answers
5k views

Google Spreadsheet: sum values with same name

I have a google spreadsheet with a long list of names and amounts. Many of the names are duplicates. For example John | 10 Bill | 2 Susan | 3 Frank | 4 Sally | 10 John | 2 Susan | 2 John | 3 Is ...
1
vote
1answer
503 views

How come I can't input a formula into my Google Spreadsheet?

Here are my steps: focus a cell in my Google Spreadsheet, hit = and then highlight the field D3, hit +, highlight the field D4, hit +, highlight the field D5, hit Enter. However, the field just ...
2
votes
1answer
4k views

JOIN formula in Google Spreadsheets

I want to use the JOIN formula in Google Spreadsheets to transform all values in one column into a list, with , around each value. Has anyone used this formula before? The only information I can ...
0
votes
1answer
1k views

Change all values of a column at once in Google Docs

How can I change all values of column A (currently empty) to be 5? In Excel, I could do Paste Special > Multiply. Is it possible in Google Docs?
2
votes
1answer
3k views

How do I remove the '0' from a field with an equation?

I have a Google Spreadsheet that I enter in new values everyday and want to have the equation run down the entire column so I don't have to drag the previous day's box down to copy the info. It would ...
1
vote
1answer
568 views

Sorting Unique rows by a related Sumif column in Google Spreadsheet

I am putting together a worksheet to keep track of expenses. I currently have the following source table called "Expenses": A B C D 1 Date Description ...
4
votes
3answers
14k views

Advanced date logic in Google Spreadsheets

I have the folowing situation: Today is 4/9/12. I have a cell with a date in the sheet that is 4/13/12. This cell should turn red since it is within 7 days from the current date. What is a ...
0
votes
1answer
498 views

How to reference Google spreadsheet inside your mail message?

I would like to embed a Google spreadsheet directly into my email, so that it reflects the document changes. How do I do that?
27
votes
1answer
35k views

How does one add a new line in a cell in a Google Spreadsheet?

I pressed return to make a new line in a cell of my Google Spreadsheet. That just moved the cursor to the next cell. How does one add a new line in a cell?
1
vote
3answers
3k views

Is there a way to generate number of days in a month in Google Docs Spreadsheet?

The title kind of says it all but just to give you the use case, I have a spreadsheet where I track monthly ad revenue and want to end up with a daily revenue column. Here's a simplified example of ...
3
votes
2answers
2k views

A Way to Add Text Before Your Hyperlink in Google Spreadsheets?

Is there a way to add text before the hyperlink? So for example: This section needs reworking. You can find the section HERE. HERE would be the text replacement for the actual link. The actual ...
16
votes
2answers
43k 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: ...
4
votes
1answer
1k views

Normalizing and grouping dates in Google Spreadsheet

I have a spreadsheet pulling together various readings taken of hours heater has run, electricity units use for that period, and outside temperature. For the last 3 months, the electricity usage and ...
2
votes
1answer
531 views

Send Google spreadsheet with embedded HTML in Gmail

When I try to publish content from Google Spreadsheet, it puts it into an HTML iframe. This is found under File > Publish to Web. How can I send this iframe content in a mail, sent over Gmail?
1
vote
1answer
3k views

Copying email addresses from Excel to Gmail into the BCC line

I used to be able to copy a column of email addresses (with a comma at the end of each) from Excel into the BCC line of a Gmail message. Now when I try to copy the column of emails, only the first ...
2
votes
2answers
848 views

How to write a logical function that checks several columns and rows

I have three columns in my Google Spreadsheet: C (Dialog) - D (Declined) - E(Answered) All the columns are dates. Example: C D E 14/02/2012 28/02/2012 ...
2
votes
1answer
4k views

Hyperlink within a Google Spreadsheet?

I have a Google spreadsheet with many tabs. I would like to put a link in a cell on one tab that when clicked take me to another cell on another tab. Is this possible?
1
vote
1answer
566 views

How to put the name of a cell into another cell in Google Spreadsheet

In Google Docs Spreadsheet, is there a simpler way to put the name of a cell reference into another cell than this? =concatenate(char(code("A")+COLUMN(D3)-1),row(D3))
5
votes
1answer
4k views

Refer to Sheet with value in Cell?

The usual way to reference a sheet is here but how do you reference a sheet when the sheet's name is a value in a cell? For example, A1 = "Sheet number two" B1 = A1&"!B4" Here I want B1 to ...
1
vote
2answers
1k views

Return an Offset Cell Value, Where Last Occurrence in Range is Matched

I have a worksheet like this: || A | B | C | ---++--------+-------+-----| ---++--------+-------+-----| 1 || 1 | a | | 2 || 2 | b | | 3 || 3 | X ...
4
votes
1answer
694 views

How do you conditionally join text in Google Sheets?

So, I thought this would be relatively straightforward for an advanced user, but this one is troubling my brain. I have a schedule of people: 1 2 3 4 5 6 7 8 John D. a a ...
5
votes
2answers
3k views

Downloading charts from Google Spreadsheets in high resolution

I have a Google spreadsheet with data from which I've created a few charts using the built-in charting tool. Now, I'd like to download these charts in a format I can use in a PDF document I create ...
5
votes
5answers
14k views

How to make a query with Google Spreadsheet, that checks for a date

I have a range that goes from B4:H124. All the cells in column B are dates. I would like to retrieve the data from a row (B:H), where the DATE equals to the content of a specific cell, lets say Q4. ...
2
votes
2answers
1k views

How to count cells that are below a certain date and check if other cells in the current row are empty?

I need to count how many cells in a specific column are below a certain date. Also, at the same time, the counter should only be increased, if some other cells next to each cell being counted are ...
5
votes
4answers
6k views

How to export a filtered set of rows from a Google Spreadsheet?

Is it possible, when exporting a Google Spreadsheet into a CSV, to apply this operation only to filtered set of rows? I need to get in CSV exactly the rows which are visible on the sheet after a ...
1
vote
1answer
2k views

How to query for count of dates in Google Docs?

I have a Google Spreadsheet of line items. One of the columns is a Date field. How can I query (or use a formula) to, for example, get the count of records where the Date field is within February of ...
7
votes
3answers
10k views

How to sum ​​values ​​in a range of dates

I have a Google Spreadsheet in the format below — here's an example. Column A → Dates Column B → Numbers I'd like to sum values ​​in column B in a range of dates in column A. Example: Sum ...
5
votes
1answer
3k views

How do I create a box plot chart in Google spreadsheet?

I want to create a simple boxplot from 1D data, which doesn't seem to be supported by the default Insert → Charts. There is a histogram gadget but I haven't seen any boxplot gadgets. Do I have ...