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

learn more… | top users | synonyms (2)

1
vote
1answer
80 views

Formula to return time difference but not display 0 in google spreadhseet

I have a google spreadsheet with start (C) and end (D) timestamps. I am calculating the time difference using =(D1-C1). I have copied the formula to empty columns which returns a 0 time difference. Is ...
5
votes
2answers
3k views

Google Spreadsheet Comments

I have a Google Spreadsheet with several boxes with the little orange triangle indicating a comment associated with that cell. Unfortunately, I haven't made any comments, so cannot delete these ...
3
votes
1answer
405 views

Import CSV, show formatted hyperlinks, =Hyperlink(..,..)

Based on a csv import, I would like to show formatted hyperlinks. There is a formula =HYPERLINK( "www.google.com" ; "Search Google" ) that does this, but is there any way to include this in a csv ...
4
votes
1answer
217 views

Save data from Google Spreadsheet history

I used a Google form and inadvertently deleted a few rows. I need to use the rows again. I see them with history but I can't save them and I can't print them. How can I restore the data?
5
votes
1answer
235 views

Non-deterministic parameters to custom function

I have a problem with Google Spreadsheets: I create a custom function using the Script Editor and it only runs OK if the parameters I pass are known(constant) values. If the parameters are ...
2
votes
2answers
4k views

Is is possible to have part of a google doc hidden publicly but able to be edited and “pushed” to LIVE?

So I have a public schedule for my business, but need to edit (which sometimes takes a few days) and then make "public"... Can I do that? I know I can "hide" but when I reopen, it's live and everyone ...
8
votes
2answers
1k views

Analyse frequencies of date ranges in Google Spreadsheet

I have a Google Spreadsheet where I would like to compute occurrences of date ranges. As you can see in my sheet, there is a column date_utc+1 which contains almost random date data. What I would ...
3
votes
1answer
5k views

Compute number of occurrences in a column of a spreadsheet

I have a Google Spreadsheet with a single column that holds string values (Twitter screen names) such as "user1", "user1", "UserX", and I would like to count those values so that I can easily craft a ...
2
votes
1answer
1k views

Convert a date in Google Spreadsheet?

I have a Google Spreadsheet with a date row in UTC time, such as 12/6/2012 11:14:32 I want GMT+2 local time, so how can I convert the date in Google Drive? And, if not possible, is there a way to do ...
1
vote
2answers
1k views

Counting unique rows in spreadsheets

How do you run the COUNTUNIQUE function on several columns? Running COUNTUNIQUE(A1:C3) gives me 8, because there are 8 unique values, I want it to return 3 because I have 3 unique rows. | A | B | ...
0
votes
2answers
1k views

Sum until empty line function in Google Spreadsheet

I'm using this data layout a lot: A B C 1 Name1 Count Total 2 A 1 =SUM(B2:B4) 3 B 2 4 C 1 5 6 Name2 Count Total 7 D 1 =SUM(B7:B8) 8 E 2 It is ...
3
votes
1answer
265 views

Google Spreadsheet text cell formatting question

I'm trying to create some sort of automated formatting for certain columns (except headers of course.) to take a string of numbers (and previous formatting; which should be stripped.) and format it as ...
2
votes
1answer
552 views

In Google Docs, how to make a column with several numbers in each cell sortable?

I am making an expenses spreadsheet in Google Docs and I need to list the numbers of the attachments for each entry. Sometimes this is just one number, sometimes it is several. I can make this ...
2
votes
4answers
2k views

Translating a document in Google Drive

I'm trying to translate a spreadsheet I've uploaded to Drive and converted to a Sheet. However there is no "Translate" option for me in the Tools menu, as per this article: ...
1
vote
1answer
167 views

Forwarding table content received in Gmail to a spreadsheet in Google Docs

I am managing to receive a fixed structured table from a questionnaire in a web form. So I want to have this table automatically forwarded to a specific spreadsheet, so that I can make my own ...
1
vote
0answers
278 views

