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

learn more… | top users | synonyms (1)

2
votes
1answer
1k views

Problem using the TRANSPOSE() function in a Google Docs' Spreadsheet

I need some help with a Google Docs spreadsheet. Let's say I've got a column and in the column I have 3 rows containing the values A, B, and C: Column: A B C I need to transpose the column so that ...
5
votes
2answers
3k views

How do I link text to a URL in a Google Docs spreadsheet? [duplicate]

Possible Duplicate: How do I add a hyperlink to a cell in Google Spreadsheets? When I paste a URL into a cell in a Google Docs spreadsheet, it turns into a nice blue, underlined hyperlink. ...
1
vote
2answers
519 views

Google spreadsheet flextime

Being a (productive) geek, I want to keep track of the trend of my flextime. I keep a personal document of my hours worked in a Google Spreadsheet, having one column for hours worked every day. By ...
4
votes
1answer
467 views

Retrieve a cell having a column and a row header in Google Spreadsheets

I have a spreadsheet in Google Docs like this: Johan Mark Gil Pablo Course 1 45 50 80 50 Course 2 250 300 50 270 Course 3 19 50 ...
6
votes
4answers
16k views

Adding a datepicker in Google Spreadsheet

Is it possible to insert a datepicker in every cell of a column in Google Spreadsheet so that anyone can click (with a single click) on that cell and get a datepicker calendar to select a date?
-1
votes
2answers
84 views

Create a formula based on the number of columns in Google Spreadsheets

I have two rows of data Row B = price of product Row C = quantity of producst I need to get the summary price: (B1xC1)+(B2xC2)+(B3xC3)+..+(Bn+Cn) I don't know n (quantity of columns) because n ...
4
votes
2answers
2k views

Google Spreadsheets URL Syntax and Display Options?

I recently came across a Google Spreadsheet that had a slightly different syntax in the URL. I found these tags after the Spreadsheet Key: ...
4
votes
2answers
2k views

How do I populate a cell in Worksheet A with aggregate data from Worksheet B?

I'm working on a spreadsheet that allows some basic collaborative hour tracking. Worksheet A contains an entity called Blocks where each block has a BlockID. Worksheet B contains line items. Each ...
12
votes
5answers
51k views

Conditionally formatting a cell based on another cell's value in Google Spreadsheet

I did some searching on this and came across this post However, this solution uses an onEdit() trigger. I would like to see a solution that uses a formula approach, so in the OP's example from that ...
1
vote
2answers
809 views

In Google Spreadsheets how do I select column 1's value if an input value is between the integers in colums 2 and 3 for a range?

In a Google Docs spreadsheet I have two tables: Date BMI BMI Outcome 2011-06-21 22.1 ? 2011-06-22 21.8 ? 2011-06-23 21.5 ? and Name From To Severely ...
4
votes
1answer
355 views

Google Forms erroneous deletes rows in second sheet

I created a form in Google Docs with quite some questions. For a good overview I created a second sheet to pick the important parts from the survey. There I'm also able to add extra columns to add ...
2
votes
1answer
134 views

Can I add a search box that will open a new page on some 3rd party site to Google Docs?

I'm trying to make a document/spreadsheet containing a few resources I regularly use and perform searches in. Can I create something I can perform searches directly from a document that will open up ...
10
votes
3answers
13k views

Display Sheet Name in Google Spreadsheet

Is there any way to display a sheet name as the result of a function in a google doc spreadsheet (exactly like this question, except in gspread)?
4
votes
4answers
3k views

Returning the SUM of a range of cells from user-input START to END

In Google Docs, I am trying to sum the values of selected rows in a table, from position START to END. Imagining this sample data: Index VALUE 1 300 2 400 3 750 4 850 5 ...
6
votes
3answers
8k views

Build a cell reference without knowing Row # (number)

This can't be a more basic spreadsheet question but I have always been a SQL kinda guy... How do I build a formula where a value will be pulled from another column on the current row. Can't be the ...
2
votes
1answer
4k views

Embed a Google Spreadsheet in a forum post

I want to embed a Google Docs spreadsheet in a forum post so that it is easily viewed by people. The spreadsheet should be read-only in the embedded status. Any way to do it?
2
votes
2answers
4k views

