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

learn more… | top users | synonyms (2)

0
votes
1answer
52 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
171 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
437 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
78 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
502 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
145 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
49 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
541 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
910 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
160 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
337 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
95 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
378 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
740 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
470 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
97 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
2answers
796 views

Query multiple Google spreadsheets

I have the following sheets: ListA ListB ListC Note: at each sheet I have a column which contains YES or NO. How do I query all my lists (spreadsheets) where myBooleanColumn equals to YES/NO?
0
votes
1answer
471 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
208 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
116 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
2answers
560 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
370 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
190 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
7 views

Subtract Data for Graph in Google Sheets

I'm pulling data into Google Sheets via the Google Analytics plugin, and the report runs automatically, replacing the data on a sheet called Website I then (on a different sheet) have various graphs ...
0
votes
0answers
13 views

SUMIF calculation by getting data from new spreadsheet

I'm creating monthly and yearly report in google sheet (google drive). i'm trying to perform calculation by matching specific case from another google sheet. i used the below function to link with the ...
0
votes
0answers
21 views

Trying to send email from Google Sheets with image attachment

I'm trying to send an email from within Google Sheets and then format it via some joins to send to an address for my Blogger account. I need to attach the image file apparently as the image isn't ...
0
votes
0answers
49 views

Custom functions: Keep getting “There was an error during calculation”

I'm using two custom functions but for some time now I keep getting the following error when I load my sheet: There was an error during calculation; some formulas may not calculate successfully. ...
0
votes
1answer
9 views

Concatenating two columns using only filled cells in one of them

In my table, column A has row names and other columns have values: +------+---+ | M100 | D | | M130 | B | | M340 | | | P304 | F | | P400 | | | P499 | C | +------+---+ I'd like to join ...
0
votes
0answers
12 views

Clipping text (with newlines) vertically in Google Spreadsheets [duplicate]

I would like to have each row to have a height of one row of text but I would like cells to contain text with newlines (i.e., addresses) while still retaining that minimal height. Is that even ...
0
votes
0answers
43 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
17 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
17 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
34 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
0answers
43 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 ...
0
votes
0answers
16 views

How to plot a graph with random time intervals in Google Spread Sheets?

I want to create a line chart using a hours of the day on the Y axis. My data appears at random time intervals, eg: 9:00, 9:35, 10:35, 10:50, 11:30, Is there a way I can incorporate this into a ...
0
votes
0answers
23 views

Send to respondents a number between 1 and 10 using Google Forms?

My idea is to give to respondents by mail a number reference between 1 and 10. The idea works as follows: You have 10 boxes. When a response is submitted, automatically the form will send a email ...
0
votes
0answers
118 views

Google Sheets: Error- Array result was not expanded

For cell J129 I'm using the following formula =index(B122:122,1,counta(B122:122)), but I keep getting an Error that says, "Array result was not expanded because it would overwrite data in K129." I'm ...
0
votes
0answers
18 views

Conditional deleting in Google Spreadsheets

I'm using two sheets, one with the main values and reference datas. The second sheet is for price calculation. I use =Filter to get the values from sheet one where Sheet1!E2:E <> 1. How can I ...
0
votes
0answers
52 views

How can I make Google Spreadsheet recognize dd/mm/yyyy format as a date?

I have a table copied over from other applications to a google spreadsheet. Before processing, I noticed google spreadsheet doesn't recognize 'dd/mm/yyyy' (e.g. 15/01/2015) as a date, instead it treat ...
0
votes
0answers
38 views

Formulas mix up references when sorting data in Google Spreadsheet

I have a Google Spreadsheet that has formulas embedded into various cells. When I sort the data, the formulas always get messed up, and no longer pull data from the proper reference cells. How do I ...
0
votes
0answers
30 views

Google Sheets Query Formula Needed

https://docs.google.com/a/fivetowns.net/spreadsheets/d/1myKz4WpRAt3Kja__Dsddnr3YtfOjVPkYUOTXoi-4exc/edit#gid=1665161315 Above is link to mock up of my spreadsheet. I would like to build a formula ...
0
votes
0answers
100 views

Google Sheets trendline broken; file unavailable

In Google Sheets, I've created a line graph. I want to add a trend line. I do so by clicking the blue line and selecting Linear from the trendline dropdown. No trendline appears. Then when I right ...