Google Sheet document using ImportXML doesn't Automatically Republish

I created a file that uses ImportXML to pull prices from a set of web pages, and bless me, it works! To stay updated with the changes in price, I ticked the "Automatically republish when changes are ...
-2
votes
2answers
316 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 ...
4
votes
1answer
2k views

Creating a function that runs when a Google spreadsheet is opened

I want to create a function which runs automatically when the spreadsheet is opened. This function will make the selected cell the last cell without text in a certain column. Basically, I don't want ...
1
vote
1answer
1k views

Google spreadsheet sorting messes up cell comments

I'm running into this weird problem with Google spreadsheets: if the cells have comments on them and I sort the spreadsheet, the rows sort but the comments stay in the same position, and don't move ...
1
vote
0answers
267 views

How to Create a Dynamic SubTables Based On Data From Another Sheet? (Google Spreadsheet)

I'm wondering if there is a way to create a sheet with dynamic subtables based on data from another sheet in google spreadsheets? Each student will use a form to enter data to sheet: "Entries" like ...
26
votes
2answers
24k views

How to group data in a Google Spreadsheet?

I have the following table in a Google Spreadsheet: Name | Value A | 10 B | 100 A | 20 B | 200 C | 1000 How can I create another table based on a query: select name, sum(value), ...
1
vote
0answers
86 views

Filtering Form Feedback using Google Docs

Does anyone know how to filter respondent feedback into different sheets on the spreadsheet? For example, each sheet collects information for separate classes and I want the form information to be ...
5
votes
2answers
8k views

How to sumif with multiple criteria

My sheet looks like this: 1|A | B 2|amount | source 3|173.00 | bank1 4|173.00 | cc 5|173.00 | cash 6|173.00 | bank2 7|173.00 | cc 8|SUM This is simplified but what I want to do is Sumif A3:A7 ...
1
vote
1answer
134 views

Stop lines in GDocs chart overlapping/obscuring other lines

How can I stop lines in GDocs chart overlapping/obscuring other lines? See for example the green line in the graph below, which starts up high, butthen goes behind other lines such as the yellow one. ...
3
votes
1answer
193 views

Google Spreadsheets Calculation/Reinput Automation?

I have a little basketball stats sheet, and a cell that has a total of a specific player's statistic they have accumulated throughout the season. But there is no way I know of to update this cell ...
3
votes
1answer
156 views

Published Google Docs spreadsheet: one data set with 3 sheets each sorted differently

Is it possible on a published Google Docs spreadsheet to have 3 individual sheets, each sorted differently from the common data, and only update the common data?
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
2answers
127 views

Javascript string() function in Google AdWords

Is there a simple way to implement the Javascript string() function in the basic Google AdWords interface? I want to pass some variables returned from a campaign management script to a spreadsheet ...
1
vote
1answer
1k views

How can I prepare a Sparkline graph (line/bar) in a Google spreadsheet?

How can I prepare a SPARKLINE graph (line/bar) in a google spreadsheet? With the google drive help it doesn't work for me. Reference: Google Drive Help
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. ...
5
votes
2answers
6k views

How do I mix formats in one cell?

I've got a string like ="Daily Avg: " &AVERAGE(C3:C13) I'd like to be able to apply number formats within my cell's formula. Is this possible without custom scripts? I've searched Google's ...
8
votes
5answers
17k views

Leading zeros in google spreadsheet automatically removed

I have a column in which all inputs are numbers. But these numbers are actually not real numbers. Not real in the sense, 050 in this case is very different from 50 The problem is that whenever I add ...
4
votes
4answers
8k views

Summing up spreadsheet data when a column contains “#N/A”

I am using Goggle Spreadsheet to work up some historical stock data and I use a Google function (=googlefinance=…) to import the historical closing prices for a stock, then I work with that data ...
2
votes
1answer
649 views

