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

learn more… | top users | synonyms

1
vote
1answer
783 views

Google Spreadsheets Data Validation - Unique Values

I have a google sheets document which contains two sets of data in separate worksheets: Public IP addresses Private IP addresses In my private IPs worksheet I want to create a dropdown which ...
1
vote
0answers
45 views

Save mailed Contact Forms as a new row into Google Spreadsheet?

I am using Contact Forms 7 on a website, the forms that I am using are name, checkboxes, phone number, custom message, etc. A lot of people use this form and this always require me to call them up ...
1
vote
0answers
50 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 ...
1
vote
0answers
52 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 ...
1
vote
0answers
40 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. ...
1
vote
2answers
520 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
886 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 ...
1
vote
0answers
46 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?
1
vote
1answer
386 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
1answer
87 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
135 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 ...
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 ...
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
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 ...
1
vote
0answers
48 views

Automating Google spreadsheet to transfer new info

I'm looking to setup a production line with Google Spreadsheets. Here's how I intend it to work: Our Sales Rep John has a spreadsheet specific to him only. He takes in sales leads, and inputs the ...
1
vote
0answers
86 views

Google spreadsheet: protect formatting while allowing to change data

As the title says, I would like to protect the formatting of a cell (or a range of cells) in a google spreadsheet, but still allow changing the data in that (or those) cell(s). For example, I want to ...
1
vote
1answer
586 views

Data Ranges in Custom Google Spreadsheets Function

I'm trying to create a custom Function in Google Spreadsheets that takes a range as input parameter. function Example(cells){ var values = ...
1
vote
2answers
416 views

Google Spreadsheet =ImportHTML #value error for specific URL

I'm trying to get the data from http://wodindex.wikispaces.com/ into my spreadsheets. Also from a different subdomain of wikispaces.com the grabbing doesn't work. Trying to get data from this site ...
1
vote
0answers
73 views

Automatic data sharing between Google Docs files

Is it possible to automatically update information on a Google Presentation or Document based on information in a Google spreadsheet? For example, I could create a presentation that contains a graph ...
1
vote
0answers
72 views

Custom Actions in Google Drive Spreadsheet

I find that I often change specific cells from black on white to white on black when I'm making spreadsheets. It get's tedious to change the background color, then the foreground color over and over ...
1
vote
1answer
398 views

