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

learn more… | top users | synonyms (1)

0
votes
1answer
55 views

A function opposed to SUMIF?

I have a huge list of matches between clubs and I want to calculate the goals for and the goals against. I could find a way to calculate the goals for, using: =SUMIF (A35:A46, "Liverpool", B35:B46) ...
0
votes
1answer
29 views

Compare two rows of a sheet to another and show characteristics

I'll try to be clear although english is not my first language. I have a first spreadsheet (let's name it PRODUCTS) containing, in different columns, characteristics of different products ...
0
votes
1answer
39 views

Google spreadsheet, sort adds a bunch of rows

I have a function that sorts a table, unfortunately when I call my function it adds a bunch of empty rows at the bottom that I don't like. var kotlijst = SpreadsheetApp.getActiveSpreadsheet() ...
0
votes
2answers
301 views

Make first row in Google Spreadsheet column names

I cannot figure out how to turn the first row of a Google Spreadsheet into column names so that I can sort the spreadsheet by column without losing the variable names at the top of the spreadsheet. I ...
0
votes
1answer
65 views

How to merge multiple rows in Google Docs?

I've got a Google Sheet with columns along the lines of: URL | Pageviews | Time on Page The same URL is sometimes on multiple rows and I'd like to merge the two other columns together so that the ...
0
votes
1answer
87 views

How do I split multiple rows / insert a row below every existing row, in any spreadsheet program?

I use a spreadsheet to keep track of journeys in a lift-club. Each day has its own row, and the number of lifts given to a person will be 0, 1 or 2. I realized that the algorithm for the lift scheme ...
0
votes
1answer
112 views

Creating a document (e.g,, MS Word) attachment in Gmail from a spreadsheet script

I've created a document file in the spreadsheet script. What I want to do is, from the script, create an email message with the document file (NOT a PDF) as a Gmail attachment. I spent about 2 days ...
0
votes
1answer
606 views

How to apply formulas, validation to newly added row (using add more rows at the bottom not using insert)?

I have formulas and validation in columns D, E, L, M and N. I want these formulas and validation to be automatic whenever I add rows using the option "Add more rows at the bottom". Not using insert ...
0
votes
1answer
307 views

How can I record the date/time when a new row is added?

I want to add a date value when a new row is added in Google spreadsheet. I have seen the script on Add a 'creation date' value when a new line is edited, but I was not able to modify the code to my ...
0
votes
1answer
26 views

IF Formula where X = an unidentified (but stable) #

I really think this should be simple - but I am stumped. Please see image. All I want is that my clients be able to put an "x" in the tasks they want performed. Each has an associated cost, which I ...
0
votes
1answer
63 views

Can't figure out SUM formula

This is the formula I am trying to do: =SUM(D9:D14)*2.55, (D16:D23)*3.90, (D25:D32)*6.40, (D34:D41)*10.60, (D43:D46)*10.50, (D48:D51)*6, (D53:D59)*3, ...
0
votes
1answer
113 views

Making a header row in a Google spreadsheet

Is there a way to put text in a row at the top of a spreadsheet, like a header? So it is separate and fixed from the columns below it? In other words, I want a header row at the top and the columns ...
0
votes
1answer
46 views

How to restrict the number of entries for a particular column in shared spreadsheet using Google Drive

I want to create a spreadsheed using Google Drive in which some columns entries should be retricted based on given value. E.g.: I have some columns named users, item1, item2. In columns item1 & ...
0
votes
2answers
3k views

Mail merge from Google spreadsheet to Google doc

I want to print out tests for a class I teach, but I want each to be identical except for the name of the student at the top. I want this to be drawn from a Google spreadsheet that I've created that ...
0
votes
1answer
146 views

Help with a conditional formatting script in Google Spreadsheets

I'm having the following problem: If text values are similar in Column B then gather $$ values found in Column M and display the mean of those fields in Column N.
0
votes
2answers
267 views

