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

learn more… | top users | synonyms (1)

0
votes
0answers
10 views

Import a CSV file Google Spreadsheet

I am trying to upload a CSV file and importing it to Google spreadsheet, the file contains the following hi,hello\r\nwelcome,to\r\npeaceful,world what is expect in the Google spreadsheet is ...
0
votes
1answer
18 views

How to sum values by month

I'm trying to have my spreadsheet to sum up values by month. Note that the dates are not organised chronologically. I've tried the solutions showing here but they are not working for me. I'm not ...
0
votes
0answers
7 views

Equivalent of Google's ImportXML in Excel Online

I wonder what is the equivalent of Google's ImportXML in Excel Online? I basically need my workbook to get an external XML data, and refresh it every X minutes.
-1
votes
0answers
8 views

Countif Color- Google Docs reference Sheet 1

I have a worksheet with two tabs. I would like second tab "Summary" to count cells in given range based off color. Below is the VBA that seems to work for that. However, I need it to count colored ...
0
votes
1answer
13 views

Counting Instances in Google Sheets

At my school, we have a Google Form for recording classroom discipline. The form generates the standard spreadsheet. I want a list of how many times each unique student has received a disciplinary ...
2
votes
1answer
21 views

How to extract website title into row?

How to extract title (or other meta descriptions) of the website into row using Google Docs? E.g. www.google.com
1
vote
2answers
37 views

Issue with Custom number format in Google Spreadsheet

I have a number cell formatted in this way: #,#" days";. Nevertheless, if I write 1.5the output is 1 days even if the content is still 1.5. Otherwise, if I write 1,5 the output will be as it is ...
-1
votes
0answers
22 views

How to create a weekly report that takes values from another sheet which has monthly values in Google Spreadsheets

First things first. Here is the link: https://docs.google.com/spreadsheets/d/1u3-U9aHXHzZmWGWKXpaToHvJmtYFmSxUItZ3pgfgz9E/edit?usp=sharing Problem: I need the cells E29:E43 in the table in "Weekly ...
1
vote
1answer
36 views

Can I subtract a cell value in another cell that already have one in Google Spreadsheets?

Let's say that I have two cells A1 (time needed) and B1 (time spent). I want that when I enter a value in B1 the value of A1 will be reduced automatically. I want that in some way I could enter in ...
1
vote
0answers
11 views

Track changes in read only shared google docs

I have shared a spreadsheet, anyone having the link can see it. Since it is a spreadsheet I update daily, I want to facilitate the others recognizing the last changes. However, revision history is ...
0
votes
1answer
24 views

Show all hidden rows and columns when I open a Google Spreadsheet

I want to un-hide all the hidden rows and columns when I open the spreadsheet. How can I do that for all sheets?
0
votes
0answers
17 views

Konami code in Google spreadsheets no longer working?

The Konami code in Google spreadsheets seems no longer working. Is that gone or just moved? http://m.xkcd.com/1172/
0
votes
1answer
38 views

Is there any way to use a formula in a Google Sheets filter view?

I have a sheet with a column of numbers. I'd like to create a filter view that only shows rows with a value greater than 500, but I can't find any way to do that. There are lots of different numbers, ...
3
votes
1answer
25 views

Is there a way in Google Sheets to order blank cells first?

When I sort a column in Google Spreadsheets, the blanks always seem to sink to the bottom. Can I have rows with blank cels be organized first / highest? Alternatively, is there a function wherein I ...
0
votes
1answer
51 views

Return value in column A in preceding cells in column B using an Array Formula

I've been looking for a solution to this for days now. How do you fill cells in column B (using an array formula) that are preceding the cell in column A with the value of column A only when cell in ...
2
votes
1answer
105 views

How do you extract a number from a URL as raw text?

So I have a list of Google+ profile links in a Google Sheet https://plus.google.com/112337650380234682548/ How can I extract the number on the end in a seperate column? I've tried ...
1
vote
2answers
60 views

Calculate time values in a single Google Spreadsheet cell

Is there a way to add two times, or durations, in one line in a Google Spreadsheet? Something like: =1:14:25+0:17:12 I know that I can use the time command in-line, and that I can add times from ...
-1
votes
0answers
16 views

