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

learn more… | top users | synonyms (2)

1
vote
1answer
622 views

Embed only cells from Google Spreadsheet and not application header

When I embed a Google spreadsheet, I get cells in my page (and this is good). But I get also the application header with toolbars (and this is bad for me). See a test here: ...
2
votes
0answers
318 views

Qualtrics + Google Spreadsheet integration

I'm looking for a way to use a Qualtrics survey as a data source for a Google spreadsheet. My client wants a google spreadsheet that automatically updates based on the latest survey results. I've ...
2
votes
0answers
330 views

Google Spreadsheet - Timetable? [closed]

I'm trying to use Google Spreeadsheets as a time report tool where I insert the number of hours worked on a project, the cost per hour & the total cost for this post. My sheet looks like this: ...
3
votes
2answers
650 views

Partial sum of columns based on row identifier

I have a spreadsheet with list of persons ("players"), and for a each person I have following values: ID number (unique) Name (just text) Score from round 1 Score from round 2 ... Score from round ...
4
votes
1answer
721 views

How do I sum different currencies in Google Spreadsheets

I have a spreadsheet where some columns are formatted in EUR, and some in USD. I would like to be able to sum them by taking into consideration the exchange rate Example: A1 = $10, A2 = €10 A3 = A1 ...
4
votes
4answers
3k views

Paste numbers as string in Google Spreadsheet

I have one spreadsheet in Google Docs with data like: 0012 0234 0065 I wanna paste in another Google Doc Spreadsheet but when I use ctrl+c ctrl+v the data is formatted like numbers: 12 234 65 I ...
4
votes
2answers
2k views

Keyboard shortcut to open a drop-down list for cell values in Google Docs spreadsheets

I'm working in a Google Docs spreadsheet where I've set up validation lists for a column. When I tab into that column as I'm editing a row, the drop-down handle appears: In order to access values ...
2
votes
1answer
4k views

Google Spreadsheet column limit [closed]

I'm working on a Google Spreadsheet and I keep getting this message: This spreadsheet is about to reach the following limits: Number of Columns Google Docs Help says that the columns limit is of ...
0
votes
3answers
4k views

Protect entire column of a Google Docs spreadsheet

I select a column (e.g. Sheet1!A:A) to be protected, then in the right pane I edit the settings (name, permissions), and finally I click Done What happens: The protected range then switches to ...
9
votes
2answers
7k views

Google Spreadsheets: format cells as plain text [duplicate]

I'm gathering some data in a Google Spreadsheet, there's a column for phone numbers and when trying to enter a phone number (e.g., +54 11 4785 7992) the spreadsheet automatically tries to make a ...
7
votes
3answers
4k views

Repeat last action in 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 ...
2
votes
1answer
962 views

Is it possible to add conditional formatting when number changes?

This is probably not possible but... I'm looking to update cells in a Google spreadsheet using the conditional formatting tool.(Changes to SERPs rankings) So when the number in a cell is changed, ...
1
vote
1answer
470 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.
1
vote
1answer
857 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?
-1
votes
1answer
974 views

Google spreadsheet validation data empty cell

