Part of the Google Docs suite, a web app that allows you to create and edit worksheets
28
votes
6answers
62k views
How do I link a cell in Google Spreadsheets to a cell in another document?
I have a monthly spreadsheet that relies on figures from the previous month. I'd like to import these values dynamically rather than cutting and pasting them. Is this possible? How do I do it?
7
votes
3answers
13k views
How can I make some data on a Google Spreadsheet auto-sorting?
Let's say I want Google Doc to automagically sort some data, for example Coloumn C. How do I do that?
I know that I can manually sort data by right-clicking and selecting "sort data", but this is not ...
0
votes
2answers
4k views
'Lock' part of formula when copying from one cell to another
I have the following formula in a Google Spreadsheet:
=IF(I11="VSS";G11;IF(I11="MCS";0;G11*Totais!C30))
I would like to freeze Totais!C30 when I click on bottom right of cell and drag down.
...
34
votes
3answers
36k views
Google Spreadsheets conditional formatting based on another cell's content
How can I set conditional formatting on a particular cell that depends on another cell's value?
A | B
1 | x
2 |
3 |
1 | x
1 | x
4 |
8 |
// X can be any value and is here merely to
// mark the ...
16
votes
7answers
10k views
In a Google Spreadsheet, how can I force a row to be a certain height?
In a Google Doc spreadsheet I would like to have each row the same height no matter how much text is in each cell.
I have tried "resize row" but no matter how many pixels I put in, the row expands ...
3
votes
1answer
1k views
How do I add a hyperlink to a cell in Google Spreadsheets?
In Excel, I can easily add a hyperlink to a cell by choosing the corresponding toolbar button. How do I do the same thing in a Google Doc spreadsheet?
I don't see any corresponding toolbar button or ...
2
votes
1answer
3k 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
3answers
6k views
Advanced date logic in Google Spreadsheets
1.) What is a way to use conditional formatting to get Google Spreadsheets to highlight cells that are up to 7 days away from current date?
Ex: Today is 4/9/12. I have a cell with a date in the sheet ...
6
votes
3answers
14k views
Google Spreadsheet formatting a cell with wordwrap without switching modes?
How can one format a cell to have wordwrap in Google Spreadsheets?
I've tried Shift+Enter, but that doesn't seem to work.
One thing I know works is to place the Spreadsheet into List Mode and then ...
4
votes
2answers
3k views
Add a link in Google Spreadsheet to a paragraph in Docs
How do I add a link in a Google Spreadsheet to a specific paragraph or header in a Google Doc?
4
votes
3answers
8k views
Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?
I use a Google Form to retrieve feedback from our customers. I then download this info into our offline system.
Is it possible in Google Form to give a unique value to each row it inserts into the ...
4
votes
2answers
964 views
Creating an online form - by Importing the questions from a spreadsheet?
I've got a spreadsheet where each row of the first column is a question, and the next 4 columns are the optional 4 answers to that question.
I want to turn these questions into an online form (like ...
3
votes
1answer
91 views
Auto Sort Sheet on second entry
I loved the script put forward by w0lf mostly it did the trick however I cannot figure out a way to have it sort only when I enter data in the second column of 4 columns it does it when I enter data ...
3
votes
3answers
385 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
522 views
How to select weekdays only in a Google spreadsheet?
I have a table with two columns: column A has dates, column B has data. I want to compute the average of the data in B that corresponds to only week (work) days. How can I write it as a formula?
2
votes
1answer
1k views
Can we do a link between two Google Docs spreadsheets?
I want to make a link between two spreadsheets, like if I click on a code in a cell, it opens the spreadsheet which the code refers/links to.
2
votes
1answer
219 views
What would I use to write a formula only once and have it work on multiple sheets? Google Docs
I want to write a formula once in one sheet and have others call that formula and do calculation in their own sheet. I want to do this because calculations need to be done in 100 other sheets within ...
1
vote
2answers
178 views
Is is possible to have part of a google doc hidden publicly but able to be edited and “pushed” to LIVE?
So I have a public schedule for my business, but need to edit (which sometimes takes a few days) and then make "public"...
Can I do that?
I know I can "hide" but when I reopen, it's live and everyone ...
3
votes
1answer
1k views
Figuring out who is the owner of a Google Spreadsheets form
I have noticed that Google spreadsheet form's have URLs in the form of http://spreadsheets.google.com/viewform?formkey=.... I don't see anything that relates to the Google account in the URL. There ...
4
votes
2answers
5k views
How to sum values in a range of dates in Google Docs Spreadsheets?
I have a Google Docs spreadsheet in the format below — here's an example.
Column A → Dates
Column B → Numbers
I'd like to sum values in column B in a range of dates in column A.
Example:
...
3
votes
2answers
192 views
How can I make some data Autosort in a spreadsheet on edit?
I am working with a simple spreadsheet that has name/lastnames in it. I need for the spreadsheet to automatically sort the entry alphabetically by the last name (column B).
I have used the following ...
3
votes
2answers
2k views
Google spreadsheet—calculating shaded cells
I am using Google spreadsheets to create a matrix (time/activity) as a daily schedule for staff to sign into. Is there a formula to calculate the number of cells in a column that are shaded (or not ...
3
votes
3answers
4k views
How to calculate weighted averages in Google Spreadsheets?
I have a Google Docs Spreadsheet where products are listed as rows and attributes as columns. Each product's attribute is rated on a scale of 1-10. My last column is an average of these values (i.e. ...
2
votes
1answer
1k views
How do I mail merge from Google Spreadsheet to a Google Document?
With Microsoft Excel and Microsoft Word, it is easy to merge rows from a spreadsheet into pages in a Word file. This was traditionally used to make paper mailings. How can I do the same with Google ...
2
votes
0answers
168 views
Cumulative Sum without Script
For this question, I've created a Google Apps Script function, that calculates the cumulative sum of a range. Martin Hawksey on Google+ made a comment about a more efficient way of calculating the ...
2
votes
1answer
863 views
Google Docs - Auto updating column showing last modify date
Trying to figure out a way to have column two auto update to show a timestamp of the last update. I realize the doc shows a timestamp of the last modification, but we have a lot of clients accessing ...
2
votes
1answer
1k 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
287 views
How to apply a function to all the rows preceeding the current one in an arrayformula?
So I have the following situation:
In the first column I have certain values, in the second column, given a certain row, I want it to contain the result of a function applied to all the preceeding ...
1
vote
1answer
367 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 ...
5
votes
2answers
988 views
Google Spreadsheet Comments
I have a Google Spreadsheet with several boxes with the little orange triangle indicating a comment associated with that cell. Unfortunately, I haven't made any comments, so cannot delete these ...
5
votes
2answers
3k views
How to Plot Time Series Graph in Google Spreadsheet?
I know it is possible to plot graph or chart in Google Spreadsheet.
But the problem with current plotting way is that you can only specify the Y, but not the X. And as such, there is no way to plot a ...
3
votes
1answer
275 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 ...
3
votes
1answer
468 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 ...
3
votes
1answer
3k 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 ...
2
votes
1answer
257 views
Google SpreadSheet conditional formatting based on number of characters
In Google Spreadsheet, is there a way to conditionally format a cell if it has more than 30 characters?
2
votes
1answer
491 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?
1
vote
2answers
148 views
Google Spreadsheet: Finding the SUM of an array where the size of the array is dependent on a cell's contents
Here is a simplified example of what I want: Example File of what I want
The yellow highlighted areas are areas important to the formula.
Essentially Column C finds the row on Sheet 2 with the same ...
1
vote
0answers
165 views
In Google Spreadsheets the xPath method with Google Maps don't work anymore?
I've used this query to calculate distance between two locations, now it won't work anymore, and returns the error xPath query didn't get any result (translated from Italian, I don't know if is the ...
1
vote
1answer
502 views
Is there a Google Docs (or -spreadsheets) API to scroll the view?
If I want to scroll to a particular paragraph in Google Docs, or a particular cell in Google spreadsheets, is there a way to do that via Google Apps script?
1
vote
1answer
941 views
Validation based on multiple sheets in Google Docs
I have 2 sheets that each contain a column of data that I would like combined and used as a validation list for a column in another sheet. What would the formula look like for this?
1
vote
1answer
4k views
Take SUM of colored cells in a column in Google Spreadsheets?
I have a column of numbers, where I've changed the background color of some of the cells to blue. All of the other cells in the column have the regular white background. Is it possible to create a ...
0
votes
0answers
26 views
Google Docs spreadsheets: how to specify entire sheet as range?
The best workaround I have found so far is:
worksheet_name!$A$1:$YY
but ideally I would like to be able to simply write, e.g.:
worksheet_name!
So, does anyone know: is there a syntax for ...
0
votes
1answer
65 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
votes
1answer
85 views
Set the headers in a Google Drive spreadsheet to move on screen as I scroll down
How do I set the headers in a Google Drive spreadsheet to move on screen as I scroll down the spreadsheet?