How to make a simple two column data chart in google spreadsheet? (simple case but doesn't seem to work)

I have a column with dates and a column with an amount of money. I just want to make the simplest chart possible, a line chart that shows money as a function of time, so I can see in what dates I tend ...
1
vote
0answers
270 views

How can I get a cell to change it's value based on another cell's color?

So I have three colors in column F, green, grey and red. What I want is for column G to display a number (1, 2, 3) depending on the color value of F. Is there a way to do this? Here is a link to a ...
1
vote
0answers
144 views

How do I reference only the elements of a multi-column range that meet particular conditions?

I have a spreadsheet made up of several individual sheets: one sheet for each category of product and one sheet designed to be a "global view." In each sheet is a 3-column range of variable length ...
1
vote
0answers
41 views

Relative paths to other sheets inside a Google Spreadsheet

I'm trying to put our food recipe collection into a Google Spreadsheet. On the first page we have an index of all the foods. Each recipe is located on a separate sheet. We would like to be able to ...
1
vote
0answers
180 views

Google Sheets: Reference one sheet from another, where the user may not have view access to the referenced sheet

This is what I'd like to do: The public (even you!) would have view access to a particular Google sheet. It would draw data from another Google sheet, which you DO NOT have any access to. Using ...
1
vote
0answers
84 views

Chart with points in Google Spreadsheets

I have a Google Spreadsheet with a line chart. Despite the name "line chart", the data does not appear regularly spaced on the x-axis but according to a date column. (This shows up correctly, no need ...
1
vote
0answers
72 views

Auto paste formula on form submission

I have searched and tried various solutions elsewhere but none seems to work for both conditions. I would like to have the formula: =IF($A2="Elementary", VLOOKUP($B2,'ELEM PRINCIPAL'!$B:$AA,7,false), ...
1
vote
1answer
191 views

How can I set the increment value for Google Spreadsheets to auto-increment?

I have a series of cells referencing other cells: | Row | a | b | col B shows | |-------------------------------| | 1 | 1 | =a2 | 2 | | 2 | 2 | =a4 | 4 | | 3 | ...
1
vote
1answer
98 views

Inserting rows and adding a cell reference

I'm trying to automate adding new rows if I'm on the last few rows of my sheet. It works, but since I'm also adding a cell reference to it, and checking the amount of free rows left using ...
1
vote
1answer
523 views

Paste format only in Google Spreadsheets with Chrome as the browser

I want a working keyboard shortcut for Google Spreadsheets, that lets me paste just the formatting. Google says the shortcut for copying just the formatting is Cmd+Alt+C, and pasting just the ...
1
vote
1answer
128 views

Creating multiple instances of a cell value in Google Spreadsheet

I have a Google Spreadsheet with the following data: A B ----------------------------- 1 | Number of responses | Value 2 | 1 1 3 | 3 ...
1
vote
0answers
262 views

Set a Category Filter in a Google Spreadsheet Line Graph

I've got a google spreadsheet that tracks status updates to a series of projects over time. The table rows each list a particular month (01/2012) and the columns list the status change ("Ready for ...
1
vote
1answer
377 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
155 views

How to have Google Spreadsheets automatically complete cells with previously used data

I'm using a Google Spreadsheet to fill in my mileage. Since I'm using many addresses more than once, I want to make the process of filling in easier by (like Excel or Open Office) having the ...
1
vote
2answers
357 views

How to SUM() a column from one Google Spreadsheet in another spreadsheet

Has anyone been able to return the SUM() result of a column in one Google Spreadsheet to a different spreadsheet? I am trying the ImportRange(key, criteria) but I am not having any success. I am just ...
1
vote
0answers
600 views

how to make Google Docs spreadsheet recognize data as numeric

I have the opposite of a fairly standard problem -- how do I force Google Docs spreadsheet to understand that a value is numeric? It seemed like using Format > Number should do the right thing, but ...
1
vote
1answer
503 views

Problem QUERY function in Google Spreadsheets formula

I tried this formula: =concatenate(query('Scheda Intervento'!C2:K14;"select SUM (K) where (F>= date '2013-01-01' and F <= date '2013-01-31' and C = '" & A2 &"')";0)) The result is ...
1
vote
0answers
256 views

Copying cells in Google Spreadsheets and pasting into text file adds quotes around each cell

Copying cells in Google Spreadsheets and pasting into text file (tried with XCode, Notes, Text Edit - the below applies to all) adds quotes around each cell. How can I avoid those extra quotes? Also, ...
1
vote
0answers
393 views

delay in updating referenced cells when using importrange in google drive

Im using the importrange() function in Google drive to reference data from 'spreadsheet1' and display in it 'spreadsheet2'. This works fine, but 'spreadsheet1' and then go to 'spreadsheet2' its not ...
1
vote
1answer
1k views

How do I Sum Thoughout Different Sheets

How do I create a reference to a defined interval in several sheets? Something like this: =SUM(Sheet1:Sheet2!A1)
1
vote
0answers
188 views

How to tally entries by user, date

I am using a Google spreadsheet to track entries by several users. How do I measure their productivity per day? Or per hour? I have the timestamp field, a user field and other fields, but what I want ...
1
vote
0answers
149 views

Create new document within spreadsheet and link

I would like to create a spreadsheet script that allows me to create a new document every time I click on a new cell or row and then have that document links back to that cell.
1
vote
0answers
249 views

How to protect table cells in Google Spreadsheets from myself (accidental edits)?

As in Microsoft Excel, I want to protect certain cells in Google Spreadsheet. This is possible, but asides from the fact that it is quite confusing to me, it doesn't seem possible to protect cells ...
1
vote
1answer
205 views

Conditional formatting for dates in Google sheets

I work at a language school and I have a column giving the students expected arrival date. I want to set conditional formatting to: Highlight in red any date that is older than 1 week Highlight in ...
1
vote
1answer
209 views

Count related to date items in a google Spreadsheet

I have a spreadsheet that shows how many are still completing a task at two and 8 weeks. Col A Name col B has Start a date Col C is the WeekNumber of the date from col A (Using WeekNumber Script) ...
1
vote
0answers
413 views

Google Drive Form doesn't display on Google sites if not signed in on chrome

I have a site, hosted by google sites that includes a Spreadsheet Form from google drive. Normally, the page loads, then a second or so later the form loads. In the problem case the page loads, but ...
1
vote
0answers
178 views

Google Spreadsheet: the script enabling email sending to a cc list doesn't always work

We have a Google Forms that, when filled, is sending out a list of people put on cc. This doesn't always work. How can this issue be solved?
1
vote
1answer
100 views

Google Spreadsheets: how to show the 10 most recent rows from another sheet's timestamp?

In one sheet A I have an ongoing number of rows where the 1st column is a timestamp in ascending order (more recent entries at the bottom). I'd like to have another sheet B where only the 10 most ...
1
vote
0answers
380 views

Sorting on a web-published Google Spreadsheet

I have a Google Spreadsheet that is published to the web and embedded in a website. This spreadsheet has data about hotel rooms, such as hotel name, number of rooms, date in and out, etc. I would ...
1
vote
0answers
72 views

In a Google Sheets chart how do I prevent “Other” in the legend?

When there are over 8 series in a chart (this is true at least for a pie chart) - Sheets combines all other series above the 8th into "Other" this is really counter productive when there are only 9 ...