A productivity application from Google that allows you to create and edit worksheets

learn more… | top users | synonyms (2)

2
votes
2answers
851 views

Date Formatting in Google Spreadsheet

I use a spreadsheet in my medical office for referrals. It includes places to fill in these three areas: date faxed, date of the appointment, date the appointment office notes were received. The ...
0
votes
1answer
3k 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
0answers
27 views

How to have function input row/cell automatically update in response to new data? [duplicate]

I apply a function, such as SUM(A10:A20) to a set of data. When I give A21 a value I would like SUM(A10:A20) to automatically update to SUM(A11:A21), "following" the last X number of cells in a ...
3
votes
2answers
4k views

How to extrapolate data in Google Spreadsheets?

Can I extrapolate data in Google spreadsheets? Given a set of values as 10 12 14 16 18 I would like to "estimate" that the next values will be 20 22 24 and so on. I realize there are several ...
1
vote
1answer
425 views

Duplicate check while creating Google Contact with Google Apps Script

I have the following code which creates Google Contacts from a Spreadsheet. The problem is whenever I run the code it creates contacts but has no functionality to check if the same Google Contact ...
2
votes
2answers
387 views

How to get a value from column 'A' in every 30th row in Google Spreadsheet?

I have a sheet from which I want to get values from column A of every 30th row. I tried =A(2+30) but it just gives me an error.
3
votes
2answers
1k views

Google Spreadsheets function to copy array

Is there an array function to copy an array? I use the workaround =TRANSPOSE(TRANSPOSE(A1:A30)) currently. An example of when this is useful: you have a worksheet of raw data, and another worksheet ...
4
votes
1answer
91 views

Why is my imported time 668 seconds ahead of the value in the original cell? Is this reproducible?

I wonder if anyone can explain or reproduce the following test case. It demonstrates that GMT-06:00 Central Time - Tegucigalpa is 668 seconds ahead of GMT-06:00 Central Time, which seems like an ...
3
votes
1answer
1k views

Automatically create a new row each day, on top of older rows

I am looking for a way to automatically create a new row on top of older rows each day. Inside of this row should be the current date.
4
votes
1answer
446 views

Pull Twitter Posts into Google Spreadsheets

I would like to set-up a Google Spreadsheet that automatically pulls Twitter search results into the cells. For instance, I'd like to search for "pizza" near "baltimore" and then have any pizza ...
1
vote
1answer
665 views

Changing an onEdit function to run onOpen

I have the function below (found online and adapted and it works) that is an on-edit function, but I want it to run/trigger when an import is done OR on open, as the data will not really be edited it ...
4
votes
1answer
157 views

Sharing a Google Spreadsheet but making some information private

I book reservations for a sports team and need to be able to communicate with other parts of the arena what hospitality areas are booked/available. In the past there have been multiple e-mails, ...
0
votes
4answers
502 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 : ...
9
votes
2answers
4k views

In Google Spreadsheet, finding what formulas reference a given value

I would like to find out which cells have formula dependencies in a large spreadsheet. I am looking for a way to do something like OpenOffice Tools>Detective>Trace dependents and Edit>Find ...
1
vote
2answers
871 views

Google Spreadsheet =ImportHTML #value error for specific URL

I'm trying to get the data from http://wodindex.wikispaces.com/ into my spreadsheets. Also from a different subdomain of wikispaces.com the grabbing doesn't work. Trying to get data from this site ...
1
vote
1answer
209 views

Is it possible to use the importHTML function with a concatenated URL?

What I'm basically trying to do is use a URL previously made with the CONCATENATE function in an IMPORTHTML function. When I try importHTML (H1, "table", 0) Where H1 is the cell with the ...
1
vote
2answers
290 views

How can I make a Google spreadsheet Function reference one column's value and adjust it to a different Value?

I am trying to create a spreadsheet that will calculate varying sizes. I need it to reference a key where a letter is an established size such as H=1984, S=672, etc. so as that that column can be ...
3
votes
1answer
179 views

Data Validation Criteria

I am currently trying to change cell validations cell range in Google Spreadsheet base upon a cell's input. For instance, if A1 = 123 then have B1 (which is the data verification cell) pull from ...
2
votes
0answers
95 views

