One of productivity apps in Google Drive, that allows you to create and edit worksheets
0
votes
0answers
8 views
Download Google Spreadsheet comes out on 1 line?
I have created a very simple spreadsheet of 3 columns with about 5 rows of data (as a test). When I download it as a CSV it comes out all in one line; I would expect each row to be a separate line. ...
1
vote
2answers
32 views
Google Spreadsheets sum only shown rows
Is it possible to sum a range of cells while ignoring rows which are not hidden?
Thanks
2
votes
2answers
40 views
Allow trailing whitespaces in Google Spreadsheets
I was working on a Google Spreadsheet and I found that it does not allow more than one white space anywhere.
Is there any option to stop auto trimming on text? I searched it but didn’t found any ...
1
vote
1answer
25 views
Google Spreedsheets Maths Date
In column A, I have today's date 18/06/2013 and I want to add 25 days to it, but because I have a list of 100 dates (all different) I need to do the same thing that =DATE(2013,06,18)+25 would do but ...
0
votes
0answers
20 views
Fill a Google Drive Document from Google Drive Spreadsheet
I would like to have a template document and fill some fields with data from a spreadsheet, for example changing the id or name of an entity in the template and automatically the document updates all ...
0
votes
1answer
77 views
Creating a class roster in Google Spreadsheets from a split result
A lecturer from the European School of Physiotherapy in Amsterdam stumbled on a particular script I prepared, hoping it would resolve a problem he had.
After having had a little chit chat, it turned ...
-2
votes
1answer
34 views
How do I link Google Spreadsheets together - IMPORTRANGE doesn't seem to work
This doesn't seem to be working for me at all. Also is there a way I can link two worksheets in the same spreadsheet together?
And also is it possible to have to forms in the same spreadsheet but on ...
0
votes
1answer
51 views
Why would this Google Spreadsheet onEdit script be so slow (2 secs to change cells, 3 secs to update)
I've put together a script for a spreadsheet based on what I have seen here and other sources that should provide a simple username and timestamp function. I have another spreadsheet that uses a very ...
0
votes
0answers
36 views
Google Apps Script UrlFetchApp and password protected pages
I'd like to be able to use Google Spreadsheets to login to my registart and automatically list into rows the current name server and email settings of all my sites, rather than use the heinously ...
-1
votes
0answers
16 views
Monthly reports
I am trying to write an equation that updates and calculates a new cell on the first of every month. I have 12 tabs and every tab has a monthly goal. I would like the summary tab to be a current total ...
0
votes
1answer
37 views
Google Spreadsheet Timestamp for columns B & D?
Found this script on one of the questions answered in the forum what I don't know enough to make it work. I would like it to time-stamp date and time in column B when they check in and then a separate ...
1
vote
1answer
28 views
INDEX-MATCH to get a MATCH and use that MATCH in a second INDEX-MATCH
I am trying moving from an access database to google spreadsheets.
In my workbook, I have 3 google sheets:
merged_data (merge all data)
studentsANDemployers (studentID, student_name, employerID)
...
0
votes
0answers
30 views
Google spreadsheet un-sort rows
I created a Google spreadsheet and was able to sort the data for three of the columns. But now I can't un-sort it. I shut it down yesterday while it was still sorted and it will not let me "undo". My ...
1
vote
1answer
28 views
Use specific currency symbol in Google Spreadsheets
'₴' is a currency sign used for the Ukrainian Hryvnia. It's in Unicode since 2004.
I want to use it in spreadsheets as a sign for money values, but Google Spreadsheets doesn't understand it as a ...
0
votes
0answers
47 views
Google Docs - 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 ...
0
votes
1answer
34 views
Google SpreadSheets - Change value of a cell based on a drop menu of values on a different sheet
I want cells in a column, to have drop down menus. Then, the rest of the row needs to match the corresponding column set.
Here's an example that explains what I want:
Sheet 1:
A1, a drop down menu ...
1
vote
1answer
42 views
How Do I Combine Columns In Google Spreadsheets?
I need to combine multiple columns into a single column, so:
one four seven
two five eight
three six nine
Becomes:
one
two
three
four
five
six
seven
eight
nine
0
votes
1answer
41 views
Google spreadsheet cell outcome dependent on another cell’s range
Example: column A1 is $35.00. I want column B1 to be a percentage markup value dependent on the value in A1 (i.e.: 75%). So if A1 is between $1 and $10, B1 = 75%; if between $11 and $20, B1 = 60% and ...
1
vote
1answer
34 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 ...
0
votes
0answers
21 views
Google Spreadsheet Paste
I need to copy and paste content from one sheet to another sheet within the same file, keeping formulas where there are formulas, and keeping data where there is just data.
I tested every past ...
0
votes
2answers
41 views
Google Spreadsheet - total of column if adjacent cell is true and minus another column
I have data like in the following table:
+---+-----+-----+
| A | B | C |
+---+-----+-----+
| 0 | 5 | 30 |
| 1 | 0 | 30 |
| 0 | 15 | 40 |
| 1 | 0 | 40 |
| 1 | 10 | 50 |
...
1
vote
1answer
35 views
How to zip two columns together in a Google Spreadsheet [duplicate]
For example columns are setup as:
A | B
-----
1 | a
2 | b
3 | c
4 | d
5 | e
I want to be able to make column C be like this:
C
---
1
2
3
4
5
a
b
c
d
e
via formula. The two columns ...
-1
votes
0answers
10 views
Why is active field Google spreadsheet off?
the blue line active field is way off in Google Spreadsheet. What is going on and how do I correct it to center on the correct line?
1
vote
2answers
47 views
Return a blank when cell reference is blank—Google Spreadsheet
I am using the following formula in a Google spreadsheet to calculate the number of days between two dates (dates are in columns G and AL). The problem is that some of the cells in col AL are blank, ...
0
votes
0answers
98 views
How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?
I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
0
votes
1answer
45 views
A high score list: filtering out non-personal bests
I have data in two columns, sorted by the second column. As follows:
A, 1
D, 2
B, 4
A, 6
B, 7
...
I need to filter it so that the first column is unique. I.e. the value in the first column only ...
1
vote
1answer
40 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 ...
0
votes
1answer
47 views
Get value of cell on the left of current one
Which is the correct formula to get the value of cell on the left of current one. I've tried =OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1) but it populates the error of circular dependency.
0
votes
1answer
57 views
Excel to Google Spreadsheet problem
I emailed an Excel spreadsheet as an attachment to my Gmail account.
I then chose open as a Google Spreadsheet.
When I opened the Google Spreadsheet, it was missing some formulas and had changed some ...
1
vote
1answer
17 views
Handling variables with data from another sheet on google drive calc
I have a Google Drive Calc File,
Google says in their web help how to reference data from another sheet, but what happens if what I need is to make the reference depending on my fields on the new ...
0
votes
0answers
23 views
Shortcut to insert new row in Google Spreadsheets?
Is there a way to do this without using the menu?
I have seen references to ctrl + space and ctrl + +, but this no longer works (zooms in and out in Google Chrome)
0
votes
1answer
56 views
In Google Drive, how to search something in a Spreadsheet while using Android Tablet?
I have a 1000 rows Google Spreadsheet in my Google Drive and using the Google Drive app on my Nexus tablet. I can't perform a search or use Ctrl+F option.
Any ideas or alternative ways to achieve ...
-1
votes
0answers
22 views
Scrolling a view in Google Spreadsheets
in this question
Is there a Google Docs (or -spreadsheets) API to scroll the view?
The answer was mentioned as this piece of code:
Var file = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ...
2
votes
1answer
29 views
In a Google spreadsheet, how do I list unique items, modified by a regexp?
I have a Google spreadsheet with items and prices. Column D has the prices, column C has item names, some of which contain multiple words. When an item has multiple words, only the first one is ...
1
vote
0answers
54 views
Set a Category Filter in a Google Spreadsheet Line Graph
I've got a google spreadsheet that tracks status updates to a series of projects over time. The table rows each list a particular month (01/2012) and the columns list the status change ("Ready for ...
1
vote
0answers
21 views
Google Spreadsheets Messes Up Comments When Sorted
I added comments to a bunch of cells. When I then sorted the cells, the comments did not follow their original cell and now was connected to the new cell. This is a massive problem and now my ...
1
vote
2answers
49 views
How to count the occurrences of 'STRING' in a row, but only if that row begins with 'IFTEXT'
I have a sheet with employee time logs, as follows:
Name Day1 Day2 Subtotal of 'OFF' days this period
Jess PRESENT OFF 1
Bob PRESENT PRESENT 0
Name Day3 ...
0
votes
0answers
24 views
Link to a cell in a Google Spreadsheet via URL?
One can link to a google docs document via key and via key and worksheet id:
https://docs.google.com/spreadsheet/ccc?key=SOME_KEY
...
0
votes
0answers
37 views
Google Spreadsheet Form Responses in to an already made sheet
I have a template form and matching spreadsheet that need to be copied multiple times. When I make copies of the two, the copies are not linked for the form responses to go to the newly copied ...
1
vote
1answer
43 views
Using INDIRECT() in sheet reference range
I have a separate sheet with some data where a user's input will reference the row number of a sheet. I'm trying to reference that sheet by inserting the column letter and taking a number input from a ...
0
votes
0answers
21 views
How to set hot keys to a customized menu item in a Google Spreadsheet?
I am working with Google Spreadsheet APIs, and found that customized menu item is highly useful. I created some but am now wondering whether I can specify a hot key for each?
0
votes
0answers
27 views
How do I populate a cell in one spreadsheet to a cell in another spreadsheet in the same workbook in google docs?
In Google Spreadsheet, I have created a master spreadsheet that I complete with the amounts of the items needed. I would like those numbers to auto populate in each individual spreadsheet in the ...
0
votes
0answers
48 views
Download list of contact information and check if Google Account
I'm looking for a way I could:
retrieve a list of all my contacts and their email's and
In order to retrieve a list of all of my contacts into a Google spreadsheet, I exported them as a Google CSV ...
0
votes
1answer
49 views
Google spreadsheet multiple auto-sorting
In a Google Spreadsheet I have different group of cells to auto-sort ascending i.e.
table range a3:c16 columntosortby = 2
table range d18:f31
columntosortby = 5
table range g33:i46 columntosortby = ...
0
votes
0answers
32 views
how to put in a column how time person worked date by date per month
in this file i have in "foglio 2" column B every date worked for every person... i would like to take for every month the date the person worked. for example person "marco" and in "jauary" column ...
0
votes
1answer
38 views
Google Spreadsheets Filtering data in another page and changing data in the original
I have a lot of data that I need to filter. I did it in another page and that's good... but now I need to put some values in that page... and transfer that data to the original.
This is the formula ...
0
votes
0answers
24 views
Google Docs Changing the A B C-“Tabs” in Excel
The picture above is explaining. I'm looking for a way to change these " A B C " to a more describe way of what the content below is containing, etc A would contain what date, B is what length I run ...
0
votes
1answer
122 views
Google Spreadsheet: how to get value of cell by row key and column key
Suppose I have a workbook with two worksheets, data and view. data is structured in "database" style, i.e. with a single header row and unique keys in the first column, e.g.:
Country GDP ...
0
votes
1answer
47 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 ...
1
vote
1answer
39 views
How to have Google Spreadsheets automatically complete cells with previously used data
I'm using a Google Spreadsheet to fill in my mileage. Since I'm using many addresses more than once, I want to make the process of filling in easier by (like Excel or Open Office) having the ...
