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

learn more… | top users | synonyms (1)

0
votes
1answer
125 views

Google Spreedsheet, Auto sort in categories

So I want to sort my Spreadsheet on Google but it remain in the Categories that it's laid out. I can get to it sort double columns but the categories get messed up as they move away from where they ...
0
votes
1answer
237 views

IMPORTRANGE formula query to query data in another file

Is it possible to create two different files where in the first I put the data and in the second the references query? I used IMPORTRANGE but this method gives me "=CONTINUE(A1; 2; 1)"... I want to ...
0
votes
0answers
713 views

How to make Google Spreadsheets recognize data as numeric

I have the opposite of a fairly standard problem -- how do I force Google Spreadsheet to understand that a value is numeric? It seemed like using Format > Number should do the right thing, but it did ...
0
votes
2answers
1k views

Google Spreadsheets formula question: do not include cell in a formula if blank

I am a music teacher and I use the following formula to calculate my students performance grades: =100-SUM(F3-5)*-7 How can I change the formula so it only calculates a grade if there is data in ...
0
votes
0answers
268 views

Query google spreadsheet and display single column?

I am working on using Google Spreadsheets as a gradebook. I am attempting to display only a student's grade, not an entire classes. I am integrating this into my wordpress site. The function I want to ...
0
votes
1answer
205 views

