A productivity application from Google that allows you to create and edit worksheets

learn more… | top users | synonyms (2)

1
vote
1answer
771 views

Error with exact date 21/02/1971 - function MINUS expects number values

I am getting this really bizarre error. In cell A1 I have 21/02/1971 (Brazilian-style date), in A2 I have =today()-A1. I receive the following error: #VALUE! Error: Function MINUS parameter 2 ...
1
vote
1answer
66 views

How do I refer to a range in another sheet?

Sheet 1 has numeric values in the B column. I'd like to sum them into a single value within Sheet 2, preferably without having to copy them individually first. According to the docs, I can copy a ...
1
vote
1answer
432 views

Date format in Google Spreadsheet is not correct

Whenever entering the date e.g. day-month-year, it automatically changes to month-day-year. I went into format>number>more formats>more date and time formats, and I changed it to day-month-year. And ...
1
vote
1answer
94 views

“Go to” search in google spreadsheet

I want to have a search feature at the top of my spreadsheet that will actually take me to a row, on the same sheet, based on searching a column for the matching information. So, I want any user to ...
1
vote
2answers
39 views

Auto bracketed pricing in Google Spreadsheets

I am keeping track of some sales in a Google Spreadsheet. I have a price bracket for number of items sold and unit cost (so that people ordering in bulk have lower prices). I used to just have about ...
1
vote
1answer
212 views

Fix Value of Row or Column from Another Sheet

In a given sheet, if you have a formula that involves a value, it's possible to fix either the column or row for that value as you expand the equation, i.e. : =A1 + A!2 But how do you do this when ...
1
vote
1answer
1k views

How do I multiply column values?

I simply want to multiply column h with column j, and store the result in column k in each row. What do I type in as the formula to do this?
1
vote
1answer
383 views

Sum if date is in range

I have a table of random dates A and a sum for each date B. The sum is over all the amounts in D, where the date in C is before the date of A. So B3 is D1+D2+D3+D4+D5+D6 because the date in A3 is ...
1
vote
2answers
3k views

Google Spreadsheet; Function to Search a Sheet for String and Return Value of Next Column

Here is what I have so far. it will: Search for keyword in my other sheet (JSON) When it finds the keyword (modname) it returns the row # The keyword is on the A column. What I want is for a ...
1
vote
2answers
372 views

Create chart with total for each score

I have a column within a Google Spreadsheet with values like this: 96 97 96 100 97 97 100 97 95 95 96 I'd like to add a bar chart where each bar represents one of the values and the height of the ...
1
vote
2answers
52 views

Google Sheets, Suddenly decimalised some of my number entries

I've been using Google Sheets to create a record of car parts, entering: each part's serial number, the quantity of that particular part, the name of the part and the location where I'm ...
1
vote
2answers
102 views

How to display a character when a value in the same row is the highest value in its column?

I have the following example table: A | B a | 5 b | 3 c | 1 d | 9 <=== expected result e | 0 f | 4 So it should display d as in the other column 9 is the highest value.
1
vote
2answers
1k views

Having an issue with horizontal scrolling in Google Spreadsheets

When I try to scroll horizontally in Google Spreadsheets using the track pad, nothing happens. However, if I scroll vertically first, I can then scroll horizontally if I don't pick up my fingers from ...
1
vote
1answer
1k views

Is it possible to feed multiple form drop down lists?

I am using Tom Horwood's code which has worked for me for updating one drop-down. But my form has multiple drop-down lists which I would like to make dynamic. Is this possible? Tom Horwood's code ...
1
vote
2answers
193 views

VLOOKUP or INDEX+MATCH

I have an array of values: A B C 1 TypeID MaterialTypeID Quantity 2 18 34 256 3 18 35 512 4 20 34 386 5 20 36 773 ...
1
vote
1answer
122 views

Is there a way to count how many entries in a given column have a particular value?

I have a spreadsheet which keeps track of duels between two players in a game. Each row has the number of the match and the winner, given by their initial, X or Y. I want to know if it's possible to ...
1
vote
1answer
859 views

Google Spreadsheet: Count values from last 30 days

Here is a sample spreadsheet you can view and edit: https://docs.google.com/spreadsheet/ccc?key=0AnWwBCPp8kISdGc4bExyYV8xOTVRbnRkaXNQSzBWalE&usp=sharing. How can I count the number of successes ...
1
vote
1answer
155 views

Find the maximum occurrence across sheets

This is kinda difficult to explain... Is it possible to let Google Sheets tell me what the maximum value is from some chosen columns in MORE THAN ONE sheet (in the same document)? I namely need to ...
1
vote
1answer
4k views

Google Docs: How to Paste a Cell Range Automatically—Values Only?

I need some "live" cell data (values only), which get their data from another sheet; an arrayformula is not sufficient. I'm thinking something that copies column A:13-down from Sheet1 (whenever it ...
1
vote
1answer
87 views

How do I add a range of numbers positioned relative to its criteria?

I'd like to sum up some named values by referring to their names in a separate sheet. Can I do this with a single formula in the second sheet? Sheet 1: | A | 3 | | B | 5 | | C | 2 | | D | 4 ...
1
vote
1answer
663 views

Google Spreadsheet Timestamp for columns B & D? [duplicate]

Found this script on one of the questions answered in the forum what I don't know enough to make it work. I would like it to time-stamp date and time in column B when they check in and then a separate ...
1
vote
1answer
380 views

Handling variables with data from another sheet on google drive calc

I have a Google Drive Calc File, Google says in their web help how to reference data from another sheet, but what happens if what I need is to make the reference depending on my fields on the new ...
1
vote
1answer
1k views

Google Spreadsheet Form Responses in to an already made sheet