Automatic data sharing between Google Docs files [duplicate]

Is it possible to automatically update information on a Google Presentation or Document based on information in a Google spreadsheet? For example, I could create a presentation that contains a graph ...
4
votes
0answers
177 views

Comments disappeared from Google Spreadsheet cell [duplicate]

I have been working on a shared Google Spreadsheet for months. All of a sudden, the comments have disappeared from the cells and now only appear in the discussion thread. How can I get them back to ...
5
votes
2answers
2k views

How to avoid “invoked too many times per second” error

I made a Google Apps Script, but often I get this error: Script invoked too many times per second in this Google user account. This is the script: function papersControl(tipo, col, prev_cell, ...
4
votes
2answers
1k views

Is it possible to select a whole column for chart data in Google Spreadsheets?

I've got a Google Spreadsheet that's written to by a sensor system approximately every thirty seconds. Each insertion adds a row to the bottom of the spreadsheet. I've got a graph of this data. ...
2
votes
1answer
1k views

Copy subset of rows from one sheet to another, based on value in column

I have a sheet with accounts, consisting of 3 columns: Accountnr Name Category This sheet is not nescessarily sorted on any column.The Category is one of three possible values. I want to fill a ...
4
votes
2answers
10k views

Remove empty rows in Google Spreadsheets

Is there a way to in Google Spreadsheets to remove / delete empty rows? Ideally I'd like to be able to select the columns to check.. ie. Select columns D, E and remove all the empty rows from them or ...
2
votes
1answer
149 views

Custom Actions in Google Spreadsheet

I find that I often change specific cells from black on white to white on black when I'm making spreadsheets. It get's tedious to change the background color, then the foreground color over and over ...
1
vote
2answers
984 views

REGEXEXTRACT and French accents in Google Spreadsheets

I have the following formula: =REGEXEXTRACT(source!A2,"^[\w\s\À-ÿ]+") where source!A2="Ancien Marché Saint-Jacques (1125, rue Ontario Est)" and I would like to extract Ancien Marché ...
2
votes
1answer
1k views

How to automatically open a created text document after it being created

I've used this script to create a Google Document (like word document) with Google Spreadsheet. But, when I do so, the new text document created from a template is placed in the default chosen folder. ...
5
votes
3answers
24k views

How to automatically insert a new row and retain functions/formulas from last row?

I have a table with cells that have functions/formulas, like this one: I need a script that creates a new row, copying with it the functions/formulas of the last used row. I find this script which ...
1
vote
1answer
816 views

Create New Google Spreadsheet with timestamp

I'm trying to create a new spreadsheet once we select the specific function from the custom menu item that's selected. I want the new spreadsheet to be "Sheet" & "Timestamp". Can anyone point me ...
2
votes
1answer
1k views

How to make a simple two column data chart in google spreadsheet? (simple case but doesn't seem to work)

I have a column with dates and a column with an amount of money. I just want to make the simplest chart possible, a line chart that shows money as a function of time, so I can see in what dates I tend ...
-1
votes
1answer
289 views

Mileage Calculator Google Spreadsheet

I am trying to calculate miles driven for two different companies. I want to make a cell that will add up only data from Company A, and a cell that will add up data from only Company B. EX: COMPANY ...
1
vote
0answers
461 views

How can I get a cell to change it's value based on another cell's color?

So I have three colors in column F, green, grey and red. What I want is for column G to display a number (1, 2, 3) depending on the color value of F. Is there a way to do this? Here is a link to a ...
1
vote
1answer
375 views

How do I reference only the elements of a multi-column range that meet particular conditions?

I have a spreadsheet made up of several individual sheets: one sheet for each category of product and one sheet designed to be a "global view." In each sheet is a 3-column range of variable length ...
6
votes
2answers
16k views

How to insert the current date into a Google Spreadsheet?

I've got a spreadsheet in Google Drive and one column is meant for the date the entry is made. Is there a button to do this? I'm aware of the functions =NOW() and =TODAY() but their description says ...
1
vote
0answers
147 views

Relative paths to other sheets inside a Google Spreadsheet

I'm trying to put our food recipe collection into a Google Spreadsheet. On the first page we have an index of all the foods. Each recipe is located on a separate sheet. We would like to be able to ...
5
votes
1answer
3k views

Multiple substitutions in a single text

Is it possible to write such a formula that it will substitute in a text value all occurrences of few values with their replacements? For example I would like to substitute all occurrences of aaa ...
1
vote
0answers
316 views

Google Sheets: Reference one sheet from another, where the user may not have view access to the referenced sheet

This is what I'd like to do: The public (even you!) would have view access to a particular Google sheet. It would draw data from another Google sheet, which you DO NOT have any access to. Using ...
2
votes
1answer
290 views

Chart with points in Google Spreadsheets

I have a Google Spreadsheet with a line chart. Despite the name "line chart", the data does not appear regularly spaced on the x-axis but according to a date column. (This shows up correctly, no need ...
-1
votes
1answer
3k views

Insert Text Google Spreadsheet [closed]

How do you enter text boxes in a google doc spread sheet? In google doc excel spreadsheet, I want to skip a few spaces between words. Google doc allows me to insert spaces, but when I am finished ...
1
vote
1answer
87 views

How do I add a range of numbers positioned relative to its criteria?

I'd like to sum up some named values by referring to their names in a separate sheet. Can I do this with a single formula in the second sheet? Sheet 1: | A | 3 | | B | 5 | | C | 2 | | D | 4 ...
1
vote
0answers
82 views

Auto paste formula on form submission

I have searched and tried various solutions elsewhere but none seems to work for both conditions. I would like to have the formula: =IF($A2="Elementary", VLOOKUP($B2,'ELEM PRINCIPAL'!$B:$AA,7,false), ...
1
vote
1answer
410 views

How can I set the increment value for Google Spreadsheets to auto-increment?

I have a series of cells referencing other cells: | Row | a | b | col B shows | |-------------------------------| | 1 | 1 | =a2 | 2 | | 2 | 2 | =a4 | 4 | | 3 | ...
1
vote
1answer
187 views

Inserting rows and adding a cell reference

I'm trying to automate adding new rows if I'm on the last few rows of my sheet. It works, but since I'm also adding a cell reference to it, and checking the amount of free rows left using ...
0
votes
1answer
2k views

Getting SUM function to work in Google Spreadsheets

I'm trying to get something like this. These are all in minutes I guess it goes that way when I type them like this. Number Time After Work TOTAL 1 1:52 2:00 ...
0
votes
1answer
201 views

How do I select a range programatically in Google Spreadsheets?

I have a spreadsheet like this: active date name 1 1-Jun-2013 Paul 1 4-Jun-2013 Sheela 1 8-Jun-2013 Paul 1 2-Jul-2013 Henrik 3-Jul-2013 Henrik ...
1
vote
1answer
2k views

Google Spreadsheets - how to add carriage returns to CSV downloads

In reference to this question: Google Spreadsheet downloaded as CSV comes out on 1 line? Is there anyway to have a downloaded Google Spreadsheet incorporate carriage returns and linefeeds such as if ...
1
vote
1answer
249 views

How Many Ways To Sort in Google Spreadsheets

When I'm working in a Google Spreadsheet, I always use the same routine to perform a sort. Are there more ways to sort, that lead to Rome?
4
votes
2answers
3k views

Paste format only in Google Spreadsheets with Chrome as the browser

I want a working keyboard shortcut for Google Spreadsheets, that lets me paste just the formatting. Google says the shortcut for copying just the formatting is Cmd+Alt+C, and pasting just the ...
15
votes
3answers
12k views

How to reverse the order of selected rows?

Is there an easy way to reverse the order of selected rows? (Or how about all rows, if that's easier.) Specifically, in this case, there is no column that could be used for sorting to get them in ...
0
votes
1answer
80 views

Copying data, based on the value in a cell

I've been trying to work out how to copy data from cells on a worksheet into another based upon the value in a cell. We have weekly data so for arguments sake Week 1 Week 2 Week 3 Week 4 ...