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

learn more… | top users | synonyms (1)

0
votes
0answers
5 views

Lookup/Copy info from different sheets?

I am creating a schedule sheet in google-drive that will have a number of different people inputting their own information. I would like the Director to be able to open a single document that "gets" ...
1
vote
1answer
19 views

How can I collect the sum of different columns while filtering?

I am creating a travel budget spreadsheet and need to be able to sum different filters (By Month, By Salesperson, By State, etc)...is there a way for me to display the sum of a column based on what is ...
2
votes
1answer
13 views

Google Sheets formula every x rows, assign incrementing cell value

I have a Google Sheet, with the first row container headers (so row references will be -1) and rows are "grouped" by every 7 rows. See below. I've manually typed the numbers into the Image # ...
1
vote
1answer
32 views

How do I add a counter value into a cell once a row is added

I work for a small company that monitors all service calls in an old database. I recently moved this database into a Google Spreadsheet and a Google Form. Once a user submits a ticket, I would like ...
2
votes
1answer
24 views

How to automatically refresh date in Google spreadsheet published to the web?

I am using Google Spreadsheets to maintain a register of all students in my school and track their monthly payments. Each student has a separate Google spreadsheet maintained and in the spreadsheet I ...
2
votes
0answers
15 views

Embedding a Google Visualization Chart inside a Google Spreadsheet

Unfortunately, the embedded charts in Google Spreadsheets do not have the customization I want. I would like to use a Google Visualization Chart instead. The documentation discusses how to use a ...
0
votes
0answers
15 views

Script that adds new row to multiple sheets in Google Spreadsheets

I want to add a script in Google Spreadsheets that adds new row on the second line of every sheet within a Google Spreadsheet that contains multiple spreadsheets. This will need to happen every day.
0
votes
2answers
35 views

Getting the second, third or fourth largest elements

I have tried the formula given here: Second highest value which is the following =INDEX(SORT(UNIQUE(A1:A30),1,FALSE),1,0) however it will highlight everything that's not already highlighted. I'm ...
0
votes
0answers
14 views

How to contour data from a Google Spreadsheet?

Google has a lot of cool things such as Spreadsheet Mapper, Fusion Tables and Google sites. I have a Google Spreadsheet with data in the following format: latitude, longitude, humidity How ...
0
votes
0answers
16 views

Strange wrong result in Google Sheet using ImportHTML

Please consider the following formula: =IMPORTHTML("http://www.cvr.dk/Site/Forms/PublicService/DisplayCompany.aspx?cvrnr=30436709";"table") Strangely I get this value While on the web pages I ...
2
votes
1answer
17 views

Google Docs sheets: How to refer values in other column by key? (like SQL join)

I have a sheet/document with item number and it's price. In an invoice, I have: | Number | Qty | Price | ... | Total price | 21 | 3 | ??? | ... | = C2 * B2 I'd like the Price column to be ...
1
vote
1answer
12 views

In Google Spreadsheet, how do I make cells take a random string value from a list of strings?

Suppose I have a list of strings {apple, pear, banana, orange}. How can I have each cell in a column of cells have a random value from that list?
0
votes
1answer
17 views

Format day of the week

In Google Docs, what would a script look like that would identify days of the week (i.e., monday, wednesday, friday) and then change the background color of the corresponding cells?
0
votes
1answer
28 views

Can Google Spreadsheets handle 10 million rows?

I have a data file with 14 columns and 9,523,125 rows. Can a Google Spreadsheet handle at least 9,523,125 rows?
0
votes
0answers
12 views

Don't show current users in embedded Google doc

Is there a way to hide current users from an embedded Google spreadsheet (simple iframe)? A cursory Google search doesn't seem to bring up anything.
0
votes
2answers
23 views

How can I make Google Sheets tell me how many of each date are in a column?

I have a column in my spreadsheet that contains only Date values, like: 2014-05-17 2014-06-19 2014-07-16 2014-07-16 2014-07-21 2014-07-21 2014-07-21 2014-07-21 2014-07-21 2014-06-17 2014-06-24 ...
0
votes
1answer
19 views

How do I accomplish a vlookup if my key range is discontinuous?