I have a template form and matching spreadsheet that need to be copied multiple times. When I make copies of the two, the copies are not linked for the form responses to go to the newly copied ...
1
vote
1answer
89 views

Stop content from making cell two lines

In Excel if you have a long piece of text like a URL in a cell you can stop the cell from becoming a double-line cell and messing up the rest of your layout. It does this by just clipping the info ...
1
vote
1answer
349 views

The column from which to return vlookup responses depends upon the value of a cell

With Cell F1 a drop down menu, I'm trying to look up the value of A2 on sheet 2 and if F1 contains: "Test1 1/2", then return the data in the 3rd column "Test1 2/1", then return the data in the 4th ...
1
vote
1answer
2k views

Exclude cell from sum in Google Spreadsheet

I am using my Google Spreadsheet to keep tabs of my incomming and outgoing money. I've made a row with ~19 cells in it, in those 19 cells I have the monthly what comes in and what goes out. At the end ...
1
vote
1answer
2k views

Google Spreadsheet: Query function date formatting not working

I'm trying to make this query work on my spreadsheet on chrome Win7: =QUERY(A1:D5;"SELECT MAX(A), COUNT(A), SUM(C) GROUP BY (A) FORMAT MAX(A) 'MMMM' ") Everything is ok except for ...
1
vote
2answers
578 views

Google sheet: sort value according to another column

I'm a total n00b to this, so I'll try to explain the best I can. I have a Google Spreadsheet prepared: example sheet In column I, I want to list every player in column B if the value in column C is ...
1
vote
1answer
118 views

Adding a few lines of information to a grid

I have made out an 8 column, 21 lines, informative health chart with grid lines. I would like to add an afterthought running from left to right UNDER the grid lines that will PRINT out with the ...
1
vote
1answer
946 views

SPLIT function in Google Spreadsheets with OR statement

I want to use the split function, but with different delimiters. I thought of something like this: =SPLIT(A:A;OR("-","&")) but it doesn't work. Is it possible to have Boolean statements within a ...
1
vote
1answer
127 views

Transpose an Address List as Row in Google Spreadsheet

I'm having a good old list with addresses: Because I want to re-arrange the list (and make it more 2013), I need to transpose the list like this: I've tried to use the TRANSPOSE formula, but that ...
1
vote
1answer
315 views

In Google Sheets, how can I fit the data to the cell?

In some cells on my sheet the data fits the cell. On some rows there is a lot of extra space after the data in each cell. I have tried deleting after at the end of the data, but it does not help. ...
1
vote
1answer
80 views

Formula to return time difference but not display 0 in google spreadhseet

I have a google spreadsheet with start (C) and end (D) timestamps. I am calculating the time difference using =(D1-C1). I have copied the formula to empty columns which returns a 0 time difference. Is ...
1
vote
1answer
174 views

Forwarding table content received in Gmail to a spreadsheet in Google Docs

I am managing to receive a fixed structured table from a questionnaire in a web form. So I want to have this table automatically forwarded to a specific spreadsheet, so that I can make my own ...
1
vote
1answer
878 views

Escape parentheses around a number in Google Docs Spreadsheets?

How do you escape parentheses around numbers in Google Docs Spreadsheets so that they don't default to displaying as negative numbers?
1
vote
1answer
137 views

In Google Spreadsheet, how to copy data from cell below?

Envision two rows, one up top and one below it. The cell up top is blank but the one below has 9/24/12. How can I create a function that will make the top one copy the value of the cell below it if it ...
1
vote
1answer
758 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: ...
1
vote
3answers
4k 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 ...
1
vote
1answer
1k 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
204 views

How do I get the unique number of days in a datetime column in Google Spreadsheets?

I have a column full of datetime values in a Google Spreadsheet. I want to get a count of how many unique days there are. As in 8pm and 7pm today would count as 1. Tomorrow at 9pm, 3pm and 4pm would ...
1
vote
1answer
790 views

How come I can't input a formula into my Google Spreadsheet?

Here are my steps: focus a cell in my Google Spreadsheet, hit = and then highlight the field D3, hit +, highlight the field D4, hit +, highlight the field D5, hit Enter. However, the field just ...
1
vote
1answer
3k 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 ...
1
vote
2answers
912 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 ...
1
vote
1answer
3k 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
3answers
7k views

How can I retrieve records from a Google Spreadsheet in JSON format?

I'm trying to retrieve data from Google Spreadsheets with no success. I've gone through this: http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#RetrievingTables and this: ...
1
vote
1answer
14 views

Time stamp on last row of column for changes in predetermined range

I am looking for a way to add a time stamp to the last row of a column of figures any time there is a change in the above range. I have been able to find a number of examples where you can timestamp ...
1
vote
1answer
18 views

Finding task with highest date

I have this sheet https://docs.google.com/spreadsheets/d/1X9tMWp0Is7BaTpJ2rGWUdLLBtxoCHxB3hqCJIXudg8g/pubhtml?gid=0&single=true where I want to do simple project planning and resource booking The ...
1
vote
1answer
18 views

How to convert text of the form Month-Year to date format?

How do I convert the text "Oct-14" to date, so that it's being read as "Oct 01, 2014. I tried to go to Format > Date and selected the format: Oct-2014, but google sheets is interpreting it as "Oct 14, ...
1
vote
1answer
34 views

Having trouble getting rating sheet to update as games are entered

I keep a spreadsheet that uses the elo equation for chess where I work that updates players ratings when I enter the two players names and who won or lost (1 for win, 0 for loss). My issue is that it ...
1
vote
1answer
28 views

Convert text automatically in Google Spreadsheets.

Background: We have a list of data that we import into Google Spreadsheets from Wufoo.. The data is user generated (user inputs the information into the form). After importing the data into google ...