So I'm struggling with the following: I have this formula (I know it's huge but it works so far) =IF(AND(COUNTIF(basictier1;"*"&A4&"*"));"T1 Basic"; IF ...
4
votes
1answer
5k views

Cell row reference coming from another cell in Google Docs

I need to make google docs evoke the row number for a cell reference by pointing to another cell. Allow me to explain: I have a form with different cells that point to another sheet (Sheet1!). All ...
0
votes
1answer
3k views

Insert copied cells in Google Spreadsheets

I'd like to shift a set of cells downward from a selection in Google Spreadsheets. Ideally "insert copied cells" from Excel, but I can live with just the shift part, i.e. insert blank cells, shifting ...
3
votes
2answers
3k views

Parsing timestamp in Google spreadsheet with script

I have a spreadsheet with a form that timestamps every time the form is submitted. I'm writing a script to change the background color of the timestamped cell if it is more than 7 minutes after a ...
0
votes
2answers
549 views

How can I link to a cell in Google Spreadsheets?

I have a headings and every time I have to scroll down to the cell I need. Can I create some kind of "header" on the top of the page and just click on the header I want and it will automatically ...
3
votes
2answers
10k views

SUMIF date range and filter by value on Google Spreadsheet

How do I SUMIF two date ranges and filter with a value? The date range formula I've been using is: =sumif($A:$A,"<="&D$5,$C:$C)-sumif($A:$A,"<"&D$4,$C:$C) Which works great for ...
3
votes
1answer
2k views

How to select weekdays only in a Google spreadsheet?

I have a table with two columns: column A has dates, column B has data. I want to compute the average of the data in B that corresponds to only week (work) days. How can I write it as a formula?
0
votes
1answer
1k views

How do I make a cell highlighted if the date in the cell is today in Google Spreadsheets? [duplicate]

Possible Duplicate: Advanced date logic in Google Spreadsheets Here's the problem. I have a spreadsheet with many consecutive days. So Cell1 = 7/30/2012, Cell2 = 7/31/2012 etc. I want Cell1 ...
1
vote
0answers
160 views

How to graph one column against another from multiple sheets in Google Spreadsheets?

I have a spreadsheet here: graph with one column against another from multiple sheets I want to graph the ascent columns against the distance for each of the three tabs on the graph. How can I make ...
2
votes
1answer
1k views

Transfer cell value to another cell by clicking on a button in Google Spreadsheet

I want a user to be able to click on a button and have the value of one cell go into another cell. How can I do this?
2
votes
1answer
3k views

How to Send Html Emails in Google Spreadsheet

Here's an example of a Google Docs Spreadsheet script that sends emails using Google spreadsheets. I want the email Sent in HTML not plain text. Can someone help me out? function sendEmails() { var ...
6
votes
2answers
8k views

How to Refresh a cell in Google Spreadsheet?

I have a column in Google Spreadsheet that calls an outside webservice using URLFetch in a Google Script. The cell uses two parameters in that cell's row. After a change occurs where those two ...
2
votes
1answer
889 views

Daily calculation and record insertion in Google Spreadsheet

I have a Google Spreadsheet that I am using to checkout last prices or levels of certain stock indices's. I have two worksheets in the workbook, one contains the indices's and a calculation I am ...
0
votes
1answer
601 views

Referencing a cell range relative to the bottom of a sheet

I am developing a "Daily Personal Inventory" spreadsheet based off a related Lifehacker article. I've successfully made a few modifications based on my own circumstances/goals, but there is one ...
1
vote
2answers
1k views

Create a dropdown list of options from VLOOKUP

What I'd like to do is get a dropdown list of options from a VLOOKUP type function where I can select the value for the next lookup. Example Here the data I'm using for reference. Notice "AAA" ...
2
votes
1answer
877 views

How can I comment several dozen cells in a Google Spreadsheet using data from cells?

I want to turn some long-winded strings into comments on 9 sets of 96 cells so they're just visible on mouse-over. How can I do this without manually going to Insert Comment and copy-pasting 864 ...
2
votes
3answers
2k views

Google Docs - a formula that does Excel “countifs” function involving dates

I have a Google spreadsheet in which multiple users are tracking a list of dates and class names (math, reading, writing, etc). On a separate sheet in the same document, I want to be able to give a ...
3
votes
3answers
8k views

Google Spreadsheets: Add 3 hours to Date value (DD/MM/YYYY 00:00:00)

I have cells with dates in this format: DD/MM/YYYY 00:00:00 and I want to add 3 hours because I'm in a different GMT zone. Is possible to use dates in a formula? Something like: 30/12/2012 22:15:00 ...
1
vote
1answer
794 views

Make new responses appear as a row at the top of a Google Spreadsheet

I made a web form based off of a Google spreadsheet. New responses currently manifest as new rows on the bottom of the spreadsheet. There is a "Timestamp" column marking the time of submission. How ...
1
vote
1answer
2k views

Nested IF statement on Google Spreadsheet, second part same as the first

I have a spreadsheet for my budget. Payments are either drawn from my bank or my Amex card and then my Amex card is drawn from my bank as well. So I add up all my monthly total like this: ...
1
vote
1answer
2k views

How can I alphabetize a unique result in Google Spreadsheets?

I'm generating a list based on using the UNIQUE function. How can I get the output to be alphabetized automatically?
6
votes
2answers
17k 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
945 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
3k 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 ...
6
votes
1answer
5k 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?
27
votes
6answers
42k 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
6k 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 ...
1
vote
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
21k 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
3k 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 ...
4
votes
2answers
523 views

Let users only change their own data in Google Spreadsheets

I have a Google Spreadsheet in Google Drive. Users can change everything and anything in the spreadsheet. Now, I want them to be able to change empty fields or their own fields only. Is this ...
1
vote
3answers
6k 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
580 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
184 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 ...