So, I've got a chart (an EXP chart for an RPG) with several break points in it. One column is how many EXP is required to get to a level, the other column is what level you get to be given that EXP ...
0
votes
0answers
12 views

How to choose custom colors for Google Spreadsheet charts?

When selecting the color for a line in a chart, I see 80 choices of colors. Is there a way to add new colors or set a color using RGB, HSV or HTML colors?
0
votes
1answer
17 views

how to get count of rows in the spreadsheet?

In google spreadsheets, after typing in a list of items through cells A1 to A7, I went off to another cell and typed the following formula =COUNT(A1:A7) It reports zero, instead of seven. I've ...
0
votes
0answers
15 views

Display Sheet Name in Google Sheet

How can the current sheet's name be displayed as the result of a function in a Google Drive Sheet? I know this seems like a duplicate of Display Sheet Name in Google Spreadsheet but the answer to ...
0
votes
0answers
20 views

Break line in Google spreadsheet automatically

I have a document in Google Spreadsheets and I want when I enter a bigger text for it to fill the cell and after jump on the second cell and so on. Is there a way to do that?
0
votes
1answer
12 views

Trying to query one sheet to inform another

Someone at the google+ apps script forum suggested I ask you guys about this project I'm working on. See the whole (pretty short) thread here: ...
1
vote
0answers
33 views

Retrieve data from another sheet based on key value without empty rows

This seems pretty straight forward, and I've seen some answers that come close, but I'm having trouble nailing down one specific requirement. ...
0
votes
1answer
54 views

Google Docs Spreadsheet and Zapier

My client has a Wordpress site that uses Gravity forms. I'm using Zapier so that each time a new submission is entered into the form, it adds this information to as a new row in a Google Spreadsheet ...
2
votes
1answer
49 views

Sum the product of two columns in Google Spreadsheets

Here's the situation: ITEM COST CUST1 CUST2 CUST3 TQTY foo $0.5 1 0 0.5 1.5 baz $1.0 2 1 0 3 bar $1.5 0.5 0 0.3 0.8 SUBT $2.75 $1.00 ...
0
votes
0answers
11 views

Get data from a specific worksheet in Google Spreadsheets [migrated]

I'm using the code below, but I want to get data from a specific sheet. For example Sheet2, Sheet3 ... <script type="text/javascript"> var currentQuestion=0; var totalCorrect=0; var ...
1
vote
1answer
7 views

How to get formulas to do the calculations

I have a column from A1:A398 in a Google spreadsheet. Each cell either has an "f" or is blank. I want to count how many of each there are. In row 399, 400 and 401 I put the following formulas ...
1
vote
0answers
26 views

Trello API: How to remove a member from an organization using Google Apps Script (GAS)

In a Google Spreadsheet, I have a list of Trello usernames that I want to remove from my Trello organization. How can I use the Trello API to remove all these members from my organization? I found ...
1
vote
1answer
22 views

How to parse a date and time in the format 2012-12-12T00:00:00+00:00?

I have a CSV file with dates in the following format: 2012-06-20T00:00:00+00:00 Is it possible to parse a date or date and time in this format? The goal is to turn it into a date and time that ...
0
votes
0answers
13 views

How do you refresh a filter view in Google Sheets?

Right now it seems like the easiest way to refresh a filter view in google sheets is to remove the filter view and then apply it again. What is the fastest way to refresh a filter view in Google ...
1
vote
2answers
57 views

Gmail message details stored to spreadsheet

I would like to know if there is a way that I could have specific messages in my email to go directly in a Google spreadsheet. For example I need all email messages with subject line of "X" be stored ...
0
votes
1answer
31 views

Can you access a spreadsheet using the Google Drive API that doesn't belong to you, assuming you are authenticated?

I have a spreadsheet that my client wishes to keep private. They also wish to sell the information that can be calculated using it (its really complicated, with lots of up to date information in it). ...
3
votes
2answers
50 views

Scan row for value, get column of that match, apply column in another formula in a different cell

+------+--------------+--------------+--------------+--------------+--------------+ | | A | B | C | D | E | ...
0
votes
2answers
25 views

Add cell from multiple spreadsheets in Google Spreadsheets

