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

learn more… | top users | synonyms (1)

1
vote
1answer
32 views

How to get more than 1 question to populate the same field/column in the Spreadsheet?

I am looking for some way to get the submitted answers to 2 or more questions to populate in the same column in the response spreadsheet, but on the next row. e.g. When gathering data from ...
4
votes
1answer
49 views

How to get the +1's of a website?

I've a spreadsheet with a lot of contact information. In order to sort the data, I want to rank them according to the +1's given on their website. Is it possible to get the +1 count of a website ...
2
votes
1answer
38 views

How to make Google Spreadsheet editable only at certain times

I need to create a document (something like a Google Spreadsheet) where multiple users could insert their names in, but within a limited time span. They could edit the document only from Monday (8pm) ...
1
vote
0answers
32 views

How to prevent user from downloading my Google Sheets

I have made a few useful spreadsheets for my company. I want to put them on Google Sheets, so my colleagues can use it online to make inputs and get results. But I do not want them to know the ...
1
vote
2answers
50 views

Show cell value on click

I have a formula in a cell to calculate a value. But I want the value to be shown only when the user clicks on the cell. I looked around but there seems to be nothing by default.
1
vote
1answer
50 views

Circular Dependency Error, Blank when 0

I have tried both of these in Google Spreadsheets and continue to get circular dependency errors. I am trying to show blank when the result is 0. New values are entered daily and want to have the ...
0
votes
1answer
48 views

How to turn cell yellow if date in cell is between 180 and 365 days in the past

In Google Spreadsheets how do I use conditional formatting to turn a cell yellow if the date is between 180 and 365 days in the past?
1
vote
1answer
70 views

A more complicated Countif (Google docs)

I have a simple countif:= Countif(A1:A5,"statement"). And I want it to count the statement n times if it appears n times in my cell A1 (plus of course the number of times it appears on the other ...
0
votes
1answer
26 views

Auto Insert Address on adjacent cell

I am trying to create a spreadsheet which enters address automatically on adjacent cell when I type in the company name. The script will be as I type in company name in cell A1, it will search for ...
1
vote
2answers
30 views

Lock formulas in Google Spreadsheets

I'm creating a table for a friend to input information but he is not very good at computers. I had him work on a table in Excel and locked the page and this worked great but now I want to check his ...
0
votes
1answer
541 views

Error: Circular dependency detected

I am very beginner to google scripting. Here I need to count the number of times the word "FREE" occurred in my sheet. But my function Returns me an error "Error: Circular dependency detected" Please ...
0
votes
1answer
95 views

Copy cell from cell to another sheet if row contains x

I'm new to sheets, I have a sheet with 10 pages. I need to auto fill sheet Report if sheet David contains "1" in column "i". I need to copy cells C14 - C34, J14 - J34 and L14 - L34 only if there is ...
0
votes
1answer
57 views

Wildcard in Google spreadsheet

How do I convert the following formula to do wildcard for "Florida"? =Sumproduct((Sheet1!B:B="Florida"),Sheet1!A:A) Ideally, I like the formula to do this: ...
1
vote
1answer
33 views

How to lock formula when adding column in Google Spreadsheets

I’m trying to keep an average of the 5 newest values of a data set: Average($d$1:$h$1). If I add a new column to the left of D for new data, the formula changes to ($e$1:$i$1). How do I prevent the ...
1
vote
1answer
26 views

Lookup using a key from a dropdown cell

I have a dropdown that selects from several text "keys," like so: List of items: Pathetic,Untrained,Novice,Adept,Master,Amazing I'm trying to use these keys to run a lookup on a separate sheet, with ...
1
vote
1answer
16 views

List all records with certain criteria

Help. I just cannot get this going even after 2 hours of searching Google. I have a Google Spreadsheet that has a "List" sheet and an "Outstanding" sheet. I want to see what's outstanding from a ...
2
votes
1answer
38 views

Problem with SUBSTITUTE function in Google Spreadsheets

I'm having problems using the SUBSTITUTE function as part of a formula. On it's own, SUBSTITUTE returns the desired output (i.e. in cell O3), but when combined in a formula, 0 is outputted (i.e. cell ...
0
votes
1answer
70 views

Import a CSV file to Google Spreadsheets

I am trying to upload a CSV file and importing it to Google Spreadsheets. The file contains the following: hi,hello\r\nwelcome,to\r\npeaceful,world What I expect in the Google spreadsheet is: ...
0
votes
2answers
46 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
29 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
vote
1answer
24 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 ...
3
votes
1answer
77 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
91 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 ...
2
votes
1answer
64 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 ...
2
votes
0answers
31 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
46 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
1answer
62 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, ...
4
votes
2answers
69 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
79 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
129 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
82 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 ...
0
votes
0answers
43 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?
2
votes
1answer
33 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, ...
2
votes
1answer
53 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
114 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
38 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
8 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
49 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
74 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 ...
1
vote
0answers
16 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
60 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
16 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
43 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
73 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
77 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
vote
0answers
39 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
31 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
87 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
108 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 ...