Part of the Google Docs suite, a web app that allows you to create and edit worksheets
4
votes
1answer
1k views
Downloading charts from Google Spreadsheets in high resolution
I have a Google spreadsheet with data from which I've created a few charts using the built-in charting tool. Now, I'd like to download these charts in a format I can use in a PDF document I create ...
4
votes
3answers
6k views
How to make a query with Google Spreadsheet, that checks for a date
I have a range that goes from B4:H124. All the cells in column B are dates. I would like to retrieve the data from a row (B:H), where the DATE equals to the content of a specific cell, lets say Q4.
...
1
vote
1answer
572 views
How to query for count of dates in Google Docs?
I have a Google Spreadsheet of line items. One of the columns is a Date field. How can I query (or use a formula) to, for example, get the count of records where the Date field is within February of ...
4
votes
2answers
5k views
How to sum values in a range of dates in Google Docs Spreadsheets?
I have a Google Docs spreadsheet in the format below — here's an example.
Column A → Dates
Column B → Numbers
I'd like to sum values in column B in a range of dates in column A.
Example:
...
2
votes
1answer
576 views
Google spreadsheet: box plots?
I want to create a simple boxplot from 1D data, which doesn't seem to be supported by the default Inesrt>Charts. There is a histogram gadget but I haven't seen any boxplot gadgets. Do I have to make ...
-1
votes
1answer
577 views
Simple row references in Google Spreadsheets and resorting data
This is my scenario
Users are entering data into rows with several columns
Last column is calculated on values of few previous columns (so it's row number independent).
While entering new and ...
2
votes
2answers
340 views
Google spreadsheet charting count of items?
I have a spreadsheet that is filled by a form.
It contains values like the following:
Timestamp Person Category
2012-02-13 10.31.22 a x
2012-02-13 11.06.37 b y
2012-02-13 ...
3
votes
2answers
2k views
Google spreadsheet—calculating shaded cells
I am using Google spreadsheets to create a matrix (time/activity) as a daily schedule for staff to sign into. Is there a formula to calculate the number of cells in a column that are shaded (or not ...
1
vote
1answer
2k views
Filter rows in Google spreadsheets
I have a Google spreadsheet. There is a colour column. Every row has a colour, Red, Yellow, Green etc. I want to be able to filter out say all rows that are Red, all rows that are yellow, all rows ...
3
votes
2answers
443 views
Format credit card numbers as four digit blocks in Google Spreadsheets
I have this credit card number in a Google Docs spreadsheet of the following format:
XXXXXXXXXXXXXXXX
How can I make it display like XXXX XXXX XXXX XXXX or XXXX-XXXX-XXXX-XXXX where they're in ...
0
votes
1answer
1k views
Google Docs ImportXML can't scrape anymore?
ImportXML lets you get information from filetypes such as xml, html, csv, tsv, as well as RSS and Atom feeds.
This example in Google Docs Help for importXml function -
=importXml("toysrus.com";; ...
1
vote
0answers
165 views
In Google Spreadsheets the xPath method with Google Maps don't work anymore?
I've used this query to calculate distance between two locations, now it won't work anymore, and returns the error xPath query didn't get any result (translated from Italian, I don't know if is the ...
2
votes
2answers
5k views
Sum column only if another column has an empty value
I am trying to get a sum of column values in a Google Spreadsheet only if there is no value in the adjacent column. Consider the following example:
A | B
----------
40 | 50
20 | 20
30 |
10 |
...
1
vote
1answer
863 views
Sum of the values of the 10 cells above me?
I'd like a formula for Google Docs spreadsheets that will return the sum of the values of the 10 cells above the current cell.
That is, if I'm on C31, I want the equivalent of =SUM(C20:C30). However, ...
2
votes
1answer
1k views
How do I format a cell to be in alternative currency without decimals in Google Spreadsheets
I am really scratching my head, but it seems like this is not possible in Google Spreadsheets. I want to format a number cell in kroner without any decimals. All I get is "kr 38,434.00" I want this ...
1
vote
1answer
255 views
Duplicating a set of columns with various widths within the same spreadsheet
I'm trying to duplicate a set of 5 columns multiple times on the same sheet. For example, column A is wide, columns B & E are medium width and Columns C & D are narrow. I want to duplicate ...
2
votes
2answers
4k views
Adding one Google Spreadsheet column to a string to dynamically create a URL in the next column
I have a spreadsheet of product id codes that I'd like to turn into links, and from everything I've read, the concat or concatenate functions in Google Docs should work for that, but so far everything ...
1
vote
1answer
2k views
Hyperlinks in Google spreadsheet docs
In Google spreadsheets, it is possible to add a hyperlink to a cell as:
=hyperlink("www.google.com";"search the web")
This will show the text search the web which will hyperlink to Google. ...
3
votes
1answer
2k views
Google Spreadsheet fill value in multiple cells
In MS Excel, after selecting a range of cells it is possible to enter a value and press CTRL+ENTER to have that value set in all selected cells.
Is there a keystroke in Google Spreadsheet that would ...
5
votes
4answers
5k views
In a Google spreadsheet, how can I refer to two different columns in a COUNTIF function?
I'll try my best to explain. Say I've got a sheet that looks like this (in this contrived example, let's say I'm sending marketing emails to various people, I know their ages and zip codes, and I ...
7
votes
2answers
4k views
Text to columns conversion in Google Spreadsheets
How do you do a text-to-columns conversion in Google Spreadsheets?
For example, I have the following data string in one cell:
5,233,6,2,6,7,2,2,6,6
I want to break it apart by the comma separator ...
2
votes
1answer
5k views
How do I calculate a time delta in my Spreadsheet?
I've got a Google Docs spreadsheet that looks roughly like this:
Date | Start | End | Minutes
------------+-------------+-------------+-------------------------
1/11/2012 | ...
4
votes
3answers
4k views
Google Spreadsheet: How to prevent cut and paste data changing references in formulas?
Google Docs has a feature where if you have a reference to a data cell in a formula, and you cut the data from that cell and paste it in a new location, the reference in the formula is updated to ...
3
votes
3answers
3k views
How can I convert a table in a Google Docs document to a spreadsheet?
I've tried selecting the table in the document, copying it, and pasting into a new spreadsheet, but this results in a one-column spreadsheet with all of the columns flattened into one.
I don't see a ...
2
votes
0answers
186 views
Can I precisely position charts in a Google Docs spreadsheet?
I am using Google Docs to create a "Monthly Report" spreadsheet for a product, and am attempting to make an attractive, compelling experience for the consumers of the report.
In this spreadsheet I ...
2
votes
1answer
1k views
How to have auto updated current time cell in GoogleDocs / Excel
I am trying to create a spreadsheet that will allow me to track my clients' timezones.
I am using the useless NOW() function to calc current time, and then factor in the time zone value (+/- a #) as ...
1
vote
1answer
238 views
How can I automate a series of actions, after receiving an email in GMail?
Here's what I want to do...
When an email with a known subject, or from a known source, is viewed I want a button that will:
Add data from the email (could just regex parse) to a new row in the ...
0
votes
1answer
930 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.
...
0
votes
1answer
3k 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 ...
1
vote
1answer
3k views
Google Spreadsheet 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 ...
2
votes
1answer
171 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
124 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
703 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 ...
5
votes
1answer
939 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.
0
votes
1answer
1k 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
171 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 ...
2
votes
1answer
946 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 ...
4
votes
1answer
2k 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 ...
8
votes
3answers
2k 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 ...
6
votes
1answer
3k 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
1k 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 ...
4
votes
1answer
201 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 ...
9
votes
2answers
15k 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 ...
6
votes
2answers
4k 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
312 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 ...
3
votes
2answers
1k 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 ...
1
vote
1answer
520 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 ...
4
votes
2answers
2k 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?
7
votes
3answers
23k 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
671 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 ...