I have a Google spreadsheet that contains 30 sheets (each day for the month of September). I want to add cell K36 from each sheet, but I don’t know how. How can I do this?
1
vote
1answer
16 views

Freeze first row of Google spreadsheet when displayed in Google site

When a Google spreadsheet is displayed in a Google site window, the complete table being displayed moves when the displayed window is scrolled. The top row containing headers moves out of view. This ...
1
vote
1answer
50 views

Create a Google Sheets chart with multiple data ranges with separate key columns

I have this data: X1 Y1 X2 Y2 1 20 1 25 2 20 3 42 3 20 6 50 5 25 8 50 10 30 10 50 I want to create ...
2
votes
2answers
53 views

How to interpolate data in a range in Google Sheets

I have an array with data: X Y 3 50 5 60 9 120 11 130 18 90 20 150 The data is entirely non-linear. X is guaranteed to be sorted. Now for any given ...
0
votes
1answer
13 views

How do you calculate the min date between a cell and TODAY() in google spreadsheet, in a single step?

I need to calculate the minimum date between a cell and TODAY, but somehow the MIN function is failing me. Here's the demonstration. If I calculate it on a range, such as =min(A1:A2) it works, but I ...
0
votes
0answers
6 views

How do show the sum of the values of a column of one sheet on another sheet in google spreadsheet? [duplicate]

I need show the sum of values in a column of one sheet on another sheet. How do I do this?
0
votes
1answer
21 views

How do I sort several columns by a list of values?

In Google Sheets, I have several columns: Industry | Company | Country | Date Last Visited And I want to order them by Country, then by Date Last Visited, then by Industry, then by Company so that ...
1
vote
1answer
24 views

Sum of dynamic number of values derived from fomula

In short my question is this. If I use the SUM function (or some other function) that can take one or more arguments, is there some way I can pass in these arguments as an array which varies over some ...
0
votes
0answers
17 views

Embed Google Sheet in website force default

I want to embed a Google Sheet in my website and want it to return to the "clean" state once I leave the page. If anyone has an idea how to implement this, be it a setting in Sheets or making some ...
0
votes
1answer
26 views

Conversion from Excel to Google Spreadsheet - sum across sheets

I'm importing an Excel spreadsheet into Google Drive. Its a huge spreadsheet, and overall Google spreadsheets has converted everything, except the following: There are a few cells with formulas like ...
0
votes
0answers
32 views

Case insensitive character string filter for multiple individual columns (dynamic input for each)

I'm looking for an efficient way to filter a data set by multiple individual, case insensitive character strings for multiple columns in a Google docs spreadsheet. I can already achieve this by ...
0
votes
2answers
32 views

New Google Sheet has different download URL? and errors?

I've been downloading the first sheet old Google Spreadsheets as a TSV file using urls like: https://docs.google.com/feeds/download/spreadsheets/Export?key=ID&exportFormat=tsv&gid=0 After ...
-1
votes
2answers
30 views

Google spreadsheet

I have a spreadsheet with words in columns A and B: TxtA1-TxtA2 TxtB1-TxtB2 TxtC1-TxtC2 How can I merge it into one column looking like this? TxtA1 TxtA2 TxtB1 TxtB2 TxtC1 TxtC2
2
votes
1answer
53 views

Conditional formatting across sheets

I have two sheets, SheetA for values, SheetB for calculations. I want a cell in SheetA to be colored, if a value in SheetB satisfies a condition. Normally, referencing a field from another sheet is ...
1
vote
1answer
36 views

What's wrong with this Google Apps Script code?

Forewarning: I'm a noob at JavaScript, with varying experience and less knowledge. I don't get why this code fails with TypeError: can't call method "getSheetName"/undefined. (line 7, file "Koodi"). ...
0
votes
2answers
23 views

Google Spreadsheets—Adding a title to cell number 0?

It is good convention to name your columns, to put some kind of description in cell 1. However, this really bugs me, because then all my values are indexed starting at 2, so I think I'm dealing with ...
2
votes
0answers
41 views

Is GOOGLETOURNAMENT defunct?

I do not follow the NCAA Division I Basketball Championship but am interested in the accuracy of current advice re Google Spreadsheets. One of the functions is GOOGLETOURNAMENT which, rumour has it, ...