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

learn more… | top users | synonyms (2)

0
votes
1answer
51 views

How to merge 2 tables into one?

I have in my Google Spreadsheet two separate tabs containing each one a table as showed hereafter: Tab 1 Tab 2 ______________________________ ...
0
votes
2answers
172 views

Google Sheets advanced lookup + sum

I'am try to get the total results of multiple sheets where i have in collum A a dropdown list with value 1 to 3 for example. in total i have 12 sheets (once for each month) and i want of all the ...
0
votes
1answer
65 views

How to mix numbers formula in text format to formula format? [closed]

I have formulas that created 8/39 5/39 4/39 Now in C1 I want the sum of them and in D1 percentage of it. I cant execute slash from text. =A1+B1+C1 doesn't work.
0
votes
1answer
325 views

How can I calculate compound interest with different interest rates?

Assume that I have the following different interest rates for different periods. I would like to calculate a compound interest rate based on these rates for lets say 200 periods. How can I do it ...
0
votes
4answers
49 views

How can I append a string to a formula result?

How can I include the result of an equation followed by a piece of information in quotes? For instance if I had the code add numbers from three cells, and wanted to include the result followed by lbs ...
0
votes
1answer
46 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 ...
0
votes
2answers
117 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
1answer
133 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
1answer
19 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
2answers
50 views

Which formula sums all values from a column in a line that contains a specific word?

Let's use this random spreadsheet to illustrate my problem. What I want to do is a sum of all Page Views (F) that contains the Category (B) named /Online Computers. Which formula can I use to do ...
0
votes
1answer
50 views

Link a range of vertically ordered rows, to a horizontal range of columns [duplicate]

Is there a range function in Google Spreadsheets where I can link the values of SheetA!A1:A10 to SheetB!A1:J1? So basically rotating the values from rows to columns.
0
votes
2answers
64 views

Run formula on different sheet

I need help applying this formula to a different sheet: =SUMIF(A2:A6,"3",H2:H6) I'm basically trying to discover expenses for the month of March, and hopefully having a year constraint in there ...
0
votes
1answer
37 views

How do I combine a string with elements from a SPLITed string?

I have two cells that I want to reference: A category cell (I will call this 1A) A cell with a list of items associated with 1A I want to get the list cell separated out as you would with the ...
0
votes
1answer
237 views

In Google Drive spreadsheet, how do I put tabs at the top of the screen?

I want to make a public Google Doc with tabs similar to https://docs.google.com/spreadsheet/pub?key=0AifXEOqTcGcLdFVvWk1GRjVJTHJUaTVLcGViR1RRTFE, but I haven't been able to find instructions or other ...
0
votes
1answer
1k views

Import Range on Google Spreadsheet

I want Cell D1 of this link: https://docs.google.com/spreadsheet/ccc?key=0AupKcedJ0nhPdFFyMVhySWNvNzlYTV9RZ1FmYXdKc0E&usp=sharing#gid=2 To be imported to E9 of this link: ...
0
votes
1answer
566 views

How do I write or read Google-Sheets “comments” on mobile devices?

In a Google-Sheet called Field Schedules for Google web-apps at http://drive.google.com you can right click on a cell to open a context menu with the option to "Insert comment." Let's say for example ...
0
votes
1answer
75 views

What is the correct syntax for the IF function?

I'm trying to make a cell output "Some words" if the number cell in B10 in a page named "Page" is greater than or equal to 3. If not, it should output "Some other words". I tried =IF("'PAGE'!B10≤3", ...
0
votes
1answer
111 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 ...
0
votes
1answer
647 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 ...
0
votes
2answers
1k views

embed google / microsoft excel spreadsheet

I'm searching for few hours for a web app which allows me to create a spreadsheet and embed in to my webpage. I've looked through Microsof Excel Webapp and Google spreadsheets but none of them allow ...
0
votes
1answer
762 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 ...
0
votes
3answers
1k 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
2answers
1k views

Sum until empty line function in Google Spreadsheet

I'm using this data layout a lot: A B C 1 Name1 Count Total 2 A 1 =SUM(B2:B4) 3 B 2 4 C 1 5 6 Name2 Count Total 7 D 1 =SUM(B7:B8) 8 E 2 It is ...
0
votes
1answer
3k 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
1answer
1k views

Change all values of a column at once in Google Docs

How can I change all values of column A (currently empty) to be 5? In Excel, I could do Paste Special > Multiply. Is it possible in Google Docs?
0
votes
2answers
4k views

Parse HTML through Google Spreadsheet using scripting

I'm trying to speed up the process of getting values from an HTML page to a Google Docs Spreadsheet through scripting. I remember Microsoft Excel had the import data function, but I don't own a copy ...
0
votes
2answers
670 views

not getting sub date granularity in google docs trend lines?

