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

learn more… | top users | synonyms (1)

0
votes
0answers
8 views

Return an adjacent cell for each match of a string

I have a row of cells like this: | Name1 | String | | Name2 | | | Name3 | String | | Name4 | String | | etc. | ... | I would like to return all of the Name values if the cell adjacent to ...
1
vote
1answer
9 views

Google Spreadsheet: Get domain from email address (bob@example.com -> example.com)

In Google Spreadsheet, how to get the domain part from an email address? Example: bob@example.com -> example.com
2
votes
1answer
24 views

Create a public spreadsheet which requires users click the “edit” button to mutate it?

How do I customize a public Google Spreadsheet like this? It needs users to click the "Edit" button so that they can edit:
1
vote
1answer
29 views

COUNTIF in Google Sheets that checks 'if' a string is in one column before counting in another column

I'm trying to use the COUNTIF function in Google Sheets. The Goal I want the 'dashboard' sheet to display the count of items in column F submitted to the responses sheet 'if' a specific string ...
1
vote
0answers
36 views

Batch Hiding Function in Google Script

I wrote a function that iterates through every non-blank row in the sheet, checks the value of a certain cell, and then if that cell matches my criteria its row number is added to an array. I then ...
3
votes
1answer
17 views

Conditional Formatting: Minimum Value in Row

The goal Apply conditional formatting to the minimum value in a row of a Google Spreadsheet. What I've tried Under Conditional Formatting, using "Custom Formula Is" =MIN(D3:L3). The result ...
2
votes
1answer
23 views

Complex Formula in Google Spreadsheet

I have a 'dashboard' sheet and a 'log' sheet. I'm trying to pull data from the 'log' sheet and perform calculations on the data before displaying it in the 'dashboard' sheet. The 'log' sheet will have ...
0
votes
1answer
23 views

Filter a full table based on only unique values in a single column

How can I deduplicate a table (all rows and columns) based on the values in Column A? Example: What I want after deduplicating: Basically, I only want unique values in column A, but I want all ...
1
vote
1answer
30 views

Filter columns in Google Spreadsheets based on fill colour

I've got a long list of items that I need to check. I use a traffic light system to track where I change the cell colour of the cells in the progress column: red = haven't done yellow = in progress ...
-1
votes
0answers
38 views

Default date and value in Google Spreadsheets [duplicate]

I would like a column (Column B) to automatically add the current date when a new row is created. Also, I would like Column C of a new row to default to the value from the previous row (or the last ...
3
votes
1answer
31 views

Update Random value only on page refresh

I am using =RANDBETWEEN(1,100)function to generate a two digit random integer. But I want these values to refresh only on the page refresh, whereas currently they are changing whenever any cell is ...
3
votes
0answers
15 views

Automatically adjust corresponding cells when using “=query”

I just learned how to use the =query function in Google Sheets, pulling information from one sheet to the next when a specific condition is met. =query('Sheet1'!A:Z, "select B, D, E, F, G, I, L where ...
1
vote
1answer
18 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 ...
3
votes
1answer
36 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
0answers
19 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
16 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
47 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.
0
votes
1answer
40 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
35 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?
0
votes
1answer
55 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 ...
-1
votes
0answers
24 views

Google Script “Range Not Found” while Sum Color background

I am trying to use Google Scripts to create sums based on cells' color backgrounds. The script I am using is function getBackgroundColor(rangeSpecification) { var sheet = ...
0
votes
1answer
21 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
23 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
66 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
38 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
42 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
28 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
24 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
15 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
31 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 ...
1
vote
0answers
34 views

How do I open the Google Drive folder of the file I am editing?

It used to be that if I clicked the white icon with the colored background in the top-left, it would take me to my folder on Google Drive. Now it takes me to these worthless links: ...
0
votes
1answer
52 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
39 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
14 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
19 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
17 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
37 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
63 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
35 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 ...
2
votes
1answer
52 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
20 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
31 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
19 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
46 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
35 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
67 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
116 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
67 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
32 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 ...