A productivity application from Google that allows you to create and edit worksheets

learn more… | top users | synonyms (2)

2
votes
1answer
2k views

Creating duplicate Google spreadsheets that filter data from a master sheet and update rows on master sheet

Basically, I have a huge list of data on Google Docs spreadsheets, and a bunch of people that read it. They are not tech savvy. I am trying to create duplicate sheets on a Google spreadsheet that are ...
2
votes
1answer
249 views

Flatten (pivot) table into a three column array on a Google Spreadsheet

I have a table which looks like this: A B C D 1 red blue green white 2 blue red white yellow 3 red blue green white 4 red blue green white and would like to get a ...
2
votes
1answer
938 views

Google Spreadsheet not loading

I have a Google Spreadsheet with a lot of very important data and some scripts that where working well. At some point, the browser crash and I reload the page. After that, I can't access that (only ...
2
votes
1answer
1k views

Get YEAR() and MONTH() from a string like “September 2013” in Google spreadsheet

I have a sheet with column A listing the month of the year in human readable format e.g. "December 2013", and column B listing a calculated value of bills issued in that month (from another sheet). I ...
2
votes
2answers
2k views

How to do a Google Spreadsheet equivalent to SQL's JOIN and SUM( )?

I have this table: | A | B | |---------|-----| | grocery | $10 | | clothes | $40 | | grocery | $19 | etc. So I'd like to have a column with an aggregation of the categories like grocery ...
2
votes
1answer
514 views

Error using “sumif” together with “address” function

Please see the data below: What I want to do is to write a formula in column D to sum up the order quantity (column C) starting from the row no. specified in column F until current row, for the ...
2
votes
1answer
169 views

Geocode in Google spreadsheets, keep results

I have a form for internships and I am passing over the address of the internship provider to a function which gives me latitude and longitude for it, which is then consumed by a webmap using tabletop ...
2
votes
1answer
810 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 ...
2
votes
1answer
133 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 ...
2
votes
1answer
1k 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
2answers
5k 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 ...
2
votes
1answer
380 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
1k 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
231 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
1answer
80 views

A simple spreadsheet sorting

In a Google Spreadsheet I have different groups of cells in one column to auto-sort. All cells in this column have same pattern of data, all datum have it's own cell and it's needed to be sorted into ...
2
votes
1answer
149 views

Custom Actions in Google 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 ...
2
votes
1answer
1k views

How to automatically open a created text document after it being created

I've used this script to create a Google Document (like word document) with Google Spreadsheet. But, when I do so, the new text document created from a template is placed in the default chosen folder. ...
2
votes
1answer
2k 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 ...
2
votes
1answer
295 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 ...
2
votes
1answer
1k views

If cell equals a value then move row to different Google Spreadsheet

I've got a script that sorts a Google Spreadsheet when a value in a column is changed. I'd like to add to the script the following functionality: If the value for column E = "Complete" then the ...
2
votes
1answer
241 views

google spreadsheets timesheet calculations

I have a timesheet that I use to log my time. It works fine if I log in and log out. It works at the end of the day but doesn't work in all configurations. For example, I want it to work if I only ...
2
votes
1answer
229 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 ...
2
votes
1answer
574 views

ARRAYFORMULA Using Row Above - Google Spreadsheet

I would like to create a column that contains a running decrementing tally, but is decremented by an amount from a different column on the same spreadsheet. Also, I would like to be able to add rows, ...
2
votes
1answer
342 views

How to do a date formula in Google Spreadsheets

