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

learn more… | top users | synonyms (2)

15
votes
2answers
67k views

Is it possible to add a checkbox/button equivalent to a Google Docs spreadsheet?

I know there's no checkbox functionality in a Google Docs spreadsheet but I was wondering if there's a way to get equivalent functionality somehow. What I'm looking for is a one click enable/disable ...
10
votes
2answers
9k views

Sum of all cells in Google Spreadsheet where matching row fits a value

I want to return the sum of all cells in ColumnA only if the value of a cell on the same row is equal to a specific value. For example, sum C4 if D4 = "Bob". Assuming there are six rows whereby ...
2
votes
1answer
619 views

Embed interactive google spreadsheet with calculations still intact

Is it possible to embed a google spreadsheet into a webpage and keep all the calculations still intact? For example: I'd like to embed a calculator I have into a webpage, and allow the user to still ...
5
votes
2answers
5k views

How can I get Google Docs to stop formatting a form response as a date?

I have a Google form with a question that contains a drop-down box with the following values: Fewer than 10 11-25 26-50 More than 50 If the user selects "11-25", Google Docs renders the response ...
4
votes
1answer
1k views

Create a 7 Day Running Total and Running Average

I have a Google Spreadsheet tracking figures day by day. I want to add a column with a 7 day running total (sum of last 6 rows plus current row) and a column with a 7 day running average (average of ...
5
votes
2answers
5k views

Add a link in Google Spreadsheet to a paragraph in Docs

How do I add a link in a Google Spreadsheet to a specific paragraph or header in a Google Doc?
2
votes
2answers
672 views

Is there a way to add a row to a Google Spreadsheet via a script?

I'd like to be able to call a script, which will add a row to a Google Spreadsheet, and manage stuff like user login. For example, gdocs_addrow --id <doc-id> name="John Doe" age="31" I know ...
19
votes
8answers
80k views

How to alter text orientation to vertical in Google Spreadsheet document?

Using MS Excel I can go to Format of the cell and choose the text orientation from horizontal to vertical fairly easy. How do I alter text orientation to vertical in Google Spreadsheet document?
2
votes
2answers
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
4k 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
576 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
632 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 ...
9
votes
5answers
27k 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
96 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
54k 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
878 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 ...
5
votes
1answer
404 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 ...
15
votes
3answers
21k 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)?
3
votes
4answers
4k 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
9k 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
5k 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 ...
4
votes
2answers
830 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 ...
13
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, ...
2
votes
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
8k 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?
15
votes
6answers
27k 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
5k 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
134 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
4k 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
409 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 ...
4
votes
1answer
457 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
3k 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
383 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
6k 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
190 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
1k 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, ...
3
votes
1answer
981 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 "Google Developers: Apps Script: Custom Menus in Google Apps". This ...
2
votes
2answers
430 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 ...
6
votes
1answer
3k 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.
4
votes
1answer
6k 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
2answers
721 views

Pre-fill a cell with today's date

I would like a certain cell of mine to display today's date when I starts a new row. Is it possible?
2
votes
1answer
811 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
19k 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).