Countdown timer in javascript [duplicate]

Can someone check the javascript code and see what can be done. I am struggling to add B2 time to the start time I think i need to convert B2 time to milliseconds and them sum with the start time to ...
0
votes
0answers
23 views

How to get Google Spreadsheets to auto-update a reference to another sheet

Referencing: How can I get Google Sheets to auto-update a reference to another sheet? I am trying to do the EXACT same thing for the EXACT same reason. I assume this is a VERY clever work around but ...
0
votes
0answers
17 views

OR function doesn't work inside FILTER [duplicate]

When I use FILTER(A2:A; OR(C2:C >0; D2:D >0)) I get different range intervals error, but when I remove the OR it doesn't return an error. So why OR function can't be used with FILTER function?
1
vote
1answer
21 views

Google Spreadsheet add rows until marker

I have a spreadsheet of the form ItemA Subitem1 5 Subitem2 4 Subitem3 7 <potential marker> ItemB Subitem 4 I want to sum the values next to Subitem to a total next to ItemA, ItemB, ...
-1
votes
0answers
17 views

automatic date filling in column B when column A has a value in Google Spreadsheets [duplicate]

What function I need to choose so that when in column A I enter a value , the date in column B to fill automatically ? I tried to do this : B2==if(istext(A2),today(),"") The problem is I the date ...
2
votes
1answer
43 views

Consolidate List of Similar Data into Single Row in Google Spreadsheets

I have a Google Spreadsheet that lists donations given by constituents with a unique account number. Several constituents have made more than one donation in a given period of time listed separately. ...
0
votes
0answers
64 views

Countdown timer list

Can someone check the javascript code and see what can be done. I am struggling to add B2 time to the start time I think i need to convert B2 time to milliseconds and them sum with the start time to ...
1
vote
1answer
27 views

See last modification in Google Drive/Spreadsheets

In my Google Drive I see when a spreadsheet was modified: How to go about seeing what the modification was?
0
votes
0answers
7 views

Keep track of printing in Google Sheets

In Google Sheets is there a function that will record and update a field every time a file is printed? Couldn't find anything in the docs. I'm trying to automate a version number for printed hard ...
1
vote
1answer
30 views

Conditional Cumulative Sum using Arrayformula

I saw a nice solution for the cumulative sum problem here: Cumulative Sum without Script My question is how do you make this conditional? I mean cumulatively sum only numbers that belong to a certain ...
4
votes
2answers
66 views

Google Spreadsheets Row Insert Reference Updating Behavior