I have to do a query that increments automatically the date year by year. For example I use this formula: =INDEX(query('Scheda Intervento'!C3:K14;"select sum (K) where (F >= date '2013-01-01' ...
2
votes
1answer
875 views

“Yes” if a value partially matches in a range of values, blank otherwise

I have a column of values (column A for this example) like such: Phytophora sojae Phytophora ramorum Cryptococcus neoformans Coccidioides posadasii And I'd like to create a new formula column (B) ...
2
votes
1answer
754 views

How do I reference multiple cells in one sheet in one cell in another sheet?

I am using Google Sheets and I have two sheets in one document (SHEET1 and SHEET2). I want to be able to use a formula that allows me to: If cell A1, B1, D1 and F1 in SHEET1 have an s in them Then ...
2
votes
3answers
3k views

Google spreadsheet connect with database and fetch data to cells

I have been wondering about this for a while. We are using those google spreadsheet a lot with my colleagues and the thing is that we always have to write down data that we already have in our MySQL ...
2
votes
1answer
622 views

How can I make text flow out of a cell as it does in Excel?

If you enter a long bit of text into a cell in Microsoft's Excel the text flows out of the cell over the top of the adjacent cells. This doesn't happen by default in Google Spreadsheet - it flows ...
2
votes
1answer
782 views

Enabling script to run as author in a shared Google spreadsheet

I created a spreadsheet that I'd like to share with anyone with the URL. The sheet contains several app script functions. These functions both change the content of the sheet and copy data to ...
2
votes
1answer
518 views

Show 'sum' when multiple cells selected in Google Spreadsheet

If I select multiple cells in a Google Spreadsheet, sum or count appears at the lowerright corner according to the data type. Sum is shown for numbers, and count is shown for characters, dates or ...
2
votes
1answer
517 views

How get last added text from column into different sheet

How can I get the last added plain text from a column in sheet1, which also has empty rows, into a cell of a sheet2? With help I managed to do this with the last added date, but with plain text I am ...
2
votes
1answer
2k views

How to make a ratio win:total with only integers and least terms

So basically I am trying to find a way to show a simple ratio of wins vs total games. for example: 2 wins on 5 games would give me a ratio of 2:5 5 wins on 15 games: 1:3 8 wins on 18 ...
2
votes
1answer
142 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 ...
2
votes
1answer
1k views

Calculate monthly sum() on pivote table

I have a Google Form. Upon submit following fields are populated: Timestamp Product Description Unit Price Quanitity I have generated a pivot table from this data, in a Google Spreadsheet. The ...
2
votes
1answer
291 views

google spreadsheet question about data linking between sheets

Here is my spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AgmD6-Z4d2aVdE9pR095OTJrVE1wS3FIZzZpVFRJMmc#gid=4 What I want to happen is I enter data in the sheets marked Head, Neck, Shoulders ...
2
votes
1answer
3k views

Google spreadsheet sync with gCalendar

I create a GTD system based on excel, whose link I report here. The advantage of having this gtd is that I can share it with my european colleagues without the need of having a dedicated software ...
2
votes
1answer
1k views

Sorting a protected range in Google spreadsheets

I've been trying to make the spreadsheet automatically sort some data, and after some searching I found this post: Automatic sorting. It works just perfect with my permissions as the owner, but when ...
2
votes
1answer
654 views

In Google Docs, how to make a column with several numbers in each cell sortable?

I am making an expenses spreadsheet in Google Docs and I need to list the numbers of the attachments for each entry. Sometimes this is just one number, sometimes it is several. I can make this ...
2
votes
1answer
723 views

Pre-populate Google Docs form field with incremental value

I have a Google Docs spreadsheet that I use to track my jobs by job number. Is it possible to have the "job number" field pre-populated with the next job number? Currently I have to open the ...
2
votes
1answer
554 views

In Google Spreadsheets how do I restrict input when the number of entries for a condition are met?

I am using a Google spreadsheet to gather the Registration form entries for our tournament. We can only have 10 teams per age group. How do I "close" the Registration when the number of entries for ...
2
votes
1answer
455 views

Text conditionals in Google Spreadsheets

I want to write a formula where I can add values to a cell whether another cell states approves the "transaction". It will be easier to explain with an example. Consider a spreadsheet containing the ...
2
votes
2answers
1k views

How can I set conditional formatting on particular cells that depend on another cell's value in Google Spreadsheets?

I would like to colour the background of a row in Google Spreadsheets: For example: If cell Dx = title 'To do' or 'title 'Done' then cells Fx to Nx are filled colour black. If cell Dx = title ...
2
votes
1answer
1k views

Is it possible to add conditional formatting when number changes?

This is probably not possible but... I'm looking to update cells in a Google spreadsheet using the conditional formatting tool.(Changes to SERPs rankings) So when the number in a cell is changed, ...
2
votes
1answer
2k views

Transfer cell value to another cell by clicking on a button in Google Spreadsheet

I want a user to be able to click on a button and have the value of one cell go into another cell. How can I do this?
2
votes
2answers
2k views

Create a dropdown list of options from VLOOKUP

What I'd like to do is get a dropdown list of options from a VLOOKUP type function where I can select the value for the next lookup. Example Here the data I'm using for reference. Notice "AAA" ...
2
votes
2answers
604 views

Allow users to use my online spreadsheet in Google Docs without saving their edits

I made an online spreadsheet in to calculate grades. I want my users to use it without Google Docs showing it real-time to other users. How do I do this? It seems if I allow people to edit the ...
2
votes
1answer
1k views

Bring data from Google Spreadsheet to Google Documents

Is there anyway to read the data from a Google Spreadsheet (which I owh) to another Google Document, something like specifying a data source in MS Word?
2
votes
1answer
551 views

Send Google spreadsheet with embedded HTML in Gmail

When I try to publish content from Google Spreadsheet, it puts it into an HTML iframe. This is found under File > Publish to Web. How can I send this iframe content in a mail, sent over Gmail?
2
votes
1answer
1k views

Duplicating a set of columns with various widths within the same spreadsheet

I'm trying to duplicate a set of 5 columns multiple times on the same sheet. For example, column A is wide, columns B & E are medium width and Columns C & D are narrow. I want to duplicate ...
2
votes
1answer
175 views

Update a cell based on two matching fields in separate tabs within a range

I'm trying to update a cell in Google Spreadsheets where its value comes from another sheet and based on the date range entered with it. Here is what the two worksheets look like in the file. ...