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

learn more… | top users | synonyms (1)

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
1k 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
440 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
407 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
683 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
672 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
14k 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
687 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 ...
3
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
16k 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
900 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
198 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
570 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
486 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
535 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
129 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?
4
votes
1answer
6k views

Multiple Conditions on a CountIF?

I have a spreadsheet that is essentially a todo list for different groups. I have a column for Group and Status. Both have data validation drop downs so I can reliably match the text content. I have ...
0
votes
1answer
110 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 ...
4
votes
1answer
2k views

Generating Google Spreadsheet hyperlinks from cell contents

I have a column of cells in a Google Spreadsheet with values such as: 37683 36583 38637 32391 What I would like to do is generate a hyperlink for each cell like: http://mywebsite.com?id=xxxxx ...
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 ...
3
votes
2answers
5k views

Google Spreadsheet - Keep a variable while copy/paste cell [duplicate]

Possible Duplicate: 'Lock' part of formula when copying from one cell to another I am using in one of my spreadsheet a formula referencing to the column title (matching how many ...
1
vote
2answers
308 views

In a Google Spreadsheet, can I avoid references to cells in other sheets from breaking if I remove/add a row?

I have a spreadsheet that has two sheets. One takes entries and a second manipulates content from the first and displays results. If I remove or add a row, the references in sheet two change, killing ...
7
votes
1answer
24k views

Create a column of date in Google Spreadsheet [duplicate]

Possible Duplicate: How to extend series of dates in Google Docs? Is there a way to create a column of date easily with google speadsheets like with Excel ? In Excel, enter a date, hold ...
2
votes
1answer
536 views

Embed only cells from Google Spreadsheet and not application header

When I embed a Google spreadsheet, I get cells in my page (and this is good). But I get also the application header with toolbars (and this is bad for me). See a test here: ...
2
votes
0answers
291 views

Qualtrics + Google Spreadsheet integration

I'm looking for a way to use a Qualtrics survey as a data source for a Google spreadsheet. My client wants a google spreadsheet that automatically updates based on the latest survey results. I've ...
2
votes
0answers
265 views

Google Spreadsheet - Timetable? [closed]

I'm trying to use Google Spreeadsheets as a time report tool where I insert the number of hours worked on a project, the cost per hour & the total cost for this post. My sheet looks like this: ...
3
votes
2answers
585 views

Partial sum of columns based on row identifier

I have a spreadsheet with list of persons ("players"), and for a each person I have following values: ID number (unique) Name (just text) Score from round 1 Score from round 2 ... Score from round ...
4
votes
1answer
590 views

How do I sum different currencies in Google Spreadsheets

I have a spreadsheet where some columns are formatted in EUR, and some in USD. I would like to be able to sum them by taking into consideration the exchange rate Example: A1 = $10, A2 = €10 A3 = A1 ...
4
votes
3answers
2k views

Paste numbers as string in Google Spreadsheet

I have one spreadsheet in Google Docs with data like: 0012 0234 0065 I wanna paste in another Google Doc Spreadsheet but when I use ctrl+c ctrl+v the data is formatted like numbers: 12 234 65 I ...
4
votes
2answers
2k views

Keyboard shortcut to open a drop-down list for cell values in Google Docs spreadsheets

I'm working in a Google Docs spreadsheet where I've set up validation lists for a column. When I tab into that column as I'm editing a row, the drop-down handle appears: In order to access values ...
1
vote
1answer
3k views

Google Spreadsheet column limit [closed]

I'm working on a Google Spreadsheet and I keep getting this message: This spreadsheet is about to reach the following limits: Number of Columns Google Docs Help says that the columns limit is of ...
0
votes
3answers
3k views

Protect entire column of a Google Docs spreadsheet

I select a column (e.g. Sheet1!A:A) to be protected, then in the right pane I edit the settings (name, permissions), and finally I click Done What happens: The protected range then switches to ...
8
votes
2answers
5k views

Google Spreadsheets: format cells as plain text [duplicate]

I'm gathering some data in a Google Spreadsheet, there's a column for phone numbers and when trying to enter a phone number (e.g., +54 11 4785 7992) the spreadsheet automatically tries to make a ...
5
votes
3answers
3k views

Repeat last action in Google Spreadsheets

I want to know if there is a shortcut in Google Docs Spreadsheets for repeating the last action, like F4 in MS Office. I found that there was no shortcut for this on Google Forums but the post were ...
2
votes
1answer
896 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, ...
1
vote
1answer
388 views

How to search an embedded Google Spreadsheet in Google Sites?

I would like to know how I can make embedded spreadsheets searchable in Google Sites.
1
vote
1answer
704 views

Avoiding duplicates when adding cells in column one by one in Google Spreadsheets

How can I have a kind warning if I am adding a text to the cell which was already added somewhere in previous cells of the same column?