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

learn more… | top users | synonyms (1)

-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
425 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
145 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
383 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
2answers
30 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
35 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
78 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
0answers
25 views

How can I add new row value to mentioned column in the sheet which has multiple columns with unequal lenght?

I have three columns in spreadsheet with unequal row length. For example, Column A has 5 row, column B has 7 rows and column C has 2 rows. When I wanted to add for example column A with the AddRow ...
-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
32 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
109 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
66 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 ...
-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 ...
-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
815 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
195 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 ...