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

learn more… | top users | synonyms (2)

-1
votes
1answer
657 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
439 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
3k 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
92 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
5 views

I am having problems inserting text into a google sheet on my android device

I wish to insert text into a spreadsheet created on my PC,and saved to drive. I want to do this on my nexus 10, android 5.1, either in drive or google sheets
-1
votes
1answer
10 views

google sheet conditional formatting

i'd like to change the date / time that passes the current time to turn red. i'd like to change the date that passes the current time to turn red. the table has dates and time in different formats, ...
-1
votes
0answers
22 views

how can i deliminate a cell(s) with multiple values into new rows in google response sheet

I have created a Google form that has a lot of logic branching or condition based questions. However the "Then" part of conditioned based question allows a user to select multiple values based on the ...
-1
votes
0answers
60 views

How do I use JSON in Google Spreadsheets using an IP specific token?

I am trying to import data from https://api.heroesofnewerth.com/readme.php which only provides you with ip specific token. I found this import json script for google spreadsheets but I cannot get it ...
-1
votes
1answer
35 views

google query: numeric before query, query results not a number

I have a column of values, let's say column A, that if i do =isnumber on any of the column data it returns TRUE. now after I =query and select A, the query gives me the right values, but the type ...
-1
votes
0answers
28 views

Array in Google Spreadsheet that tracks totals per name [closed]

I am building a spreadsheet that tracks "stats" for a group of people that change from week to week but also have people participating in the sport on multiple weeks. In my array I have a column ...
-1
votes
1answer
88 views

Google sheets query with sum and group by

I am trying to have a query that selects certain columns checks a date criteria, sums up total and has a group by criteria. My formula is not working. can you guide me into what i have done wrong? ...
-1
votes
1answer
137 views

Google Sheets Suffix To Column Cells [closed]

I'm editing a spreadsheet of product data that has a category column. I'd like to create a new "Left Handed" as well as "Right Handed" category in addition to each products current categories. I've ...
-1
votes
1answer
686 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
197 views

Google Form to Spreadsheet formula questions (index/match array and 24hr-12hr clock)

I need help with a Google Spreadsheet populated by a Google form. I cannot get the following formula to work correctly with my form submissions: =(ARRAYFORMULA(if(row(H:H)=1,"Language",(INDEX('INDEX ...
-1
votes
1answer
159 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
35 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
72 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
134 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
42 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
964 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 ...
-1
votes
1answer
89 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
84 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 ...
-2
votes
2answers
299 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
2answers
46 views

Interleave cells from two column ranges

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
-2
votes
1answer
284 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 ...
-2
votes
1answer
895 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 ...