Pre-populate Google Docs form field with incremental value

I have a Google Docs spreadsheet that I use to track my jobs by job number. Is it possible to have the "job number" field pre-populated with the next job number? Currently I have to open the ...
2
votes
1answer
380 views

In Google Spreadsheets how do I restrict input when the number of entries for a condition are met?

I am using a Google spreadsheet to gather the Registration form entries for our tournament. We can only have 10 teams per age group. How do I "close" the Registration when the number of entries for ...
-1
votes
1answer
480 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 ...
6
votes
3answers
916 views

Sorting data in Google Spreadsheet by cell entry

I have a Google Spreadsheet that lists various events. Students have entered their name next to events that they would like to sign up for. It looks like this: Each student may sign up for more ...
6
votes
4answers
2k views

Google Spreadsheets equivalent of Excel CLEAN() formula

I've created an Excel file where a non-technical co-worker of mine organizes a bunch of data into rows and columns. I then have formulas concatenate across those rows and columns and add some HTML ...
2
votes
2answers
4k views

Can I sum based on a specific cell text value?

I have a spreadsheet for tracking sales leads. Each row is a lead. One of the columns is called "Status" and the options under this column are limited to a list of 4 options, i.e. Prospect, Proposal, ...
1
vote
1answer
2k views

How do you add a date created to Google Forms / Google Spreadsheets

We have a Google Spreadsheet It has a few columns Issue Raised By Date Raised We've turned this into a Google Forms which we want anyone in the business to be able to answer. The problem is ...
2
votes
1answer
829 views

Is there a way to insert a bookmark into a google Spreadsheet?

I know you can do this with a Google Doc, but how about a google Spreadsheet? I'd like to have a bookmark and then link into that cell of the spreadsheet from an HTML document.
2
votes
1answer
1k views

How can you write queries in a Google spreadsheet so that the columns are kept up to date?

Using Google Docs/Drive Spreadsheets, you can write queries. However, if you have column letters in quotes, then they aren't updated as column order changes. Is there a way to write these queries so ...
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 ...
2
votes
1answer
432 views

Text conditionals in Google Spreadsheets

I want to write a formula where I can add values to a cell whether another cell states approves the "transaction". It will be easier to explain with an example. Consider a spreadsheet containing the ...
5
votes
1answer
5k views

Auto create and name new sheet in Google Spreadsheet

How can I automatically create and name new sheets in a google spreadsheet from a list of names, such as a student roll sheet? I would like each new sheet to be created when I add corresponding names ...
3
votes
1answer
868 views

How to use a named column in a calculation based on a cell value in Google Spreadsheet

Playing with named ranges, I discovered it is possible to name a whole column (say "September") and use it in rows: =September*K4 What I'm trying to achieve now is that the value of the column ...
4
votes
2answers
978 views

How can I dynamically format the diagonal cells in Google Spreadsheet?

I want all of the diagonal cells (A1, B2, C3, D4, E5, etc) of a Sheet to be formatted as Black Background, White Foreground. Is there any way to do this for a Sheet that constantly increases in size? ...
3
votes
1answer
10k views

Is it possible to refer to a whole column in Google Spreadsheets using R1C1 format?

In Google Spreadsheets I often use A1 notation to refer to a whole column: A1:A For reasons I explain below, I'd like to use R1C1 format, to refer to a whole column, something like: R1C1:C1 It's ...
6
votes
3answers
22k views

How can I automatically set “last updated” cell in row Google Docs Spreadsheets?

How can I automatically set "last updated" cell in row Google Docs Spreadsheets ? I want to create a column where the cells' value will be automatically set to when that row was last amended. Is this ...
0
votes
1answer
3k views

Reseting responses in a GoogleDocs Form

I want to reuse a GoogleDocs Form, with (almost) the same Form, but with fresh Responses. I did copy it, but I don't know how to reset responses (not reseting the form itself, i.e. Form/Delete Form). ...