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

learn more… | top users | synonyms (1)

1
vote
0answers
135 views

How to graph one column against another from multiple sheets in Google Spreadsheets?

I have a spreadsheet here: graph with one column against another from multiple sheets I want to graph the ascent columns against the distance for each of the three tabs on the graph. How can I make ...
1
vote
0answers
208 views

how to input a date into a Google spreadsheet cell and have the item show up in Google calendar [closed]

I'm building a To-Do list in a Google spreadsheet. I'd like to add a date, such as a due date, to a Google spreadsheet cell and have the due date auto-magically show up in my Google calendar. ...
1
vote
1answer
3k views

Copying email addresses from Excel to Gmail into the BCC line

I used to be able to copy a column of email addresses (with a comma at the end of each) from Excel into the BCC line of a Gmail message. Now when I try to copy the column of emails, only the first ...
1
vote
0answers
373 views

Can I precisely position charts in a Google Docs spreadsheet?

I am using Google Docs to create a "Monthly Report" spreadsheet for a product, and am attempting to make an attractive, compelling experience for the consumers of the report. In this spreadsheet I ...
1
vote
0answers
139 views

Is there a way to filter columns in Google Docs? [duplicate]

Possible Duplicate: Is there a way to filter columns in Google Docs? Is there a way to filter columns in Google Docs? Column (A) contains new data Column (B) contains filter data, i.e. ...
1
vote
0answers
693 views

Hovering image in Google Spreadsheets

I want to write a script which detects the mouse hovering over a cell (or if not possible, triggered by a menu as described in ...
1
vote
0answers
313 views

Google Spreadsheets Data Management

I am looking for a way to manage the input of some data in Google Spreadsheets. Before I roll up my sleeves and write a new UI using the Google API I thought I would see if there was anything out ...
1
vote
0answers
590 views

How to extract info from the subject line and add to Google Spreadsheet?

I'd like to be able to extract tasks from the subject line of an email in Gmail (using some sort of custom syntax) and then insert the task as a row in a shared Google Spreadsheet. Currently the ...
1
vote
2answers
60 views

Date autofill increments year instead of day

Earlier, when I had dates in a column like: Monday, 21 April, 2014 Tuesday, 22 April, 2014 and I extended the last cell to lower cells I could expect them to be filled with following days: ...
1
vote
2answers
69 views

Spreadsheet: function to watch row for changes

Is there a spreadsheet function (Google, Excel, Numbers, or otherwise) that can watch a row and update a cell with the current date when any cell in that row changes? If not for the entire row then ...
1
vote
1answer
307 views

Google form to spreadsheet, create new column

I created a Google form and a spreadsheet associated that form. On the spreadsheet there are two columns by default. A is Timestamp and B is Untitled question. Now I want to create another column in C ...
1
vote
1answer
140 views

Copy Certain Rows form One Sheet to Another

I am collecting the results of a survey through a Google Form. I'd like to create a new sheet with all of the rows but a subset of the columns. In the new sheet I'll make some calculations based upon ...
1
vote
1answer
478 views

Copy one Google Spreadsheet to another

I am developing a Google spreadsheet that I want to make publicly accessible to a community. I've released the first version of it, and now everybody in the community has that first version's link ...
0
votes
4answers
287 views

How to convert datetime interval to hours?

I have this spreadsheet: A B C D E 1 08/13/2013 02:10 4 2 08/13/2013 02:19 10 00:09:00 160 In D2, I have this formula : ...
0
votes
2answers
873 views

Is there a limit on functions in Google Spreadsheets?

As to answer a question on SuperUser, I was making a sample spreadsheet on google docs. Now I made it first in Excel 2010 on my computer to copy/paste it later on. When I tried to copy a formula that ...
0
votes
2answers
126 views

Calculating time worked per day

How do I add time like 8:20am-12:00pm and then after lunch break 12:30pm-5:02pm to end of day to get hours worked per day? I was using =(B2-A2*24)+(D2-A2*24) but that doesn't work
0
votes
2answers
1k views

how do I get named ranges in Google Spreadsheets to be more reliable/current?

I'd like to pull values from a named range into a calculation. I have this function: function getNamedRange(n){ SpreadsheetApp.getActiveSpreadsheet().getRangeByName(n); } Seems pretty simple. I ...
0
votes
1answer
8k views

How to link two spreadsheet of Google Docs [duplicate]

Possible Duplicate: Can we do a link between two Google Docs spreadsheets? I'm trying to link two Google spreadsheets. I don't want to merge I would like to have a spreadsheet with the ...
0
votes
2answers
678 views

Store form data to Google Docs

I have a webpage where i am having a textbox preferbaly for storing email address. I need to create an email intake database where i need a simple database built to store emails of users “signing ...
0
votes
2answers
3k views

Format a date fetched from another cell for display using concatenate

Given say 2 different dates in A1 and B1, what I want to do is just show the range of dates as a label in A2 by using =concatenate(A1, " - ", A2) However, A1 is in the default format (MM/DD/YYYY) and ...
0
votes
2answers
39 views

How to sum values by month

I'm trying to have my spreadsheet to sum up values by month. Note that the dates are not organised chronologically. I've tried the solutions showing here but they are not working for me. I'm not ...
0
votes
2answers
89 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
15 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
1answer
32 views

How do I move a Google Spreadsheet document from one Google account to another?

I created a moderately complex Google Spreadsheet document in my personal account, which become popular amongst my colleagues and is now officially adopted by our team. Therefore, it would make sense ...
0
votes
3answers
62 views

How to calculate average screen reso. based on number of visitors using a spreadsheet?

I want to find out what the average screen resolution is for visitors to my website – or rather, what is the average width and the average height in pixels. To qualify what I mean by "average" – and ...
0
votes
2answers
398 views

Spreadsheet to calculate weekly increase

I'm trying to create a spreadsheet with my weekly cardio and weight training average times and a total of time spent during an average visit. I would like the final column to display the in/decrease ...
0
votes
2answers
795 views

How to use LEFT function in COUNTIF

I have a column that sometimes has B and sometimes B - somecomment. I want to count all instances of B. I expected it to be something like =COUNTIF(B14:B943, LEFT(B14:B943,1) = "B") But no dice. ...
0
votes
1answer
675 views

How do I make a cell highlighted if the date in the cell is today in Google Spreadsheets? [duplicate]

Possible Duplicate: Advanced date logic in Google Spreadsheets Here's the problem. I have a spreadsheet with many consecutive days. So Cell1 = 7/30/2012, Cell2 = 7/31/2012 etc. I want Cell1 ...
0
votes
1answer
1k views

Embedding an excel like spreadsheet with formula calculations?

I wish to create an Excel-like spreadsheet which gets a few simple inputs (let's say 3 cells with the input of a number), where then a fourth cell will calculate the sum of the square of the three ...
0
votes
2answers
3k views

Laying out dates in Google Spreadsheet charts

I have a Google spreadsheet with measurements made at different dates. How can I make a chart with the dates spread along the x axis properly? The data looks like this 2010-09-01 80 2010-09-02 79 ...
0
votes
1answer
46 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
4answers
41 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
40 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
46 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
50 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
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
2answers
35 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
32 views

Link a range of vertically ordered rows, to a horizontal range of columns

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
56 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
36 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
142 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
861 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
151 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
70 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
96 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
487 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
953 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
701 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
2answers
2k 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. ...
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 ...