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

learn more… | top users | synonyms (1)

4
votes
1answer
2k views

Creating a function that runs when a Google spreadsheet is opened

I want to create a function which runs automatically when the spreadsheet is opened. This function will make the selected cell the last cell without text in a certain column. Basically, I don't want ...
1
vote
1answer
1k views

Google spreadsheet sorting messes up cell comments

I'm running into this weird problem with Google spreadsheets: if the cells have comments on them and I sort the spreadsheet, the rows sort but the comments stay in the same position, and don't move ...
1
vote
0answers
232 views

How to Create a Dynamic SubTables Based On Data From Another Sheet? (Google Spreadsheet)

I'm wondering if there is a way to create a sheet with dynamic subtables based on data from another sheet in google spreadsheets? Each student will use a form to enter data to sheet: "Entries" like ...
14
votes
2answers
15k views

How to group data in a Google Spreadsheet?

I have the following table in a Google Spreadsheet: Name | Value A | 10 B | 100 A | 20 B | 200 C | 1000 How can I create another table based on a query: select name, sum(value), ...
1
vote
0answers
79 views

Filtering Form Feedback using Google Docs

Does anyone know how to filter respondent feedback into different sheets on the spreadsheet? For example, each sheet collects information for separate classes and I want the form information to be ...
5
votes
2answers
7k views

How to sumif with multiple criteria

My sheet looks like this: 1|A | B 2|amount | source 3|173.00 | bank1 4|173.00 | cc 5|173.00 | cash 6|173.00 | bank2 7|173.00 | cc 8|SUM This is simplified but what I want to do is Sumif A3:A7 ...
1
vote
1answer
113 views

Stop lines in GDocs chart overlapping/obscuring other lines

How can I stop lines in GDocs chart overlapping/obscuring other lines? See for example the green line in the graph below, which starts up high, butthen goes behind other lines such as the yellow one. ...
3
votes
1answer
174 views

Google Spreadsheets Calculation/Reinput Automation?

I have a little basketball stats sheet, and a cell that has a total of a specific player's statistic they have accumulated throughout the season. But there is no way I know of to update this cell ...
3
votes
1answer
148 views

Published Google Docs spreadsheet: one data set with 3 sheets each sorted differently

Is it possible on a published Google Docs spreadsheet to have 3 individual sheets, each sorted differently from the common data, and only update the common data?
1
vote
0answers
661 views

Table of Contents in Google Spreadsheets

