Part of the Google Docs suite, a web app that allows you to create and edit worksheets
0
votes
0answers
9 views
How do I maintain text formatting when the word or sentence exceeds the cell length? [duplicate]
Possible Duplicate:
Google Spreadsheet formatting a cell with wordwrap without switching modes?
Maybe the answer to this question as been answered and I just didn't see it, but I have some ...
2
votes
2answers
353 views
Split content of one row into multiple rows?
I have a table where each row contains data like this:
Team name | First member | Second member | Third member | Team description
Would it be possible to transform/break this data so that each row ...
1
vote
1answer
522 views
How can I import Google Calendar events into a Google Spreadsheet?
I just need rows with name, date/time, and location.
Ideally it should be done automatically every n hours or at every event added.
I found a script solution on Stack Overflow, but is there any ...
0
votes
0answers
14 views
Google Spreadsheet: reference seperate spreadsheet [duplicate]
Possible Duplicate:
How do I link a cell in Google Spreadsheets to a cell in another document?
Is it possible with a Google Spreadsheet to reference a cell to another spreadsheet using a ...
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 ...
1
vote
2answers
101 views
Is there a filter delimiter in Google Spreadsheets?
I'm trying to build a list of servers in a Google Spreadsheet. Each server has multiple services, and I would like to be able to select a single service and see all the servers providing that service.
...
1
vote
1answer
86 views
Add headers to Google Spreadsheet chart
I have a chart in a spreadsheet. If I click on it and select 'advanced edit' > Start,
it offers to 'Use row 12 as headers'. How can I use a different row for the header names?
My data has rows for the ...
3
votes
1answer
376 views
More Efficient Filtering Script
I'm exactly one day into writing Google scripts. I've managed to write one that will filter data in a spreadsheet with 24 columns and, for now, about 900 rows.
The problem is, it's slow. Any ...
3
votes
1answer
500 views
filter or sort Google Spreadsheet based on condition
I have an 8 column spreadsheet.
I want to sort/filter based upon the value of the 4th column.
In a separate sheet within the same spreadsheet, I want to print a list of each row matching a speific ...
0
votes
0answers
134 views
Converting and Excel to Google Spreadsheet
I am trying to convert an Excel Spreadsheet to a Google Spreadsheet, but after it is converted, the document is smaller in size. How can it get it to be the exact size that I uploaded?
0
votes
1answer
103 views
SPLIT function in Google Spreadsheets with OR statement
I want to use the split function, but with different delimiters. I thought of something like this: =SPLIT(A:A;OR("-","&")) but it doesn't work.
Is it possible to have Boolean statements within a ...
1
vote
1answer
130 views
Google Docs time stamp?
The following code was almost exactly what I was looking for to timestamp the adjacent cell after being edited. However, I need to incorporate the currnet date as well as time. The code below gives a ...
0
votes
1answer
146 views
How to re-use Google Apps Scripts in new Google Spreadsheet
I'm having an issue. Whenever I create a new spreadsheet, I'm not able to add a script I've already created. The list for recent projects or scripts is always blank. Anyone have a resolution or do I ...
0
votes
1answer
597 views
How do I use the INDEX or OFFSET functions in Google Spreadsheets?
I have my spreadsheet set up as follows: first 10 columns full of descriptive data followed by 24 columns of month data (2 columns per month).
The last 24 columns are static and the values are ...
2
votes
1answer
156 views
Google Scripts : How to distinguish Empty cells from Zero
I want to count a number of specific responses from a form where the response can be left empty, zero or any other number 'd'.
The following code:
var data = sheet.getRange("B2:L").getValues();
...
1
vote
0answers
110 views
Google Docs capabilities
We've created a commission calculator to help our resellers work out what commissions they will receive on a deal.
We built it in Excel 2010 but want to move it to a web based platform that will ...
0
votes
2answers
137 views
How does one insert a new line in a cell in a Google doc spreadsheet?
I saw a question with this earlier but nobody seems to have it answered in a way that helps me.
I need to paste text into a Google Docs spreadsheet cell but it needs to have two new lines in it. ...
1
vote
0answers
130 views
Google spreadsheets and sorting protected range
I've been trying to make the spreadsheet automatically sort some data, and after some searching I found this link..
it's working just perfect with my permissions as the owner but when any of my ...
0
votes
1answer
88 views
Automatically add values before and after Google spreadsheet
I have a library of flags online and would like to have a client-foolproof solution for adding flags.
Right now my function looks like this:
=image("http://www.website.com/flags/us.png", 3)
But I ...
-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?
0
votes
1answer
204 views
Query multiple Google spreadsheets
I have the following sheets:
ListA
ListB
ListC
Note: at each sheet I have a column which contains YES or NO.
How do I query all my lists (spreadsheets) where myBooleanColumn equals to YES/NO?
1
vote
0answers
173 views
How to make a query with Google Spreadsheet, that returns rows if deadline is two weeks from today, one month from today, 2 months from today, etc
I have a spreadsheet that contains several columns with project information. I basically want to modify the following formula:
=QUERY( 'Compilation'!A2:L; " select A, B, F, I, L order by A" ; 0 )
...
2
votes
2answers
211 views
Google Spreadsheets: Counting minutes/seconds
I am using format-value-time to have cells where I input minutes/seconds, like 13:45 for 13 minutes & 45 seconds. If I have several of these cells, how can I add them all up?
Example:
Cell1:
...
2
votes
1answer
173 views
Auto date insert when opposite cell is populated
I am creating a spreadsheet which will contain records of my daily expenditure. Something like the following:
A | B
----------
0 | 50.04
0 | 20.00
0 | 19.99
0 | 2.40
What I am trying to ...
3
votes
2answers
189 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 ...
1
vote
1answer
224 views
Get rid of row in result of Google Spreadsheets query
I use the following formula in my Google Spreadsheet:
QUERY(Inkomster!A2:G;"SELECT SUM(C) WHERE G="&B3&" AND F='"&A3&"'")
This returns the following (On two different rows that ...
0
votes
0answers
20 views
Function Question
I am entering data into the spreadsheet and I could use some type of function that would link separate columns if there is a #1 entered. Such as if a 1 is entered into column F + column K + N, column ...
0
votes
0answers
123 views
Get Published Google Doc in JSON
I have a Published Google DOc at
https://docs.google.com/spreadsheet/pub?key=0AtjON-ccqVTgdDhKeGx0UlZpUWUyLTFZV2szQlJyNnc&output=html
I want to retrieve in JSON. I've been trying this but its ...
3
votes
1answer
152 views
How can we view the whole spreadsheet instead of just the form in Google forms?
I have been given a link to a Google docs form where I was supposed to enter some data. The URI looks something like this:
https://docs.google.com/spreadsheet/formResponse?formkey=foo
Is there ...
1
vote
1answer
678 views
Google Docs Spreadsheet - Parse Error
Not sure why this formula does not work. I just want the value to be zero if 60-D15 is negative
=MAX(60-D15,0)
also tried
=MAX(D15,0)
=MAXA(D15,0)
Any clues?
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 ...
0
votes
1answer
44 views
Transpose an Address List as Row in Google Spreadsheet
I'm having a good old list with addresses:
Because I want to re-arrange the list (and make it more 2013), I need to transpose the list like this:
I've tried to use the TRANSPOSE formula, but that ...
2
votes
1answer
156 views
Styling Text Within a Cell in Google Spreadsheet
In Excel it is possible to style text within a cell, by pressing Crtl1.
You can create for example the following sequence: 1,2,3,4.
This that possible in Google Spreadsheet?
1
vote
1answer
89 views
Filter function
I am using filter formula below. The formula works fine the first time, but once it filters the result properly, it corrupts the same formula in next row below with --.
...
3
votes
1answer
383 views
Count Occurrences of Words
I'm having the following set of data:
A simple COUNTA would yield n=4. Using the above-mentioned formula will give also n=4.
The answer needs to be however n=6: Jacob Jan (1x), Jacob (2x), Jan (3x)
...
1
vote
1answer
121 views
Selecting a sequence of sheets in Google Docs / Spreadsheets
I have a Google spreadsheet where each sheet is a student group, say, Group1, Group2, Group3 etc. Each sheet is organized identically.
I would like to summarize some information from all sheets into ...
-1
votes
1answer
49 views
In Google Sheets, how can I fit the data to the cell?
In some cells on my sheet the data fits the cell. On some rows there is a lot of extra space after the data in each cell. I have tried deleting after at the end of the data, but it does not help. ...
0
votes
3answers
180 views
In Google Spreadsheets, how can I convert a number according to a range?
I'm working with Google Apps (spreadsheet) and I need to convert results (ranging from 0 to 36) to a maximum of 7 according to the following table.
if score is (0-5) result should be 1
if score ...
2
votes
2answers
313 views
Google spreadsheets editing of a VLOOKUP formula that references a pivot table
After inserting a vlookup formula in a Google spreadsheet, where the array parameter references acolumns of a pivot table, how do I edit the formula again?
When I enter the formula, it just displays ...
0
votes
1answer
415 views
How do you add a custom font size in Google Spreadsheets?
How do I add a custom font size for a Google Spreadsheet I have? There are some defaults like 14pt, 18pt, 24pt and 36pt, but I would like to have a font size like 30pt, is it possible?
1
vote
1answer
88 views
Combining Stuff in Google Spreadsheet
I want to accomplish the following:
string = TEST; cell reference = B2, value = ING; RESULT = TESTING
Which of the following options are the best to use:
CONCAT: =CONCAT("TEST",B2)
& ...
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 ...
1
vote
0answers
37 views
Referencing a Range Name from a different spreadsheet
I would like to create a spreadsheet that contains name, phone number, address, email address of many individuals and I will define the data as a range name "Index". Then I would like to create a ...
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
57 views
Formula to return time difference but not display 0 in google spreadhseet
I have a google spreadsheet with start (C) and end (D) timestamps. I am calculating the time difference using =(D1-C1). I have copied the formula to empty columns which returns a 0 time difference. Is ...
5
votes
2answers
986 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 ...
0
votes
2answers
153 views
Selecting Values from separate sheets and aggregating the results with google spreadsheet
I would like to use the query function to select values from two separate sheets add them together and do a less then comparison to another value. I have used named ranges for the data that I am ...
3
votes
1answer
152 views
Import CSV, show formatted hyperlinks, =Hyperlink(..,..)
Based on a csv import, I would like to show formatted hyperlinks. There is a formula =HYPERLINK( "www.google.com" ; "Search Google" ) that does this, but is there any way to include this in a csv ...
4
votes
1answer
107 views
Save data from Google Spreadsheet history
I used a Google form and inadvertently deleted a few rows.
I need to use the rows again. I see them with history but I can't save them and I can't print them.
How can I restore the data?
4
votes
1answer
91 views
Non-deterministic parameters to custom function
I have a problem with Google Spreadsheets: I create a custom function using the Script Editor and it only runs OK if the parameters I pass are known(constant) values.
If the parameters are ...
