Part of the Google Docs suite, a web app that allows you to create and edit worksheets
2
votes
1answer
324 views
What is the “web clipboard” in Google Spreadsheets?
I made a chart in Google Spreadsheets and then clicked on Copy Chart. A little popup notified me that the chart was copied to the web clipboard. However, when I try to paste the chart anywhere in the ...
0
votes
1answer
116 views
How can I have column E copy its data into the right column based on the initials in column M?
So what I have so far is a spreadsheet that will auto time stamp column N when my technicians enter their initials into column M.
Now the 2nd thing I would like the spreadsheet to do is.
When I ...
3
votes
1answer
213 views
Prevent the cell from expanding to the size of cell contents in a Google Docs spreadhseet
How can Google Docs Spreadsheet be prevented from expanding to the size of the cell contents?
Example:
The cell expands vertically to fit the cell contents:
The cell expands horizontally to fit ...
3
votes
3answers
275 views
Merging Data in Google Docs
I have a survey created in Google Docs used in several classes. Each class has its data in a separate Google spreadsheet. Now I want to collate all the data into a single spreadsheet. If I simply copy ...
2
votes
1answer
3k views
Google Spreadsheet Timestamp?
I'm looking for some help with my Daily Work Log spreadsheet.
I've search and read many different version of making a "TimeStamp" in Google spreadsheet.
And it seems I don't have enough experience for ...
1
vote
1answer
181 views
Escape parentheses around a number in Google Docs Spreadsheets?
How do you escape parentheses around numbers in Google Docs Spreadsheets so that they don't default to displaying as negative numbers?
-4
votes
1answer
128 views
Changing a value based on equality between two other values [closed]
First Sorry about my bad English.
Here it's the situation, I have:
A1=1
B1=2
B2=2
And I want to do an If function so that If B1 = B2 A1 will be 1 + 1, so A1 is now 2.
I tried:
...
4
votes
1answer
211 views
Google Spreadsheets Conditional Formatting with color
I want to add a column of cells together only if the particular cell is colored green. Can I do this using conditional formatting on a google spreadsheet?
3
votes
0answers
205 views
Why is “access denied” to multisheet charts in published Google docs?
I can successfully include a chart based on a single sheet, but as soon as I combine ranges from multiple sheets, I get an access denied error.
Example spreadsheet
Published spreadsheet
What am I ...
4
votes
0answers
209 views
Preserve formatting when referencing cells across sheets in Google Docs
Is there a way to show the formatting of the referenced cells from another sheet in Google docs spreadsheets? For example I have a sheet named balance with A1 having a comment and a blue background. ...
1
vote
1answer
94 views
In Google Spreadsheet, how to copy data from cell below?
Envision two rows, one up top and one below it. The cell up top is blank but the one below has 9/24/12. How can I create a function that will make the top one copy the value of the cell below it if it ...
1
vote
0answers
84 views
How to insert empty row in Google Spreadsheets when two rows are not duplicate?
I have a number of rows in a Google spreadsheet. I want to insert an empty row only when two sequential rows are not duplicate. How can I do this?
3
votes
1answer
3k views
Multiple Conditions on a CountIF?
I have a spreadsheet that is essentially a todo list for different groups. I have a column for Group and Status. Both have data validation drop downs so I can reliably match the text content.
I have ...
0
votes
1answer
76 views
I need a formula that returns how many times a unique value appears in a given date
In a spreadsheet in Google Spreadsheets, I’m trying to solve this:
17/02/2012 banana
17/02/2012 banana
17/02/2012 banana
17/02/2012 apple
18/02/2012 apple
18/02/2012 apple
I need a formula ...
4
votes
1answer
462 views
Generating Google Spreadsheet hyperlinks from cell contents
I have a column of cells in a Google Spreadsheet with values such as:
37683
36583
38637
32391
What I would like to do is generate a hyperlink for each cell like:
http://mywebsite.com?id=xxxxx
...
1
vote
1answer
514 views
How can I set conditional formatting on particular cells that depend on another cell's value in Google Spreadsheets?
I would like to colour the background of a row in Google Spreadsheets:
For example:
If cell Dx = title 'To do' or 'title 'Done' then cells Fx to Nx are filled colour black.
If cell Dx = title ...
3
votes
2answers
1k views
Google Spreadsheet - Keep a variable while copy/paste cell [duplicate]
Possible Duplicate:
'Lock' part of formula when copying from one cell to another
I am using in one of my spreadsheet a formula referencing to the column title (matching how many ...
1
vote
2answers
162 views
In a Google Spreadsheet, can I avoid references to cells in other sheets from breaking if I remove/add a row?
I have a spreadsheet that has two sheets. One takes entries and a second manipulates content from the first and displays results.
If I remove or add a row, the references in sheet two change, killing ...
2
votes
1answer
4k views
Create a column of date in Google Spreadsheet [duplicate]
Possible Duplicate:
How to extend series of dates in Google Docs?
Is there a way to create a column of date easily with google speadsheets like with Excel ?
In Excel, enter a date, hold ...
2
votes
1answer
193 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
132 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
120 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
319 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 ...
3
votes
1answer
181 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 ...
3
votes
3answers
498 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 ...
2
votes
2answers
879 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 ...
1
vote
1answer
1k 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
0answers
59 views
Adding worksheet A, sheet A, cell A to worksheet B, cell B [closed]
I need to access a cell in a worksheet on one Google doc and place it in another Google doc to add into the final total on that worksheet. This is for a class where I have to track multiple items for ...
0
votes
2answers
886 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 ...
5
votes
1answer
1k views
Google Spreadsheets: format cells as plain text
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 ...
1
vote
1answer
861 views
Repeat last action 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 ...
1
vote
1answer
491 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
110 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.
0
votes
1answer
415 views
Does the row insert API for an existing Google Doc's spreadsheet require Oauth2.0 token to proceed it? [closed]
I working on building an application to having our corporate server perform an HTTP post operation to add a row in a Google Doc's spreadsheet. I have created the spreadsheet already and now I want to ...
0
votes
1answer
68 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?
0
votes
1answer
416 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 :P)
=IF(AND(COUNTIF(basictier1;"*"&A4&"*"));"T1 Basic"; IF ...
4
votes
1answer
911 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 ...
1
vote
0answers
106 views
Hyperlink to “view-source:” URL in spreadsheet
I'm trying to make a hyperlink that takes you automatically to the source of a page in a Google spreadsheet.
eg I want to make view-source:http://superuser.com directly clickable, rather thank having ...
0
votes
1answer
350 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 ...
0
votes
0answers
12 views
How to select only weekdays for a given period of time in a Google spreadsheet? [duplicate]
Possible Duplicate:
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 ...
3
votes
2answers
615 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
1answer
242 views
How can I link 2 cells in Google Docs in the same document, on the same spreadsheet?
How can I link 2 cells in Google Docs in the same document, on the same spreadsheet?
I have a headings and every time I have to scroll down to the one I need. Can I create some kind of "header" on ...
1
vote
2answers
3k 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 ...
2
votes
1answer
516 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
147 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
87 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
484 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
990 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 ...
2
votes
1answer
308 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
176 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 ...
