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

learn more… | top users | synonyms

0
votes
1answer
1k views

Google docs spreadsheets: Copy data down into next set of blank cells, if any, for whole column?

I have some text that I've taken in from a pdf that isn't exactly synced up with the right lines as much as I'd like: I want to duplicate the column A and D values down into any empty spaces/rows. ...
1
vote
1answer
5k views

Circular dependency detected even while using IFERROR

I have the following function in the cell B2: ARRAYFORMULA(SUM(IFERROR(Purchases!B3:B, 0))) And the following function in cell C2: ARRAYFORMULA(SUM(IFERROR(Purchases!C3:C, 0))) Basically, the ...
2
votes
1answer
5k views

Apply Formula to Newly Inserted Row

I have a spreadsheet that keeps a running balance of a credit card with the newest transactions at the top (just like credit card web sites). An example of the formula for each cell in the Balance ...
43
votes
2answers
87k views

How can I create a fixed column header in Google Spreadsheet like the first sheet?

How can I create a fixed column header in Google Spreadsheet like the first sheet?
2
votes
1answer
267 views

Getting a new “publish to web” URL for a published Google doc

When I publish a Google spreadsheet to the web, it generates a URL that I can share with others. I know I can stop publishing. When I re-publish, the URL is the same. I no longer want ALL viewers who ...
2
votes
1answer
157 views

Update a cell based on two matching fields in separate tabs within a range

I'm trying to update a cell in Google Spreadsheets where its value comes from another sheet and based on the date range entered with it. Here is what the two worksheets look like in the file. ...
1
vote
2answers
1k views

Google Spreadsheet - missing sort in menus

I have a Google spreadsheet that has the A column as an ID field (incrementing numbers 1...1000; no formula, just numbers). That column is frozen as is the first row of headers. I sorted by column B ...
6
votes
2answers
2k views

Using data from another sheet in Google Spreadsheet

I'm trying to write a SUM function in sheet B, summing all the data from sheet A in specific rows. I can't find a good explanation of how to do this.
1
vote
1answer
4k views

Forcing uniqueness in a Google Spreadsheets column

I have created a Google spreadsheet (acting as a database) that has numerous columns, name being one of them, and I wanted to make sure the name field is always unique and no row can be created if the ...
5
votes
1answer
223 views

Including option descriptions for a Google Docs Spreadsheet form

Usually, the options for a form are pretty self-intuitive, but sometimes, you need to explain each of the individual options. In close proximity to the actual question. However, the options for a ...
3
votes
1answer
2k views

How to freeze a row height or prevent line breaks in Google Spreadsheets?

My question is very similar to a previous question here, but I don't want the scroll bars. When I paste a link in a cell it usually breaks the cell in multiple lines, increasing the row height. Even ...
5
votes
1answer
8k views

Sum data based on cell color in Google Spreadsheets

I have seen this question and altough I face the same problem, the answer to that question is not helpful to my case. I have large spreadsheets which are changed frequently. So, according to the ...
13
votes
4answers
6k views

Google Docs Spreadsheet - Multiuser filter issue

When two or more users view the same Google Docs spreadsheet and one of them filters the data by a column, that filter is immediately applied for the other users as well. Is there a way to avoid this ...
9
votes
1answer
7k views

Disable Default Word Wrap in Google Spreadsheets

Does anyone know how to make it so that Word Wrap is OFF by default in Google Spreadsheets?
4
votes
1answer
2k views

Chart of averages on Google Spreadsheets

I have day by day data. I would like to display a line chart with this daily data as well as weekly average bar chart. How can display daily as well as weekly trend chart by only having daily data ...
3
votes
1answer
689 views

Can I auto archive my Google Spreadsheet?

We are using Google Spreadsheets for call logs, which is shared with more than 20 users and we all add entries simultaneously. I would like to know if there is any feature to automatically archive ...
4
votes
1answer
378 views

Offline capability in web app with sync when online

I need to give a survey to people on a tablet device. The survey runs on a browser which might often disconnect from the internet, hence I need to have the device sync whenever its in the wifi ...
13
votes
2answers
40k 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 ...
8
votes
2answers
8k 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
487 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 ...
4
votes
2answers
3k 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 ...
3
votes
1answer
952 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
4k 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?
15
votes
7answers
50k 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
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
505 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
445 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
12k 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
82 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
1k 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
49k 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
800 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
348 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
133 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 ...
8
votes
2answers
12k 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
762 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
5k 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
1k 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?
9
votes
4answers
17k 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
125 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 ...