Is there a way to search and replace a regular expression in Google Docs spreadsheets?

The problem is that I entered a lot of formulas like =round(x+y) into a Google Docs spreadsheet. Now I need them exported to MS Excel and the latter only accepts =round(x+y,0) as a valid format. ...
4
votes
2answers
2k views

Google Spreadsheet conditional counting function

I am having trouble writing a function for this need (in Google spreadsheets): I have 2 columns A and B. I want to be able to get a percentage based on those two columns. I want to count the number ...
3
votes
1answer
785 views

Google Spreadsheet Formula Applied To New Row

If I have a formula (of any kind) spanning A1:A30 (just as an example), when I right click and insert a new row, it doesn't have the same formula. Numbers (and I believe Excel) allows this, is there ...
11
votes
2answers
6k views

Complete reference documentation for Google Spreadsheets formulae?

As a programmer, I find myself somewhat frustrated when trying to use Google Spreadsheets, because there seems to be no definitive description of the syntax that I can use for formulae. For instance, ...
1
vote
1answer
2k views

Is there a Google Docs (or -spreadsheets) API to scroll the view?

If I want to scroll to a particular paragraph in Google Docs, or a particular cell in Google spreadsheets, is there a way to do that via Google Apps script?
3
votes
3answers
5k views

Are Excel formulas and Google Spreadsheet formulas the same?

I want to be sure all my Google Spreadsheet work can be converted OK to Excel. How many of the Excel formulas match the formulas of Google spreadsheets?
10
votes
5answers
19k views

Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?

I use a Google Form to retrieve feedback from our customers. I then download this info into our offline system. Is it possible in Google Form to give a unique value to each row it inserts into the ...
1
vote
1answer
4k views

Applying two filter functions in Google Spreadsheets

I am trying to apply two filter functions in Google Spreadsheets: Column (A) contains new data Column (B) contains filter data, i.e. cells with text that should not be included in column C Column (C) ...
4
votes
1answer
129 views

How do I use a computed range in formula?

I currently use this formula: =sumif($E$2:$E$363,L3,$D$2:$D$363) I'd like to change it to instead of having the $D$363 hard coded, that it pick up the "363" part from another cell that I specify. ...
4
votes
2answers
3k views

Parsing Time data in Google Spreadsheets

I'm keeping cycling diary in a Google spreadsheet. Each entry has a value of Duration entered as ie. . Then I have the totals where duration is summarized as well. But whenever Some of the relevant ...
4
votes
1answer
349 views

What formula would I use to calculate monthly cost (Google Docs)?

I'm trying to make a document on Google Docs that will list my total expenditures in the form of recurring fees/subscriptions. I've successfully enabled the basic 'SUM=(C2:C24)', but I would like to ...
6
votes
5answers
3k views

Cannot indent cells in Google Docs Spreadsheets

How do indent spreadsheet cells in Google Docs? It's a fundamental feature that I need in my financial work but I can't seem to get this working in Google Docs, or it doesn't support it. I've also ...
2
votes
1answer
358 views

How do I reference existing formulas from custom formulas in Google Spreadsheet Scripts?

I want something essentially like this: function contains(arg1, arg2) { return NOT(ISERROR(search(arg1, arg2))); } But NOT and ISERROR are undefined even though using =ISERROR(...) works in the ...
5
votes
1answer
2k views

Is there a way to filter columns in Google Spreadsheets?

Is there a way to filter columns in Google Spreadsheets: Column (A) contains new data Column (B) contains filter data, i.e. cells with text that should not be included in column C Column (C) is the ...
1
vote
0answers
139 views

Is there a way to filter columns in Google Docs? [duplicate]

Possible Duplicate: Is there a way to filter columns in Google Docs? Is there a way to filter columns in Google Docs? Column (A) contains new data Column (B) contains filter data, i.e. ...
1
vote
1answer
321 views

Google Docs Spreadsheet sections

I'm using Google Spreadsheets. I want to be able to have several different sections all on one spreadsheet: an income section with totals there an expense section with totals in it etc. How do ...
4
votes
3answers
5k views

How can I get GoogleFinance to return only the historical price of a stock and not an array?

