One of productivity apps in Google Drive, that allows you to create and edit worksheets
3
votes
2answers
2k 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
164 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
5k 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
201 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
145 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
129 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
327 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
203 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
581 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
927 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
60 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
953 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
2k 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
967 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
527 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
117 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
443 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
73 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
442 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
998 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
114 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
400 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
660 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
248 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
577 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
165 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
92 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
525 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
1k 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
380 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
185 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
334 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 ...
0
votes
2answers
821 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
310 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 ...
3
votes
1answer
819 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 ...
1
vote
1answer
1k views
Google Docs: 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 (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
209 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
1k 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:
...
0
votes
1answer
455 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
1answer
8k 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
457 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 ...
0
votes
1answer
374 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
169 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.
...
3
votes
1answer
790 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?
5
votes
3answers
7k 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 ...
1
vote
1answer
1k views
In Google Spreadsheets, how can I highlight selected text in a cell and not the whole cell?
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
453 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 ...