Question about a Google Spreadsheet function (I don't even think of how to describe it in the title)

Pretty much what I'm trying to accomplish is the following: Cell F1 is a drop down menu. If F1 contains the words "whatever", then look up the word in A2 on sheet 2, and input the data in 3rd ...
0
votes
0answers
154 views

Create new document within spreadsheet and link

I would like to create a spreadsheet script that allows me to create a new document every time I click on a new cell or row and then have that document links back to that cell.
0
votes
0answers
327 views

Google spreadsheet revision history — too much detail

For word processing, Google Docs revision history is great. However, for some of my spreadsheets, something isn't working right: Revisions are not grouped together, multiple for each minute. "Show ...
0
votes
2answers
3k views

How to auto increment a field in Google Spreadsheet

In my spreadsheet I have a column called S+ No. How to auto increment this for each row, like: S1,S2,S3,S4 In short how to make it dynamic.
0
votes
0answers
437 views

Google spreadsheets - “=ImportHtml DIV” how to?

I play Runescape and I want to make a tool that people can use to make profit in the game. My problem is that I am not sure exactly how do use a command to pull data text from a div element. The ...
0
votes
0answers
16 views

Google Spreadsheet: reference seperate spreadsheet [duplicate]

Possible Duplicate: How do I link a cell in Google Spreadsheets to a cell in another document? Is it possible with a Google Spreadsheet to reference a cell to another spreadsheet using a ...
0
votes
1answer
6k views

How do I use the INDEX or OFFSET functions in Google Spreadsheets?

I have my spreadsheet set up as follows: first 10 columns full of descriptive data followed by 24 columns of month data (2 columns per month). The last 24 columns are static and the values are ...
0
votes
1answer
164 views

Automatically add values before and after Google spreadsheet

I have a library of flags online and would like to have a client-foolproof solution for adding flags. Right now my function looks like this: =image("http://www.website.com/flags/us.png", 3) But I ...
0
votes
1answer
507 views

Query multiple Google spreadsheets

I have the following sheets: ListA ListB ListC Note: at each sheet I have a column which contains YES or NO. How do I query all my lists (spreadsheets) where myBooleanColumn equals to YES/NO?
0
votes
3answers
3k views

Protect entire column of a Google Docs spreadsheet

I select a column (e.g. Sheet1!A:A) to be protected, then in the right pane I edit the settings (name, permissions), and finally I click Done What happens: The protected range then switches to ...
0
votes
1answer
811 views

Google spreadsheet validation data empty cell

So I'm struggling with the following: I have this formula (I know it's huge but it works so far) =IF(AND(COUNTIF(basictier1;"*"&A4&"*"));"T1 Basic"; IF ...
0
votes
2answers
1k views

Create a dropdown list of options from VLOOKUP

What I'd like to do is get a dropdown list of options from a VLOOKUP type function where I can select the value for the next lookup. Example Here the data I'm using for reference. Notice "AAA" ...
0
votes
0answers
1k views

Change value in one cell through a formula in another cell

I am trying to capture a timestamp for when a spreadsheet is first edited, and ONLY keep that first timestamp. However, NOW() updates each time a spreadsheet is edited. I found a working formula ...
0
votes
1answer
816 views

Google Spreadsheet Change X and Y Axis

I am trying to graph the temperature of a substance versus the time the substance has been heated. My data is as follows: A | B Time (Minutes) | Temperature (ºC) 0 ...
0
votes
1answer
81 views

Google Spreadsheet Paste

I need to copy and paste content from one sheet to another sheet within the same file, keeping formulas where there are formulas, and keeping data where there is just data. I tested every past ...
-1
votes
1answer
660 views

Writing a spreadsheet script

The above link is a picture of the Google Docs spreadsheet that I am working on. Basically it is a sale ticket for a small appliance parts store. I need to be able to select a range of rows and ...
-1
votes
1answer
171 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
votes
1answer
923 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
votes
1answer
1k 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?
-1
votes
1answer
23 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 ...
-1
votes
1answer
80 views

Google Spreadsheet: add automatically the same formula in each new row of a column. Also with “SUM”

I have this sheet: https://docs.google.com/spreadsheets/d/10YVUO2a-XftaCOX73tOiOwQfu0t80iKPJjQrRDiht1A/edit?usp=sharing In the column "E" I need the same operation as ARRAYFORMULA in column C and D. ...
-1
votes
1answer
20 views

How can I get a column with the sum of the proceeding rows from another column?

I've got a series of withdrawals and deposits for an account, each in a row. I'd like another column that for each row, displays the total amount in the account after that row's withdrawal or deposit. ...
-1
votes
1answer
26 views

Help with formula

this is what I am trying to do and need a formula for column C on the tee sheet
-1
votes
1answer
431 views

How to get the Elapsed time of two cells hh:mm in Google Spreadsheet

In columns K and L I have time stamps. Let's say 03:30 is in column K and 04:30 is in column L. I want the total elapsed amount of time in hh:mm in column P. I have tried the average function, ...
-1
votes
1answer
150 views

In Google Sheets, how can I fit the data to the cell?

In some cells on my sheet the data fits the cell. On some rows there is a lot of extra space after the data in each cell. I have tried deleting after at the end of the data, but it does not help. ...
-1
votes
1answer
391 views

importxml is not working properly -Google spreadsheet

find attached link for my Google spreadsheet in which i tried to pull out the data from booking.com. i retrieved Hotel name in column. it successfully retrieved the hotel name. but not work with ...
-1
votes
1answer
2k views

Google Docs ImportXML can't scrape anymore?

ImportXML lets you get information from filetypes such as xml, html, csv, tsv, as well as RSS and Atom feeds. This example in Google Docs Help for importXml function - =importXml("toysrus.com";; ...
-1
votes
2answers
83 views

Create a formula based on the number of columns in Google Spreadsheets

I have two rows of data Row B = price of product Row C = quantity of producst I need to get the summary price: (B1xC1)+(B2xC2)+(B3xC3)+..+(Bn+Cn) I don't know n (quantity of columns) because n ...
-1
votes
0answers
20 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 ...
-1
votes
2answers
32 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
-1
votes
1answer
39 views

How do I eliminate extra line breaks in a google spreadsheet cell?

I have a google doc in which some cells have multiple carriage returns. I would like to eliminate all the extras, so that 4 carriage returns shrinks down to just one. This question is similar to How ...
-1
votes
1answer
105 views

ImportHTML spreadsheet function to update every 5 mins

I have a Google spreadsheet fetching stock exchange data using an ImportHTML function: =ImportHtml("http://www.xxxx.xx.xx/xxxxxxxx/livefeedfull.aspx/?"& year(now()) & month(now()) & ...
-1
votes
1answer
131 views

Help with conditional formatting in Google Spreadsheet

I have a Google Spreadsheet with several sheets. I have it set up to where orders auto populate 3 of these sheets when entered into the Order info page. I need to set up a function where only ...
-1
votes
1answer
33 views

How to have charts include added rows in google docs

The problem is, it it's modifying my range selection. In the chart I select ranges Sheet2!A:A, Sheet2!B:B, but after clicking ok, and going back into the chart, it modified my range selection to ...
-1
votes
1answer
62 views

Track/compare my inventory with my supplier [closed]

I'm trying to use Google Spreadsheets to track/compare my inventory with my supplier, but I'm having some issues. I'm able to download an up to the minute inventory log form my vendor, but I can't ...
-1
votes
1answer
110 views

Using “if” (or other function) to recognize a string and sum values

I started programming just a few weeks ago, got a grasp on the concepts and been evolving on it, since I have certain activities with spreadsheets, I decided to take it to the next level and got stuck ...
-1
votes
1answer
41 views

Help with a previous question you answered

I noticed this code from a thread I was reviewing as I needed the same functionality to provide a timestamp when a particular row is edited in a Google Spreadsheet; function onEdit() { var s = ...
-1
votes
1answer
2k views

In Google Drive, how to search something in a Spreadsheet while using Android Tablet? [closed]

I have a 1000 rows Google Spreadsheet in my Google Drive and using the Google Drive app on my Nexus tablet. I can't perform a search or use Ctrl+F option. Any ideas or alternative ways to achieve ...
-1
votes
1answer
77 views

Editing a Google Docs response sheet

I want a response from a 2nd form to be able to update (or add a new cell) in an existing form. Is it possible? What i want to achieve is i show only some of the information to a third party, and i ...
-2
votes
2answers
278 views

Google spreadsheet questions

Can anybody tell a me how I can load a large vertical list into the margin of a spreadsheet? e.g, I want to copy a list of stocks from notepad (aligned vertically) to Google spreadsheet with each ...
-2
votes
1answer
816 views

Simple row references in Google Spreadsheets and resorting data

This is my scenario Users are entering data into rows with several columns Last column is calculated on values of few previous columns (so it's row number independent). While entering new and ...
-3
votes
1answer
196 views

How do I conditionally format based on the value of cells in a column?

Unable to create a script. I would like to know if there is one that would allow me to color an entire row based on the value (a different color value) that I will find in the cells of column B. For ...