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

learn more… | top users | synonyms (2)

0
votes
0answers
12 views

Google Spreadsheet Time of Edit

I'm currently working on a file with my team. I would need to add a script that returns the following: For a specific column of a specific sheet, when was it edited and by whom into a comment for that ...
3
votes
1answer
20 views

Removing comments completely in Google Spreadsheets

After I've resolved a comment in a Google Spreadsheet, is there a way to delete the whole comment email chain which is currently stored in the comment button on the top right hand side of the ...
1
vote
1answer
25 views

Google Sheets Function to get a shortened URL (from Bit.ly or goo.gl etc.)

I have a Google spreadsheet that builds Google Analytics links. I'd like to shorten those links. I tried the Bit.ly example but even their example does not work. How can I do this?
1
vote
1answer
16 views

How to add line breaks in a cell before specific keywords in Google Sheets

I'm new to Google Sheets and I was wondering how to tell GS to insert line breaks in a cell with text if there are some one or two letter before the text. For instance, I have a cell like this: I ...
0
votes
0answers
9 views

Auto Sum Question

On Google Sheets, I enter my sales for the month in Column F. How can I get column F to Auto Sum so that the total always appears below the bottom entry?
0
votes
1answer
10 views

Dynamic Values in a formula?

I have a google sheet where I am using this query to pull data from another sheet : =QUERY(IMPORTRANGE("SHEETLOCATION","Master Customer!A1:u10000"),"Select Col3 Where (Col18='Survey Complete' and ...
1
vote
1answer
18 views

Change an input value in a cell to another value depending on what the input was

What I would like to do is change a number input in the rating column (G3:G9001) to the corresponding number of stars (from 1-10). Howerver I could not figure out how to do this. As a test I tried to ...
2
votes
0answers
20 views

Google Spreadsheet adding new lines in between

I've encountered an issue with Google spreadsheet. When I'm trying to add some text, I'm noticing a new line being added in between. Is anyone else having the similar issue?
0
votes
0answers
6 views

How to make Sheets recognize worksheet tab colors from imported Excel workbook

I have some workbooks I'd like to upload to Sheets. Pretty much everything, from formatting to filters, makes it over reasonably well from Excel to Sheets except for one glaring exception: worksheet ...
1
vote
1answer
25 views

How to count specific items in column?

I just started using Google Spreadsheets. I have a question concerning "counting" a specific word/item in cells. Example: Column A 1. HAT 2. HAT 3. SHOE 4. CANE 5. SHOE 6. HAT 7. - 8. - ...
0
votes
0answers
7 views

Google Spreadsheet - Create a function to copy range (values only) to a new tab at specified intervals

Looking to find a function that can copy the values only from a range I am importing from the web at a certain time. Have found a lot of functions that are similar to what I need but can't nail one ...
0
votes
1answer
24 views

Applying formula to lookup value in array of cells in Google Form Responses

I have a Google Form response sheet, part of which contains several columns (say B:G) that will only have a single value between them. The form asks respondents for their county of residence and then ...
1
vote
1answer
23 views

Filter rows by one unique column of sorted values in Google spreadsheets

I need an equation that filters by unique ID, using only the latest row (most recent row in time), and data found in that row. I have data that is in the following format: ID | Price | Area | ...
1
vote
1answer
51 views

Delete second row in a cell in Google Spreadsheet

In order to create some list, I've been copy some data from the web. Unfortunately it looks like it has been added second row for each record it need. For example: Each record is in the same ...
0
votes
1answer
18 views

Calculate difference between numbers in 2 columns row-by-row in a spreadsheet

I have 3 columns in a Google Docs spreadsheet: A) Inventory purchased price, B) Inventory sold price, C) Difference between A and B (i.e. profit or loss) Data is going to be entered manually into ...
1
vote
0answers
12 views

How to merge multiple spreadsheet content having the list of keys to them?

Input: column of Google keys for spreadsheet that contains tables with some data, eg: date | refNum | Name | Description Require: a sheet that will contain a merged table with data from ...
0
votes
0answers
24 views

