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

learn more… | top users | synonyms (2)

1
vote
0answers
1k views

Table of Contents in Google Spreadsheets

I'm curious to know if there's a way to create a table of contents within a Google Drive Spreadsheet. I would like to be able to set the active cell in the spreadsheet based on what cell (or contents ...
1
vote
0answers
115 views

How to insert empty row in Google Spreadsheets when two rows are not duplicate?

I have a number of rows in a Google spreadsheet. I want to insert an empty row only when two sequential rows are not duplicate. How can I do this?
1
vote
0answers
166 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
511 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
2answers
141 views

How to edit a particular sheet using Google Forms

I created a form that has list of items to be selected. I also created a spreadsheet that has a couple of sheets that correspond to the elements in the form. I wanted users to select a category and ...
1
vote
2answers
154 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: ...
0
votes
4answers
449 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
1answer
10k 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
227 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
1answer
2k 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
2answers
792 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
2k views

Sum of the values of the 10 cells above me?

I'd like a formula for Google Docs spreadsheets that will return the sum of the values of the 10 cells above the current cell. That is, if I'm on C31, I want the equivalent of =SUM(C20:C30). However, ...
0
votes
1answer
99 views

Google Form keeps changing Spreadsheet cell entry

I seem to be having a bit of a problem, I'm using Google Spreadsheet and have created a form that people would be able to fill in online. It sends that data to a sheet called 'Raw Entry Form', I then ...
0
votes
1answer
115 views

Add timestamp to two different columns in Google Spreadsheets

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
2answers
93 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
1answer
272 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
40 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
3answers
73 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
1answer
118 views

Calculating Time Zones in different columns

I'm trying to reflect different time zones across columns. In Excel, I could just e.g., =A1+2 and it would give me the right time. A B C EST CST PST 1 9:30 11:30 13:30 ...
0
votes
1answer
1k 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
2k views

Auto date added to adjacent cells when data is entered

I am trying to create a spreadsheet to track student loan outs that will automatically put the date in an adjacent cell. The spreadsheet would be set up like this: Column 1 would be "name" Column 2 ...
0
votes
2answers
626 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
1k 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
2k 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
579 views

How to reference Google spreadsheet inside your mail message?

I would like to embed a Google spreadsheet directly into my email, so that it reflects the document changes. How do I do that?
0
votes
1answer
2k 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
29 views

Google Sheets How to Hide or Show Specific Columns using Custom Menu [duplicate]

I've figured out how to create a custom menu, but I'd like to be able to hide or show certain columns (not necessarily ranges), based on what menu item is selected. Not sure on the next steps / can't ...
0
votes
1answer
51 views

Google Spreadsheets updating after every change, which is too often, slowing everything down

I have a lot of independent functions and information in my sheet, and every time I make a slight change somewhere in the sheet, it seems like the entire sheet is being saved and re-updated. So every ...
0
votes
1answer
29 views

Parse error with =IF function

I put this in: =IF(A4=2;1,(A4=4;7,A4)) and it keeps coming up with a parse error and I have tried to switch ; with , and it still didn't work. How do I make this work?
0
votes
1answer
38 views

Tolerant Sum of column

I would like to make the sum of a column which might also contain cells which are not parseable as a number (strings, empty, etc). These cells should just be ignored. I've tried: ...
0
votes
1answer
64 views

Sum cells according to cell colour

I want to sum cells only with a specific cell colour. I'm using this code: function sumWhereBackgroundColorIs(color, rangeSpecification) { var sheet = SpreadsheetApp.getActiveSpreadsheet(); ...
0
votes
1answer
273 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
442 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
488 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
52 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
55 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
171 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
21 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
5k views

How to format the date in this Google Docs script

I've come across this rank checking script. I'm not sure exactly where I found it but it's built on Google Docs and a script which automates the rank checking process. I understand a bit of coding ...
0
votes
2answers
54 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
52 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
70 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
40 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
352 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
38 views

Compare two rows of a sheet to another and show characteristics

I'll try to be clear although english is not my first language. I have a first spreadsheet (let's name it PRODUCTS) containing, in different columns, characteristics of different products ...
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
79 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
584 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 ...