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

learn more… | top users | synonyms (2)

2
votes
1answer
26 views

Adding an overtime column to a Google Sheets template that includes the overtime rate in the total

I would like to use this template to log bi-weekly hours. It is almost perfect except that there is no column for overtime hours. How would I add an overtime hours logging column that would add the ...
2
votes
1answer
21 views

How to work out the price of shipping an item in Google Spreadsheets

I'm currently trying to build a formula to work out a problem I have. What is the problem: Right now before I can send an item out, I need to work out how much that will cost me. This is done by ...
0
votes
1answer
98 views

Google Form keeps changing Spreadsheet cell entry

I seem to be having a bit of a problem, I'm using Google Spreadsheet and have created a form that people would be able to fill in online. It sends that data to a sheet called 'Raw Entry Form', I then ...
2
votes
2answers
60 views

Find and replace text in Google spreadsheet

I have a string of data in one cell: "Membership and Volunteer Crew - do you like getting to know lots of new people? | Sauna Crew - Spend time sweating and supervising our sauna activity. | ...
1
vote
1answer
29 views

Complex Sum Function in Google Sheets

Apologies if this is lame, but I can't get a proper value using =SUM to perform order of operations on an employees hours (he has gotten two raises since starting after surpassing expectations). The ...
1
vote
0answers
78 views

For every occurence of x insert a new row beneath it

I'm using XPath in Google Spreadsheets. In some of my cells I receive fetched results, in others I get #REF!. The explanation given is Array result was not expanded because it would overwrite ...
1
vote
2answers
66 views

How to insert empty rows under all (already occupied) rows simultaneously in Google Spreadsheets

How do I insert empty rows under all (already occupied) rows simultaneously in Google Spreadsheets? Lets say in row 1 it says "A" and in row 2 it says "B", "C" in row 3, etc. I would like it to say ...
1
vote
1answer
85 views

Combine image and text in Google Spreadsheet

In Google Spreadsheets it is possible to show an image in a cell using the formula =image('http://www.example.com/path/to/image.ext', 3) (where 3 means to use the images' original size). I would like ...
2
votes
1answer
21 views

Calling a date with =concatenate is resolving to strange number

Using: =concatenate("Review Check on ", B2) B2 is "4/20/2015", that I created using the date insert shortcut (command+; on Mac). The final cell resolves to "Review Check on 42114"—the “/”s have been ...
1
vote
2answers
90 views

Google Query For Dates in Last 30 Days

I'm trying to figure out how to do a google query for dates in the last 30 days. I'm using a wordpress plugin that lets you display spreadsheet data and do queries. Here is the current working query ...
3
votes
1answer
63 views

Conditional formatting based on another cell

I use Google Sheets to schedule office appointments. I have set conditional formatting so that if the appointment time slot cells are empty, they are highlighted yellow. (This makes it easier to find ...
1
vote
1answer
32 views

In a google spreadsheet, how can I delete all rows containing given text that could be in any column within the row?

I'd like to be able to delete all rows in a google spreadsheet where a given text string exists anywhere in the row. The text being searched for could be in any cell in the row, and also could be part ...
3
votes
2answers
117 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
26 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
18 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
30 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
401 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
64 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
33 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
42 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
47 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
45 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
38 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
48 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
61 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
41 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
64 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
111 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
43 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
62 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
22 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
21 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
537 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.
3
votes
1answer
37 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
69 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
46 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
59 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
25 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
168 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
29 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
83 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.
1
vote
0answers
82 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
50 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
47 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
29 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 ...