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

learn more… | top users | synonyms

0
votes
0answers
75 views

Sending emails to specified end users

I'm trying to write a script to send emails from a google spreadsheet. My specifications are: Send email upon form submit Only send to email address listed on form I have written a sendEmail ...
3
votes
1answer
98 views

Can I insert an hyperlink into a non empty cell of a Google Spreadsheets documents?

my problem is that if I add something like this in an empty cell of a Google Spreadsheets documents it work great =HYPERLINK("www.google.co.uk"; "Google") But If I add this link to a non empty cell ...
1
vote
0answers
52 views

How to automatically “start a new paragraph”\“full stop” in a cell ?

I have some problem to set the automatic start of a new line in a cell of a Google spreadsheet without press CTRL + every time that I want a new line in a cell. I have try to do as specify in this ...
5
votes
3answers
883 views

Cell reference with colour formatting

Is it possible to reference a cell in Google Spreadsheets so that cell where it gets displayed also displays it using the same text and cell colour formatting? =A1 Will only reference dell's value. ...
1
vote
1answer
407 views

Google spreadsheets—sum cells from another row based on a cell value

My current code is: (SUM(INDIRECT(ADDRESS(ROW()-(I4:I- 1);COLUMN()-4;4)&":"&ADDRESS(ROW();COLUMN()-4;4)))*( ( J4:J ) / 10 )))) I want to sum cells from Gx – Gy but range is determed by cell ...
1
vote
1answer
136 views

Run a custom script more than 20 times in Google Spreadsheet

I need a way of running a custom script more than 20 times in my spreadsheet. I'm creating a class assessment spreadsheet that will be used as a master across my school, and it needs to retrieve the ...
1
vote
0answers
53 views

Google Spreadsheet protected cells

I have created my spreadsheet with protected cells scattered throughout the document in google docs. Now I want to duplicate the spreadsheet and have the protected cells in the new worksheet keep the ...
3
votes
1answer
584 views

Sum a column except current cell

Is it possible to sum all values in a column EXCEPT the value in the current cell? That is, the cell that is to hold the result. With a normal SUM(E:E) command the result is #REF! with a Circular ...
1
vote
1answer
89 views

Google Sheets: 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 coloumns in MORE THAN ONE sheet (in the same document)? I namely need to ...
1
vote
1answer
504 views

Dependent validation in Google Spreadsheets

Here's what I'd like to do. The first selection is Subject (as in a school course). There are 5 subjects. Then there are three sub-selections in drop down lists for each subject: Subject Test Type ...
0
votes
1answer
100 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 ...
2
votes
0answers
178 views

Microsoft Excel 2010 is password protected but opens in Google Spreadsheet showing all locked and hidden formulas

This is a huge problem. When we email a password protected Excel file with hidden and locked cells to protect formulas, they open on a Droid showing and allowing manipulation of all protected ...
0
votes
0answers
36 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 & ...
2
votes
1answer
160 views

Google Spreadsheets: IF not working

I have problems with my IF command in Google Sheets. If gives #ERROR! all the time. See this simple test: Not even if I put in the number directly and avoid references: Am I using the IF wrong? ...
0
votes
0answers
43 views

Using a dynamic OFFSET & ISBLANK() function

I have a spreadsheet I'm working on that we use to run large corporate events. Each segment length has a length as well as corresponding start time. I want each cell in the time column to look above ...
1
vote
2answers
1k views

IF statement in Google spreadsheet

I am trying to sum up the total of all values in a coloumn that are POSITIVE. Also, I have some subtotals in the coloumn that should be left out from this sum. =SUMIF(E6:E65 ; ">0" ) - ...
1
vote
0answers
41 views

Substitute for Lookup() in Google Spreadsheets

I am making a bookkeeping sheet. The aim is to create rules, that search imported fields from our bank statement, and if a match is found automatically fill the adjoining cells with the rules data. ...
2
votes
0answers
270 views

Grouping columns in Google spreadsheets (and summarize them)

Lets say I have a table like this: A | B | C 1 | 4 | 3 Is it possible to group these columns together so that I can expand and collapse them with a specific formula. For example with SUM I would ...
4
votes
1answer
1k views

Adding a header and footer to a Google Spreadsheet

I'm in the process of changing to Google Drive from MS Office for all aspects of my work. Pretty much everything I need is there, but the one thing we can't work out how to do is how to get a header ...
0
votes
0answers
111 views

Use of importdata with arrayformula

I’m using importdata to retrieve Yahoo stock information, which works fine on indivdual rows, but when combined with arrayformula to fill down the page when additional symbols are added does not ...
0
votes
2answers
2k 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 ...
1
vote
1answer
1k 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 ...
0
votes
0answers
62 views

Google Spreadsheets Validation list with Label

Thanks in advance. I have just started using Google Spreadsheets so am very new to it's ways! So far it looks incredibly powerful! I am using some data in a sheet called Jobs as a reference to ...
3
votes
1answer
186 views

Google spreadsheet: Cannot select pre-selected date in Date picker

In a Google spreadsheet, when having a cell formatted as date, or with a data validation set on date, a date picker appears when double clicking this cell. If the cell is blank, the picker's date is ...
1
vote
2answers
522 views

Show data from one sheet on another if date is today

I have a list of people responsible for data verification that are changing every day. The schedule is on one sheet. And data verification is on another. What I need is to show only responsible ...
1
vote
1answer
914 views

Can I copy row from one Google Spreadsheet to another based on certain criteria