I have a Google Spreadsheet with one column and two rows: cell A1: 2 cell A2: =A1 (displays as "2" because of the reference to A1) If I insert a row between these two rows (by right-clicking on row ...
0
votes
0answers
14 views

Hyperlink to a cell in a Google Spreadsheet

I want a user to be able to click a link that sends them to the specific cell in a specific spreadsheet. The spreadsheet must be in edit mode aswell.
0
votes
2answers
18 views

Google Sheets advanced lookup + sum

I'am try to get the total results of multiple sheets where i have in collum A a dropdown list with value 1 to 3 for example. in total i have 12 sheets (once for each month) and i want of all the ...
0
votes
0answers
12 views

Spreadsheet not sorting properlty

When I attempt to Sort a spreadsheet by the information in a column I am greeted with the result: "This operation is not permitted because it would alter the structure of this table. More ...
3
votes
1answer
33 views

Google spreadsheet: calculate start and end rownumber of first non-empty range

I have a column B which may have a value 1 or is empty. I want to calculate 2 fields: startFirstRange: the start rownumber of the first non-empty range, or -1 if not exist. endFirstRange: the end ...
1
vote
1answer
43 views

Google spreadsheet: check if cell itself is empty

Is it possible to have a formula somehow on cell A1 that checks as a conditional if A1 is empty? Obviously, the default way I'm getting a circular dependency error. However, I figure some formula ...
2
votes
1answer
47 views

Google spreadsheet: execute function only once to prevent circular dependency

I'm trying to do something like this: a1 = if(a1 = "", b1 + 1, ) ... aN = if(aN = "", b1 + 1, ) b1 = max(a1,1) The idea is that column A has unique ID's, and b1 keeps the highest generated id ...
-1
votes
0answers
9 views

Major FIREFOX Redirect Error Problem (Error Code 11156) [migrated]

I would appreciate some help please. When I try to log into some website, im being redirected to the members only page (e.g. dashboard, main account, etc) but instead of successfully landing there as ...
0
votes
0answers
21 views

Google sheets equivalent of self-referencing in Excel

This is, in my opinion, one big advantage Excel has over Google sheets is the self-referencing formulas. What I mean by that is: say in cell A1, I'm changing the value in there a,b,c. And according ...
0
votes
1answer
17 views

Search for multiple variables in multiples rows at the same time in Google Sheets/Drive

I'm using Google Sheets (only option, sorry, know this should be a database). Sheet 1: List of 200 employee names, and up to 10 location codes they are frequently assigned to. Sheet 2: List of 50 ...
3
votes
1answer
45 views

How do I convert a cell to RFC 3986 standard (URLEncoded) in Google Spreadsheets?

Is it possible to convert text from a certain cell to RFC 3986 (http://url-encoder.org/) in a Google Spreadsheet? Lets say C4 has the value John Doe, then D4 must be John%20Doe.
2
votes
1answer
81 views

Element-wise operations on cell ranges in Google Spreadsheet

In Google Spreadsheets, what does one obtain if operations are performed on a range of cells? Have a look at the following example: Intuitively, I would expect the result to be 14. This is the way ...
1
vote
2answers
40 views

Google sheets: is CHOOSE different from Excel?

I need to select randomly between two strings, say "A" and "B". I do =CHOOSE(RANDBETWEEN(1,2), "one", "two") It doesn't work. Neither =CHOOSE(1, "one", "two") It shows ERROR.
1
vote
3answers
77 views

Google sheet, lookup a value to get whole column

Here is my problem: I have a table starting in A1 with D D C B A 1 2 3 4 5 6 7 8 I want a function that returns me the column of data of whatever letter give it. ie input:=function("C") output: ...
0
votes
1answer
25 views

Counting specific words

I want to count how many times in a column certain words from a predefined set appear. In this example those specific words will be days of the week. For example: Mon =3 Tues ...
1
vote
0answers
21 views

How do I avoid cells being printed as “Loading…”?

When I print (or export to PDF), some cells has value Loading... instead of actual value. It looks like Google Spreadsheet was still calculating values when it converted document to a PDF, although ...
-1
votes
1answer
51 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 ...
0
votes
1answer
39 views

How to mix numbers formula in text format to formula format? [closed]

I have formulas that created 8/39 5/39 4/39 Now in C1 I want the sum of them and in D1 percentage of it. I cant execute slash from text. =A1+B1+C1 doesn't work.
0
votes
1answer
27 views

Average with parametric cell in Google Spreadsheet

I'm desperately looking for a way to write a function like this: =SUM(A1:CELL(B1))/COUNT(A1:CELL(B1)) where CELL(B1) contains a text, for example "A37". In this way, I can do the average only in ...
2
votes
1answer
46 views

Run script when clicked on picture in published Google spreadsheet?

I used the script underneath in Google Spreadsheet and added an image that when clicked upon runs the GOTOSHEETONE function to navigate to sheet: SHEETONE. So far so good. However, when I publish my ...
1
vote
1answer
12 views

Google Spreadsheets function to filter by date and count text strings in certain fields

I'm not very experienced with Google Sheets, but I found a function here on Stack Overflow and modified it a bit to do almost everything I need: =COUNT(FILTER('2014 Form Data'!$A:$A,'2014 Form ...
1
vote
1answer
27 views

How can I use a single column as a normalized data point with multiple choices in Google Sheets?

I find I often want to have a column that is meant to be one or more choices from a fixed set. E.g. a Codebase field in a dev roadmap spreadsheet, which might have choices like {DB, API, JS, CSS, ...
1
vote
2answers
29 views

How to get a Google spreadsheet cell to display a number as 4 digits, even if it's less than that

This is a formatting issue. Basically, I would like to get all the numbers I enter into a column become 4 digits in the other column ("output column"), with 0's in front as applicable. E.g. when I ...