I'm curious to know if there's a way to create a table of contents within a Google Drive Spreadsheet. I would like to be able to set the active cell in the spreadsheet based on what cell (or contents ...
1
vote
1answer
112 views

Javascript string() function in Google AdWords

Is there a simple way to implement the Javascript string() function in the basic Google AdWords interface? I want to pass some variables returned from a campaign management script to a spreadsheet ...
1
vote
1answer
1k views

How can I prepare a Sparkline graph (line/bar) in a Google spreadsheet?

How can I prepare a SPARKLINE graph (line/bar) in a google spreadsheet? With the google drive help it doesn't work for me. Reference: Google Drive Help
0
votes
2answers
881 views

How to use LEFT function in COUNTIF

I have a column that sometimes has B and sometimes B - somecomment. I want to count all instances of B. I expected it to be something like =COUNTIF(B14:B943, LEFT(B14:B943,1) = "B") But no dice. ...
4
votes
2answers
4k views

How do I mix formats in one cell?

I've got a string like ="Daily Avg: " &AVERAGE(C3:C13) I'd like to be able to apply number formats within my cell's formula. Is this possible without custom scripts? I've searched Google's ...
6
votes
4answers
11k views

Leading zeros in google spreadsheet automatically removed

I have a column in which all inputs are numbers. But these numbers are actually not real numbers. Not real in the sense, 050 in this case is very different from 50 The problem is that whenever I add ...
4
votes
3answers
6k views

Summing up spreadsheet data when a column contains “#N/A”

I am using Goggle Spreadsheet to work up some historical stock data and I use a Google function (=googlefinance=…) to import the historical closing prices for a stock, then I work with that data ...
2
votes
1answer
542 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
240 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 ...
-1
votes
1answer
416 views

importxml is not working properly -Google spreadsheet

find attached link for my Google spreadsheet in which i tried to pull out the data from booking.com. i retrieved Hotel name in column. it successfully retrieved the hotel name. but not work with ...
6
votes
3answers
776 views

Sorting data in Google Spreadsheet by cell entry

I have a Google Spreadsheet that lists various events. Students have entered their name next to events that they would like to sign up for. It looks like this: Each student may sign up for more ...
6
votes
4answers
1k views

Google Spreadsheets equivalent of Excel CLEAN() formula

I've created an Excel file where a non-technical co-worker of mine organizes a bunch of data into rows and columns. I then have formulas concatenate across those rows and columns and add some HTML ...
2
votes
1answer
3k views

Can I sum based on a specific cell text value?

I have a spreadsheet for tracking sales leads. Each row is a lead. One of the columns is called "Status" and the options under this column are limited to a list of 4 options, i.e. Prospect, Proposal, ...
1
vote
1answer
2k views

How do you add a date created to Google Forms / Google Spreadsheets

We have a Google Spreadsheet It has a few columns Issue Raised By Date Raised We've turned this into a Google Forms which we want anyone in the business to be able to answer. The problem is ...
2
votes
1answer
456 views

Is there a way to insert a bookmark into a google Spreadsheet?

I know you can do this with a Google Doc, but how about a google Spreadsheet? I'd like to have a bookmark and then link into that cell of the spreadsheet from an HTML document.
2
votes
1answer
1k views

How can you write queries in a Google spreadsheet so that the columns are kept up to date?

Using Google Docs/Drive Spreadsheets, you can write queries. However, if you have column letters in quotes, then they aren't updated as column order changes. Is there a way to write these queries so ...
0
votes
1answer
8k views

How to link two spreadsheet of Google Docs [duplicate]

Possible Duplicate: Can we do a link between two Google Docs spreadsheets? I'm trying to link two Google spreadsheets. I don't want to merge I would like to have a spreadsheet with the ...
2
votes
1answer
409 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 ...
4
votes
1answer
4k views

Auto create and name new sheet in Google Spreadsheet

How can I automatically create and name new sheets in a google spreadsheet from a list of names, such as a student roll sheet? I would like each new sheet to be created when I add corresponding names ...
2
votes
1answer
697 views

How to use a named column in a calculation based on a cell value in Google Spreadsheet

Playing with named ranges, I discovered it is possible to name a whole column (say "September") and use it in rows: =September*K4 What I'm trying to achieve now is that the value of the column ...
4
votes
2answers
688 views

How can I dynamically format the diagonal cells in Google Spreadsheet?

I want all of the diagonal cells (A1, B2, C3, D4, E5, etc) of a Sheet to be formatted as Black Background, White Foreground. Is there any way to do this for a Sheet that constantly increases in size? ...
3
votes
1answer
6k views

Is it possible to refer to a whole column in Google Spreadsheets using R1C1 format?

In Google Spreadsheets I often use A1 notation to refer to a whole column: A1:A For reasons I explain below, I'd like to use R1C1 format, to refer to a whole column, something like: R1C1:C1 It's ...
4
votes
3answers
15k views

How can I automatically set “last updated” cell in row Google Docs Spreadsheets?

How can I automatically set "last updated" cell in row Google Docs Spreadsheets ? I want to create a column where the cells' value will be automatically set to when that row was last amended. Is this ...
0
votes
1answer
2k views

Reseting responses in a GoogleDocs Form

I want to reuse a GoogleDocs Form, with (almost) the same Form, but with fresh Responses. I did copy it, but I don't know how to reset responses (not reseting the form itself, i.e. Form/Delete Form). ...
0
votes
2answers
696 views

Store form data to Google Docs

I have a webpage where i am having a textbox preferbaly for storing email address. I need to create an email intake database where i need a simple database built to store emails of users “signing ...
4
votes
1answer
3k views

How can I copy cell values rather than references from one sheet to another in Google Docs?

How can I copy cell values rather than references from one sheet to another? Right now using Filter, Query and ArrayFormula creates references which create empty cells and disallow sorting of the ...
7
votes
10answers
17k views

How to set a Google Docs Spreadsheet cell format to bare text?

I am to store international standard phone numbers (starting with a plus sign followed, usually, by plain numbers) in a Google spreadsheet column. An example of such a phone is +420123456789 When I ...
2
votes
1answer
1k views

Is it possible to use Google Spreadsheets to post to a web service?

I was wondering, as a thought experiment, if it were possible to use Google Spreadsheets to post to a web service. For example imagine you created a spreadsheet for guests attending a party with ...
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: ...
1
vote
1answer
915 views

Updating data validation for a group of cells

I have a spreadsheet where a particular group of cells has defined drop down values to choose from, using data validation rules to get the list from a seperate sheet. How do I update all of the cells ...
3
votes
1answer
1k views

What is the “web clipboard” in Google Spreadsheets?

I made a chart in Google Spreadsheets and then clicked on Copy Chart. A little popup notified me that the chart was copied to the web clipboard. However, when I try to paste the chart anywhere in the ...
0
votes
1answer
200 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 ...
4
votes
1answer
2k views

Prevent the cell from expanding to the size of cell contents in a Google Docs spreadhseet

How can Google Docs Spreadsheet be prevented from expanding to the size of the cell contents? Example: The cell expands vertically to fit the cell contents: The cell expands horizontally to fit ...
3
votes
3answers
2k views

Merging Data in Google Docs

I have a survey created in Google Docs used in several classes. Each class has its data in a separate Google spreadsheet. Now I want to collate all the data into a single spreadsheet. If I simply copy ...
3
votes
1answer
10k views

Google Spreadsheet Timestamp?

I'm looking for some help with my Daily Work Log spreadsheet. I've search and read many different version of making a "TimeStamp" in Google spreadsheet. And it seems I don't have enough experience for ...
1
vote
1answer
588 views

Escape parentheses around a number in Google Docs Spreadsheets?

How do you escape parentheses around numbers in Google Docs Spreadsheets so that they don't default to displaying as negative numbers?
4
votes
2answers
487 views

Google Spreadsheets Conditional Formatting with color

I want to add a column of cells together only if the particular cell is colored green. Can I do this using conditional formatting on a google spreadsheet?
3
votes
1answer
545 views

Why is “access denied” to multisheet charts in published Google docs?

I can successfully include a chart based on a single sheet, but as soon as I combine ranges from multiple sheets, I get an access denied error. Example spreadsheet Published spreadsheet What am I ...
5
votes
0answers
431 views

Preserve formatting when referencing cells across sheets in Google Docs [duplicate]

Is there a way to show the formatting of the referenced cells from another sheet in Google docs spreadsheets? For example I have a sheet named balance with A1 having a comment and a blue background. ...
1
vote
1answer
131 views

In Google Spreadsheet, how to copy data from cell below?

Envision two rows, one up top and one below it. The cell up top is blank but the one below has 9/24/12. How can I create a function that will make the top one copy the value of the cell below it if it ...
1
vote
0answers
108 views

How to insert empty row in Google Spreadsheets when two rows are not duplicate?

I have a number of rows in a Google spreadsheet. I want to insert an empty row only when two sequential rows are not duplicate. How can I do this?