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

learn more… | top users | synonyms (2)

0
votes
1answer
97 views

google spreadsheet filter, string equivalent

Columns D, E, and F store names that represent 2-3 person teams assigned to the name in column A. The teams are assigned to multiple names and thus appear in multiple rows. The teams' composition ...
0
votes
1answer
155 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
854 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
708 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
27 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
435 views

List of Dates of Current & Previous Month in Google Spreadsheets

I want to have the dates of the current month and the previous month automatically get populated. So I'm using =MONTH(NOW()) to get the current month and =MONTH(NOW())-1 to get the previous month. ...
0
votes
1answer
65 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
3answers
3k views

Counting unique values based on multiple columns

I am working in Google Spreadsheets and trying to do some counting that takes into consideration cell values across multiple cells in each row. Here's my table: |AUTHOR| |ARTICLE| ...
0
votes
1answer
48 views

Prevent the cell from expanding to the size of cell contents in a Google Spreadsheet every time I open it?

I know how to "Wrap text" to make this happen, but my issue is I am having to do this EVERY time I open a spreadsheet in Google Docs. It is a quick couple of clicks, but it adds up. Is there a way to ...
0
votes
1answer
159 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
51 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
1answer
169 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
426 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
76 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
443 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
140 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
77 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
2answers
46 views

Google Spreedsheets Maths Date [closed]

In column A, I have today's date 18/06/2013 and I want to add 25 days to it, but because I have a list of 100 dates (all different) I need to do the same thing that =DATE(2013,06,18)+25 would do but ...
0
votes
1answer
512 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
867 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
153 views

How do I populate a cell in one spreadsheet to a cell in another spreadsheet in the same workbook in google docs?

In Google Spreadsheet, I have created a master spreadsheet that I complete with the amounts of the items needed. I would like those numbers to auto populate in each individual spreadsheet in the ...
0
votes
1answer
312 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
7k 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
89 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
2k 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
3k 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
3k 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
369 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
3k 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
717 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 [closed]

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
451 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
91 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
466 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
118 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
207 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
115 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
3k 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
554 views

How can I link to a cell in Google Spreadsheets?

I have a headings and every time I have to scroll down to the cell I need. Can I create some kind of "header" on the top of the page and just click on the header I want and it will automatically ...
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
368 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
185 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
24 views

Google Spreadsheet, Google script, calculate

I want to grade my students and give them feedback. So they make an excercise, I will give them the feedback if they do it perfect or not perfect. I want also give them grades. Question: So I have ...
0
votes
0answers
12 views

Extraction of integer value from dropdown list inside the same cell?

Using Google Sheets. In one cell, I have a dropdown list that is generated from a concatenation of integer ID column and name column. To get the value of the integer from the selection, I have another ...
0
votes
0answers
20 views

Solutions for Converting a PDF form to an online fillable form in google forms [closed]

Often we need to convert pdf forms like this to online fillable forms using google forms, so does google allow to programmatically create forms ? And how is it possible to convert such forms to ...
0
votes
0answers
16 views

Google Spreadsheet Time of Edit

I'm currently working on a file with my team. I would need to add a script that returns the following: For a specific column of a specific sheet, when was it edited and by whom into a comment for that ...
0
votes
0answers
25 views

How to make Sheets recognize worksheet tab colors from imported Excel workbook

I have some workbooks I'd like to upload to Sheets. Pretty much everything, from formatting to filters, makes it over reasonably well from Excel to Sheets except for one glaring exception: worksheet ...
0
votes
1answer
21 views

Create a function to copy range (values only) to a new tab at specified intervals

Looking to find a function that can copy the values only from a range I am importing from the web at a certain time. Have found a lot of functions that are similar to what I need but can't nail one ...
0
votes
0answers
35 views

Auto-update Google Client Sheet when Master Sheet is update

I have a Google Spreadsheet (Master Sheet) which pulls in data from Gravity Forms entries via Zapier. Within this spreadsheet there are 5 different worksheets. The main worksheet which contains all ...