How do I link two Google Doc spreadsheets so that entering a numerical value in one cell of Sheet 1 produces an 'x' in the same cell of Sheet 2?

I know about the importRange function to link two sheets, but I wonder if there's a way so that when a cell's contents are imported to the second sheet, the second sheet will autopopulate the ...
0
votes
1answer
67 views

How do I reference a second sheet column across a row of numbers in sheet 1

I'm trying to look-up a value in sheet 2 from a number on a row in sheet one: it looks like this: Sheet 1: Row4 Number of units 0 5 25 10 15 And sheet 2: column a column b 1 2 3 ...
0
votes
1answer
237 views

How to GROUP and ORDER data in a Google Spreadsheets?

I want to group and sort a particular data set. I've prepared the data using a QUERY function and using other functions. Can I order by sum? This is an example file I created: order by sum
0
votes
1answer
1k views

Auto date added to adjacent cells when data is entered

I am trying to create a spreadsheet to track student loan outs that will automatically put the date in an adjacent cell. The spreadsheet would be set up like this: Column 1 would be "name" Column 2 ...
0
votes
1answer
119 views

How do I select a range programatically in Google Spreadsheets?

I have a spreadsheet like this: active date name 1 1-Jun-2013 Paul 1 4-Jun-2013 Sheela 1 8-Jun-2013 Paul 1 2-Jul-2013 Henrik 3-Jul-2013 Henrik ...
0
votes
1answer
73 views

Copying data, based on the value in a cell

I've been trying to work out how to copy data from cells on a worksheet into another based upon the value in a cell. We have weekly data so for arguments sake Week 1 Week 2 Week 3 Week 4 ...
0
votes
1answer
376 views

Google Spreadsheet Timestamp for columns B & D?

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 ...
0
votes
2answers
630 views

Google Spreadsheet - total of column if adjacent cell is true and minus another column

I have data like in the following table: +---+-----+-----+ | A | B | C | +---+-----+-----+ | 0 | 5 | 30 | | 1 | 0 | 30 | | 0 | 15 | 40 | | 1 | 0 | 40 | | 1 | 10 | 50 | ...
0
votes
1answer
397 views

Excel to Google Spreadsheet problem

I emailed an Excel spreadsheet as an attachment to my Gmail account. I then chose open as a Google Spreadsheet. When I opened the Google Spreadsheet, it was missing some formulas and had changed some ...
0
votes
1answer
126 views

Changing the A B C … column labels

The picture above shows what I am referring to. I'm looking for a way to change these " A, B, C, ..." labels to describe better the content below each. A would contain what date, B what length I ...
0
votes
2answers
4k views

Google Spreadsheet: how to get value of cell by row key and column key

Suppose I have a workbook with two worksheets, data and view. data is structured in "database" style, i.e. with a single header row and unique keys in the first column, e.g.: Country GDP ...
0
votes
1answer
71 views

autofill the 'Average' function in Google Spreadsheets

I have a column of data. Each cell in the column represents a new day. So the 1st cell is for the 1st day and the Nth cell is for the Nth day. I want to add a 2nd column where the Nth cell in that ...
0
votes
1answer
910 views

Google Spreadsheets mixing up x- and y-axis on line chart, no option to change it

For some reason Google Spreadsheet insists on using the data I wish to have for my x-axis as my y-axis. Here I'll show what happens when I try to use my data to form a chart, and what happens when I ...
0
votes
1answer
2k views

How to apply formula to WHOLE column and automatically add this formula to new created rows in this column?

I need some kind of "autoincrement field" in my spreadsheet. I've added =ROW() formula to first column. But as I'm adding new rows - I have to apply this formula to new created rows as well. Is there ...
0
votes
1answer
2k views

Google Spreadsheet: Adding formulas to Google Forms

I have a sheet with form data in several columns, say A:G. Some of the data are numerical and I'd like to have some calculations done on them, e.g. in columns H through J. I have already found out any ...
0
votes
1answer
288 views

Google Spreadsheet won't display the leading space in the cell

