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

learn more… | top users | synonyms (2)

3
votes
2answers
79 views

How to limit the length of data in a cell in Google Sheets?

Is it possible to put a limit to the length of cell content while entering data into a cell using Google Apps Script or any other way?
1
vote
2answers
24 views

Show number in a cell - based on a value from another cell

I need help with the question on the picture. Can anyone make a formula for me? Thanks
0
votes
0answers
17 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
28 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
228 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
44 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 ...
1
vote
1answer
29 views

Autosum entire column

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?
1
vote
1answer
29 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
40 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 ...
1
vote
0answers
46 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
38 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
36 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. - ...
1
vote
1answer
41 views

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
54 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
35 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
63 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 ...
1
vote
1answer
88 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 ...
3
votes
1answer
39 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
54 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
14 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
20 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
19 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 ...
3
votes
3answers
401 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
18 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
33 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
22 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
52 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
44 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 ...
3
votes
2answers
52 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
24 views

Send to respondents a number between 1 and 10 using Google Forms?

My idea is to give to respondents by mail a number reference between 1 and 10. The idea works as follows: You have 10 boxes. When a response is submitted, automatically the form will send a email ...
0
votes
0answers
141 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
24 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 ...
4
votes
1answer
72 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
9 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
69 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
49 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
42 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
28 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
65 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
79 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"?
4
votes
1answer
66 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
45 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
115 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
65 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
129 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 ...
2
votes
1answer
38 views

Make cell height in one column not affect other columns within the same row in Google Spreadsheets

I have done a schedule in 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 all other ...
2
votes
1answer
40 views

Google Spreadsheet limit ArrayFormula

I'm using the ArrayFormula to calculate multiple ranges and it's slow because it's trying to calculate everything in that range, even though it has nothing in it. Is there a way I can limit the ...
1
vote
1answer
25 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 ...
1
vote
0answers
20 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 ...
0
votes
3answers
36 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: ...