Auto-update Google Client Sheet when Master Sheet is update

I have a Google Spreadsheet (Master Sheet) which pulls in data from Gravity Forms entries via Zapier. Within this spreadsheet there are 5 different worksheets. The main worksheet which contains all ...
0
votes
1answer
13 views

What's causing / how to get rid of long web calls in Google Spreadsheets

I have a google spreadsheet that's running into performance problems. It will make really long calls and occasionally freezes up the UI. Here's an example of the type of call that's being made ...
0
votes
0answers
5 views

How to plot a graph with random time intervals in Google Spread Sheets?

I want to create a line chart using a hours of the day on the Y axis. My data appears at random time intervals, eg: 9:00, 9:35, 10:35, 10:50, 11:30, Is there a way I can incorporate this into a ...
1
vote
0answers
9 views

Representing hierarchical data in Google spreadhsheet

Background Smartsheet.com allows hierarchical representation of data in a single sheet {without having to use adjacency lists } smartsheet hierarchical data example Question Do google ...
2
votes
3answers
69 views

Google Spreadsheet: If value of cell equals X, get value of adjacent cell, then add to totals

I have a budgeting spreadsheet, with separate spending categories, and I want to SUM all spending entries based on the category selected. I'm not technical, but here's an explanation of what I'm ...
1
vote
0answers
17 views

In Google Sheets, how do I find elements common to two ranges? [duplicate]

Range 1 cat dog rat bat snake Range 2 cougar butterfly rat bat lizard aardvark kangaroo What formula or script would I use to get Range 3 rat bat Order is not important.
2
votes
1answer
21 views

Give a name to a cell in Google Sheets