Anyone have an idea what I might have broken that prevents me from getting sub date granularity on google doc's spreadsheet's trend line graphs? My data is in variable increments, anywhere from 6 to ...
0
votes
3answers
9 views

Update formula ranges when adding new rows to a spreadsheet

I have a Google Spreadsheet in which I keep a list of expenses. I add a new expense by inserting a new row above the last expense. On the first row of the spreadsheet, I keep a sum of all expenses: ...
0
votes
1answer
17 views

Can you limit the average function in Google Spreadsheets?

I have a table with column A having a 0 or a 1, and column B having a value that I want to average. I know I can use averageif(A:A, "=1", B:B) to get the average of all of the values that have a 1 in ...
0
votes
1answer
19 views

How do I make one cell correspond with another for google spreadsheet?

A B C D 1|Male | 5 |Male avg| 8 | 2|Female| 4 | | | 3|Female| 8 | | | 4|Male | 9 | | | 5|Male | 10 | | ...
0
votes
1answer
52 views

Google Docs Chrome extension - what does it do / why does it exist?

In some Chrome instances, several extensions (apps?) called Google Docs, Google Sheets, etc. are installed (I've seen various subsets of these across different Chrome instances). What are these for / ...
0
votes
1answer
34 views

script editor - google spreadsheet

Need help in adding another function using the below script. I would like to have a timestamp "start" and "end" on two different columns, whenever the other two separate columns are edited. Based on ...
0
votes
1answer
35 views

How do I do simple time calculation in Google Spreadsheets?

I have a really simple question, I have searched online and for the life of me, cannot work out how to do this: Calculate the total hours and minutes from a start time to a finish time? Calculate ...
0
votes
1answer
92 views

Google spreadsheet query reference to several sheets

I have this formula: =ArrayFormula({query(query({A3:D,value(B3:B)}, "select Col1, sum(Col5), count(Col4), sum(Col3) where Col1<>'' group by Col1 format sum(Col5) 'h:mm:ss'"),"select* offset ...
0
votes
1answer
35 views

Eliminate empty cells from a sort

I have a spreadsheet where club members scores are added from competitions during the year. I accumulate the data to a sheet with a name column and a value column I then sort these to another sheet by ...
0
votes
1answer
76 views

Using SUMPRODUCT with ARRAYFORMULA

I have the following random data in sheet one A orange D yellow C yellow B orange B orange C blue A yellow D blue C orange C blue In sheet two I use the following query function: ...
0
votes
1answer
46 views

How do I have the choice made in an in-cell drop down menu affect the cells next to it?

I have a contact sheet with names going down the list and contact info in the cells to the right of each name. On a separate signup sheet, I used data validation to create a drop down menu with the ...
0
votes
1answer
66 views

Moving from one Sheet to another in Google Sheets

I am using a Google sheets to organize an upcoming project. On the first tab I have every task listed, and who the actor should be for that task. I plan on sharing this sheet with my team... Is it ...
0
votes
1answer
45 views

Show only own record to Google Spreadsheet user and hide data from other users

I'm organizing an event, so I set up a table for people to sign up using Google spreadsheet. For concern of personal information privacy, I'd like to make it only be able to add a new record, for ...
0
votes
1answer
73 views

How to turn cell yellow if date in cell is between 180 and 365 days in the past

In Google Spreadsheets how do I use conditional formatting to turn a cell yellow if the date is between 180 and 365 days in the past?
0
votes
1answer
72 views

Wildcard in Google spreadsheet

How do I convert the following formula to do wildcard for "Florida"? =Sumproduct((Sheet1!B:B="Florida"),Sheet1!A:A) Ideally, I like the formula to do this: ...
0
votes
1answer
97 views

Import a CSV file to Google Spreadsheets

I am trying to upload a CSV file and importing it to Google Spreadsheets. The file contains the following: hi,hello\r\nwelcome,to\r\npeaceful,world What I expect in the Google spreadsheet is: ...
0
votes
1answer
167 views

Show all hidden rows and columns when I open a Google Spreadsheet

I want to un-hide all the hidden rows and columns when I open the spreadsheet. How can I do that for all sheets?
0
votes
1answer
281 views

Is there any way to use a formula in a Google Sheets filter view?

I have a sheet with a column of numbers. I'd like to create a filter view that only shows rows with a value greater than 500, but I can't find any way to do that. There are lots of different numbers, ...
0
votes
1answer
146 views

Return value in column A in preceding cells in column B using an Array Formula

I've been looking for a solution to this for days now. How do you fill cells in column B (using an array formula) that are preceding the cell in column A with the value of column A only when cell in ...
0
votes
1answer
29 views

Counting specific words

I want to count how many times in a column certain words from a predefined set appear. In this example those specific words will be days of the week. For example: Mon =3 Tues ...
0
votes
1answer
67 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
1answer
63 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
60 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
1answer
99 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 ...