For following graph, the Google Spreadsheet won't display the leading space before android:xxx. How could I enable it or how could I add a leading space ? <set ...
0
votes
1answer
2k views

How do I get an onEdit script to run on a Google Spreadsheet for all users

I created an onEdit script which re-sorts a Google Spreadsheet every time a cell is edited. The Google Spreadsheet is shared amongst multiple users and I'd like the script to run for all users, every ...
0
votes
1answer
521 views

Apply conditional formatting rules to Google spreadsheet column past set limit (10)

Limit to conditional formatting appears to be 10 per column. Any work around except creating another column next to it for those additional rules or functions, then copy/paste data from one column to ...
0
votes
1answer
1k views

Password protected online database or spreadsheet [on hold]

I have a client that wants a simple online database or spreadsheet solution. Requirements Custom fields and field types (text, images) CRUD contents through a web GUI Password protected (single ...
0
votes
1answer
297 views

How to read a multiple values in cell in each row (separated by comma) in a Google Spreadsheet

I have problem in reading cell with multiple values and comparing the each value with column from a-z if match found then set value of the cell has '1'. Problem: I need to take multiple company names ...
0
votes
1answer
74 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 ...
0
votes
1answer
418 views

Get Published Google Doc in JSON

I have a published Google Doc at https://docs.google.com/spreadsheet/pub?key=0AtjON-ccqVTgdDhKeGx0UlZpUWUyLTFZV2szQlJyNnc&output=html that I want to retrieve in JSON. I've been trying this but ...
0
votes
1answer
93 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 ...
0
votes
2answers
2k views

Google Docs Spreadsheet ImportHtml() with Basic Auth

Within a Google Docs spreadsheet, I need to access external data that requires basic authentication. Usually I would include external data by putting this in a cell: ...
0
votes
1answer
188 views

How can I have column E copy its data into the right column based on the initials in column M?

So what I have so far is a spreadsheet that will auto time stamp column N when my technicians enter their initials into column M. Now the 2nd thing I would like the spreadsheet to do is. When I ...
0
votes
1answer
104 views

I need a formula that returns how many times a unique value appears in a given date

In a spreadsheet in Google Spreadsheets, I’m trying to solve this: 17/02/2012 banana 17/02/2012 banana 17/02/2012 banana 17/02/2012 apple 18/02/2012 apple 18/02/2012 apple I need a formula ...
0
votes
1answer
2k 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 ...
0
votes
2answers
481 views

How can I link 2 cells in Google Docs in the same document, on the same spreadsheet?

How can I link 2 cells in Google Docs in the same document, on the same spreadsheet? I have a headings and every time I have to scroll down to the one I need. Can I create some kind of "header" on ...
0
votes
1answer
505 views

Referencing a cell range relative to the bottom of a sheet

I am developing a "Daily Personal Inventory" spreadsheet based off a related Lifehacker article. I've successfully made a few modifications based on my own circumstances/goals, but there is one ...
0
votes
2answers
1k views

Editable google spreadsheet on Google site - assign username

So here is what I am trying to do: Have a Google site that has an embedded editable Google spreadsheet on that allows end users (if they have been given permission) to edit the spreadsheet. Here is ...
0
votes
2answers
2k views

Sum of numerical values excluding formulas in a Google Spreadsheet

I have a long column of numbers in Google Spreadsheet, and occasionally there exists a cell that sums some of the cells below it. For example: =SUM(2:4) 5 10 30 =SUM(6:8) 40 10 10 ...
0
votes
1answer
337 views

Working with names in Google Docs Spreadsheet

I have created a spreadsheet to keep track of my players on my team, I would like to sum all of their individual times playing regardless of who they played (different players). Is this possible? ...
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. ...
0
votes
1answer
164 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 ...
0
votes
0answers
13 views

How to contour data from a Google Spreadsheet?

Google has a lot of cool things such as Spreadsheet Mapper, Fusion Tables and Google sites. I have a Google Spreadsheet with data in the following format: latitude, longitude, humidity How ...