Excel has a little box on the upper left corner that displays the name of the cell (for example "A8", "C20", "BC104", ...) and this name can be changed to a string of choice (like "Force", "mass", ...
1
vote
1answer
10 views

Searching through sheets

I need to search multiple sheets like this for certain words like #work and #hobbies and add up the numbers on the adjacent column. ...
1
vote
1answer
26 views

Decimal conversion of time values

What is or can it be done to add 2 cells, that return a time equation? I deal with multiple time entries and having to enter them in a standard format of 4:45 hours or 4:25 hours. I have a decimal ...
1
vote
2answers
39 views

Average two numbers IF the second number exists

I have 2 columns (Google sheets) of numbers similar to: 10.453 12.178 12.654 0 The third column is: if number higher than 0 exists in both columns, display an average of the two else just ...
1
vote
2answers
20 views

Selecting the Max (or MIN) value in a field from only those rows that match criteria in another sheet

I've been looking through the online help, but haven't been able to find the function or functions I need to accomplish the following. I have 1 Google Spreadsheet with 2 Tabs. The 1st tab is a ...
0
votes
0answers
36 views

Google Sheets: Error- Array result was not expanded

For cell J129 I'm using the following formula =index(B122:122,1,counta(B122:122)), but I keep getting an Error that says, "Array result was not expanded because it would overwrite data in K129." I'm ...
0
votes
0answers
9 views

Conditional deleting in Google Spreadsheets

I'm using two sheets, one with the main values and reference datas. The second sheet is for price calculation. I use =Filter to get the values from sheet one where Sheet1!E2:E <> 1. How can I ...
3
votes
1answer
39 views

Is there an “increment” shortcut in Google Sheets?

Is there an easy way to auto increment integer value in a Google Sheet like Ctrl+A in vim? If not, how do I go about creating such a shortcut?
1
vote
0answers
8 views

freeze column according to column heading

I am working on attendance in Google spreadsheet, I want to protect the date column which is past date and future date, I just want to give edit right only for today date.
0
votes
0answers
27 views

How can I make Google Spreadsheet recognize dd/mm/yyyy format as a date?

I have a table copied over from other applications to a google spreadsheet. Before processing, I noticed google spreadsheet doesn't recognize 'dd/mm/yyyy' (e.g. 15/01/2015) as a date, instead it treat ...
1
vote
1answer
40 views

Google sheets: conditionally change sign of decimal value in cell for each row

Here's a preview of the spreadsheet I'm editing in Google Drive: The transaction type cell has a value of "debit" if the row is for an expense, and "credit" if it is income. I would like a script ...
0
votes
0answers
17 views

Formulas mix up references when sorting data in Google Spreadsheet

I have a Google Spreadsheet that has formulas embedded into various cells. When I sort the data, the formulas always get messed up, and no longer pull data from the proper reference cells. How do I ...
1
vote
0answers
21 views

Retrieve row data based on indirect Max function value

This spreadsheet tracks live song ratings for a popular band. Users input their score in their own column and those scores are averaged into a community score (Column E). Those song averages are ...
3
votes
1answer
39 views

Where does the calculation take place?

In Google Spreadsheets, I have quite a big amount of relatively complex array formulas in many cells. That takes ages to complete calculating. Does the speed of calculation depend on my PC ...
1
vote
2answers
32 views

Google Spreadsheet: Count column if criteria is met in the respective column and another column

Is there a way to COUNT the cells in column A if the cell in column A equals "X" and the adjacent cell in column B equals "January"?
2
votes
1answer
51 views

Return transposed list of all strings in a row in Google Sheets

In my Google Sheet, the range B2:2 contains mostly empty cells, but some cells contain strings. I would like to print these strings into a transposed list beginning at A12. This list should exclude ...
1
vote
1answer
31 views

Google Sheets: average cells in Row 4 up to last filled cell in Row 2

Is it possible to write a Formula in Google Sheets which calculates the average of the cells in Row 4 but only up to the last filled cell in Row 2?
-1
votes
2answers
30 views

Sum rows of a array function that outputs a matrix [Google Spreadsheet]

I got a arrayfunction that is returning a matrix. I want to edit this to only return a vector, where this vector contains the sum of each row. I tried applying sum(), but that summed every element of ...
1
vote
1answer
33 views

Google Spreadsheet Query for unique and “most recent”

Given a Google spreadsheet like this: I would like to create a query that shows only the most recent row for each unique name, so the results would look like this: What would that query look ...
1
vote
1answer
38 views

How do I use a dropdown menu in a cell to populate other cells with information?

I'm trying to build a spreadsheet that allows a user to select a product in a dropdown menu in the first cell and then based on what is selected it will populate the spreadsheet with prices and ...
0
votes
1answer
17 views

how to make columns not affect other columns within the same row in google spreadsheet

I have done an schedule in google excel(google spreadsheet). I set text wrapping to wrap. The problem is that when i write something in column A and the row in column A gets expanded to fit all text ...
2
votes
0answers
8 views

Google Spreadsheet limit ArrayFormula

I'm using ArrayFormula to calculate multiple ranges and its slow because its trying to calculate everything in that range even though it has nothing in it. Is there a way i can limit the ArrayFormula ...
1
vote
0answers
16 views

Can you restrict Google Sheet to editing just text with restrictions on formatting?

I simply do not want people who edit the sheet to mess up the formatting. I'm sharing a file with well over fifty people, and if someone messes up the document, it'll probably set off a chain. How ...
0
votes
0answers
13 views

How can I check emails against a Google sheet containing a list of email addresses?

I am conducting a research study and receive many emails (via Gmail) from potential participants. I do an eligibility screen with participants over the phone, and if they are not eligible, I add their ...
-1
votes
0answers
8 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
0
votes
3answers
13 views

Update formula ranges when adding new rows to a spreadsheet

I have a Google Spreadsheet in which I keep a list of expenses. I add a new expense by inserting a new row above the last expense. On the first row of the spreadsheet, I keep a sum of all expenses: ...
-1
votes
1answer
16 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
vote
0answers
38 views

How to add a line break in a custom date format in Google Spreadsheets?

Google Spreadsheets give us a tool to create and use a customized data format for date values. While the tool allows us to use arbitrary characters, like slashes and commas between the date fields ...