I have a spreadsheet to track student loan outs: Column A is the student name Column B is how many loan outs they have received Column C is the class period Column D is the teacher name ...
2
votes
1answer
671 views

formulas to transfer certain data from one sheet to another

I have a list of volunteers in sheet one. They have selected what programs they want to participate in with a yes or no in the column under that program. How can I create a formula that says if this ...
2
votes
1answer
504 views

Count occurrence of a word in Google Spreadsheet

I've got a ton of cells (say 6x20) that have various names in them. I'd like to total the number of times a name in another field matches any of the other cells. Alice Bob Claire Doug Alice ...
1
vote
0answers
48 views

Link to a point in time snapshot from a Google Document revision history?

Is it possible to get a link to a Google Document that is a read-only "point in time" snapshot of the document?
0
votes
1answer
141 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.
1
vote
1answer
390 views

SUM of all cells in another column, except above rows

Each cell in column A should report SUM of every cell of column B, except rows above those cells. Sample: | A | B | --------- | 4 | 1 | | 3 | 0 | | 3 | 1 | | 2 | 1 | | 1 | 1 | | 0 | 0 | How can I ...
1
vote
3answers
241 views

Sum of two numbers with a minimum of zero

I have a Google Spreadsheet with two columns of numbers (A & B). I want to add these numbers together and put the result into a third column (Results). If the sum of these two numbers is less ...
1
vote
1answer
89 views

ImportHTML and SUM the column

I am looking to use the importHTML function for loading a page and I would like to sum a particular column in Google Spreadsheets. But I am not having much success. This is the URL: ...
1
vote
0answers
136 views

Google Spreadsheets (Query) - Conditional Formula

We're trying to create a query based off whether or not specific "Categories" have been selected. Here's an example of the categories they would select: Channels Arts & Entertainment ...
0
votes
1answer
623 views

Google Spreadsheet Change X and Y Axis

I am trying to graph the temperature of a substance versus the time the substance has been heated. My data is as follows: A | B Time (Minutes) | Temperature (ºC) 0 ...
1
vote
1answer
197 views

Google Docs: How to find and display matching value on new sheet based on two criteria

I have created a demo spreadsheet to help explain http://goo.gl/1TcQrW (This is a small set of example data, the real set has more values [and the data may or may not be there from week to week]) I ...
1
vote
1answer
103 views

Add all positive values in column

In MS Excel I can add all positive values in a column with SUMIF(A:A,">0") But this isn't working in the Google Docs Spreadsheets. The ">0" part is not parsed and gives an error. Is there ...
1
vote
0answers
122 views

Password protect a column in Google Spreadsheet

I have encountered a problem that I need a hand with. I have already done numerous searches of this forum and others to see if I could solve it that way but it appears I have come a cropper. So ...
2
votes
1answer
394 views

Can I map specific parts of a Google Form to one spreadsheet, and other parts to another spreadsheet?

Can I map specific parts of a Google Form to one spreadsheet, and other parts to another spreadsheet? Some of the responses on one will be public and viewable by anyone, but others will be private.
0
votes
2answers
245 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 ...
2
votes
1answer
210 views

Monitor webpage changes using Google Docs

I want to monitor a webpage. The best solution I found was Google Docs (apart from feed43 which has limitations). I'm using the import HTML function in Google Spreadsheet which will update the cell ...
2
votes
1answer
370 views

Drag Autofill of a Multi-Column Pattern in Google Spreadsheet

I'm trying to drag copy some cells, which are on top row for headers, they get their values from a VLOOKUP formula (Basicaly all group names are in column B and I want them as column headers). Before ...
2
votes
1answer
157 views

Grading a Google Spreadsheet by answers given in a Google Form

I'm currently working in a school and students answered a 50 question form on ICT Ability. The results of this form have been put into a spreadsheet and I have to order the names in terms of ability. ...
2
votes
2answers
650 views

Google Spreadsheets date and time format

I have lots of dates in the first column in the format August 23, 2010 at 11:01PM I was wondering if anyone knows a way to get them formatted in a way that I can then use for date and time ...
1
vote
1answer
1k views

Google Spreadsheet how to use an if statement over several cells

Is there a function that allows me to calculate the total value of column B if column A is equal to "some text". I'm making a budget for myself. Currently, my Google Spreadsheet looks something like ...
1
vote
1answer
1k views

Auto populate data in Google Spreadsheet from data in separate spreadsheet?

So, I'm in the situation where I have a Google Spreadsheet with people's names, phone numbers, addresses, etc. Is it possible to, from another spreadsheet (not sheet, different workbook), search the ...
0
votes
1answer
74 views

Get a list of items missing from array in google spreadsheet

I have a spreadsheet where I'm using the trailing set of columns as a kind of foreign key; I'm trying to throw an error if someone enters a value that doesn't exist. I'm thinking one way to do this ...
2
votes
2answers
341 views

Split, reorder, concat inline in Google Spreadsheets

I want to split a cell, reorder the pieces and recombine. How do I do that inline. For example: | name | reordered name | | Page,Larry | Larry Page | | Brin,Sergey | Sergey Brin | ...
1
vote
0answers
45 views

Publish last 5 entries from a Google Form

We currently create and html table to list our last 5 Webinars. This is done manually. We are adding external contractors into the mix and would like to give them the ability to enter basic webinar ...
2
votes
1answer
785 views

Panel with Vertical Scroll Bar that allows navigating to different worksheets

I am attempting to build a Script that would open a window with each worksheet I have in my spreadsheet, allowing me to click on the worksheet name to navigate to that sheet. I found the following ...