I'm trying to figure out the cost basis of some stock that I sold last year and I can't quite get GoogleFinance to do what I want. The stock was purchased through a DRIP so there are about 5 shares ...
0
votes
1answer
166 views

Entering Local Date on Google Doc Sheets

If I use the shortcut CTRL+;, the date that is pasted is the server date. I have changed the settings so my Time zone is selected to my local time. Shouldn't my Local time get pasted as opposed to ...
2
votes
1answer
841 views

Batch copying/renaming in Google Docs

I need to copy and rename a base form (a spreadsheet) to several other forms in Google Docs. Imagine I have the following form: My Base Form - @name (@course) After running the script or whatever, ...
1
vote
0answers
696 views

Hovering image in Google Spreadsheets

I want to write a script which detects the mouse hovering over a cell (or if not possible, triggered by a menu as described in ...
2
votes
2answers
321 views

Google spreadsheet obscure fields with passwords

I would like to create a spreadsheet to manage my domain information in one place. I was thinking of creating rules that made dates red when registration and contracts were expiring and whatnot. I ...
5
votes
1answer
2k views

How to reverse text on Google Spreadsheets?

When I enter data in a Google Spreadsheets cell, I would like the text to reverse itself. For instance, I would like to put in a cell My text and get it converted to txet yM.
3
votes
1answer
4k views

In Google Spreadshets, how can you loop through all available sheets not knowing the total count?

I'm keeping stats for my daughter's baseball team. I have a sheet for each game, each one identical in structure. I want to create a summary sheet that totals numbers from the other sheets. How ...
2
votes
1answer
699 views

How to get data between tabs in Google Spreadsheets

is it possible to get a value from a tab cell and work with it in another tab? Tab 1 (T1) row working hours (A) who (B) 1 3 Mike ------------------------------- Tab 2 (T2) ...
15
votes
2answers
14k views

Google Docs date in “dd/MM/yy” format [duplicate]

Is there any way to use date in format dd/MM/yy? The Google Docs support only MM/dd/yy and it cause us problems to use it (we can't sort the date column).
1
vote
1answer
2k views

Validation based on multiple sheets in Google Docs

I have 2 sheets that each contain a column of data that I would like combined and used as a validation list for a column in another sheet. What would the formula look like for this?
1
vote
2answers
2k views

Google Spreadsheet: Auto-Update via RSS (and keep history)

I have a google spreadsheet that fetches some data via RSS. The RSS feed is updated once a day, everyday. Is it possible for me to keep archive of all the new & historic data in the google ...
3
votes
5answers
3k views

Is it safe to use Google Apps For Business: Spreadsheets to keep track of passwords?

Google Apps for Business is supposed to be secure enough for corporate data, as described in their FAQ: http://www.google.com/apps/intl/en/business/faq.html They say "We also undergo regular security ...
2
votes
1answer
2k views

Google Docs Spreadsheet - Copy data from previous sheet

HI I have a spreadsheet document where I register tournament results with a sheet for each tournament date. I want to have a cumulative column where to show cumulative information. I have already ...
2
votes
2answers
2k views

Is there a way to upload a .csv file to Google Docs using a Google spreadsheet as a template?

I am generating a .CSV file with an application. I then upload the .CSV file to Google Docs, which creates a Google Docs Spreadsheet which is "plain and white". I then have to manually format the ...
3
votes
3answers
8k views

How to collate data in Google Spreadsheets?

I have two sheets with data in single Google Spreadsheets document: SheetA: Date Name CounterA 22.02.2011 Beta 101 22.02.2011 Alpha 2 21.02.2011 Alpha 1 SheetB: Date Name ...
6
votes
2answers
2k views

Type testing in Google spreadsheets

Is it possible to test for integers or strings in a Google Spreadsheet and respond to each differently?
1
vote
2answers
4k views

Parse HTML through Google Spreadsheet using scripting

I'm trying to speed up the process of getting values from an HTML page to a Google Docs Spreadsheet through scripting. I remember Microsoft Excel had the import data function, but I don't own a copy ...
3
votes
2answers
6k views

Google Spreadsheets: Get column number by referencing column title

In Google Spreadsheets I have a number of columns that I have given title to in Row 1. Using a formula, I want to return the column number (i.e. 5, 6, 7, ...) for the column that has a specific ...