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

learn more… | top users | synonyms (1)

1
vote
1answer
43 views

“Go to” search in google spreadsheet

I want to have a search feature at the top of my spreadsheet that will actually take me to a row, on the same sheet, based on searching a column for the matching information. So, I want any user to ...
1
vote
2answers
215 views

How can I make a Google spreadsheet Function reference one column's value and adjust it to a different Value?

I am trying to create a spreadsheet that will calculate varying sizes. I need it to reference a key where a letter is an established size such as H=1984, S=672, etc. so as that that column can be ...
2
votes
1answer
15 views

SUM a column of values that whenever a cell is empty gets it from a default column

I am trying to sum a column of values but whenever a cell is empty then it sums the value from a default column. Example: +---------+---------+---------+---------+ | Default | A | B | ...
1
vote
1answer
38 views

Group by and ordering inside a group in Google Spreadsheets

I have the following data in a Google Spreadsheet: 1 shiplu rice 2 sharmin rice 3 sharmin fast food 4 sharmin salad 5 rafiq burger 6 nazia noodles 7 rafiq salad 8 rafiq ...
1
vote
1answer
88 views

Custom Actions in Google Drive Spreadsheet

I find that I often change specific cells from black on white to white on black when I'm making spreadsheets. It get's tedious to change the background color, then the foreground color over and over ...
0
votes
1answer
48 views

Merging spreadsheets

I have three Google spreadsheets that I want to merge into a master spreadsheet, so that each new entry in any one of the three spreadsheets will automatically update the master. How can I do that ...
3
votes
1answer
222 views

How to lock a cell based on date in Google Spreadsheets

I have set up a simple spreadsheet with cells containing a drop down list of Yes and No. I want to lock these cells based on date, so that all the people who I am sharing the sheet with will not be ...
1
vote
2answers
1k views

Can I copy row from one Google Spreadsheet to another based on certain criteria

I have a spreadsheet to track student loan outs: Column A is the student name Column B is how many loan outs they have received Column C is the class period Column D is the teacher name ...
1
vote
1answer
113 views

onEdit only updates top row after pasting (editing) multiple rows

I'm using a Google Spreadsheet and have a script that updates the "last email" column with a date stamp when an employee enters an email address into the prior column. The problem occurs when my ...
2
votes
0answers
23 views

Can I fill specific cells in my spreadsheet when submitting a Google Form?

I have a Google Spreadsheet that contains a list of dates, and empty cells. For a variety of reasons, I'd like to be able to have people add fill out a Google Form where they select a date, and fill ...
0
votes
1answer
187 views

Google spreadsheet multiple auto-sorting

In a Google Spreadsheet I have different group of cells to auto-sort ascending i.e. table range a3:c16 columntosortby = 2 table range d18:f31 columntosortby = 5 table range g33:i46 columntosortby = ...
1
vote
1answer
805 views

How can I group a pivot table into weeks or months?

In Microsoft Excel, in a pivot table, you can right click on the dates - while within the pivot table, on a date and select group (from the drop down menu) - then you can choose different groupings, ...
0
votes
2answers
65 views

Count word occurrences in survey feedback

I have a suggestions column in a survey feedback, that's being pushed from the survey provider to a Google Spreadsheet. I'm trying to do a bit of wording analysis on it. For example, I'm trying to ...
2
votes
3answers
1k views

Google Docs - a formula that does Excel “countifs” function involving dates

I have a Google spreadsheet in which multiple users are tracking a list of dates and class names (math, reading, writing, etc). On a separate sheet in the same document, I want to be able to give a ...
1
vote
1answer
793 views

Paste format only in Google Spreadsheets with Chrome as the browser

I want a working keyboard shortcut for Google Spreadsheets, that lets me paste just the formatting. Google says the shortcut for copying just the formatting is Cmd+Alt+C, and pasting just the ...
2
votes
1answer
598 views

If cell equals a value then move row to different Google Spreadsheet

I've got a script that sorts a Google Spreadsheet when a value in a column is changed. I'd like to add to the script the following functionality: If the value for column E = "Complete" then the ...
3
votes
2answers
545 views

Partial sum of columns based on row identifier

I have a spreadsheet with list of persons ("players"), and for a each person I have following values: ID number (unique) Name (just text) Score from round 1 Score from round 2 ... Score from round ...
0
votes
1answer
70 views

google spreadsheet filter, string equivalent

Columns D, E, and F store names that represent 2-3 person teams assigned to the name in column A. The teams are assigned to multiple names and thus appear in multiple rows. The teams' composition ...
0
votes
1answer
13 views

Google-speadsheet data validation to restrict to Mondays only

I have a field in Google Sheets I labeled "Week of". I want to restrict user input to a date (mm/dd/yyyy) which is a Monday. I can set "Data validation" -> "criteria" to "Date" but how do I limit it ...
1
vote
1answer
86 views

Date Formatting for Deadlines

I have set up a Google spreadsheet for managing projects and due dates, and I need to apply the following formatting to a column of dates, but I'm not sure how: Dates more than 7 days from today: ...
2
votes
1answer
102 views

Applying IF Statement to entire column

I currently have an IF statement that checks a cell in column B if it is blank. If it is blank it returns No in the corresponding A cell. If it does have a string, it returns Yes. I currently have ...
-1
votes
1answer
62 views

Track/compare my inventory with my supplier [on hold]

I'm trying to use Google Spreadsheets to track/compare my inventory with my supplier, but I'm having some issues. I'm able to download an up to the minute inventory log form my vendor, but I can't ...
1
vote
1answer
88 views

How to make a protected range appear normal in Google spreadsheets

I have a project in Google spreadsheets shared with several other users. There are sensitive formulas throughout that I have protected to prevent accidental deletion or overwrite by the other users. ...
1
vote
2answers
40 views

query all dates within the date range

I have a Google Spreadsheet that I'm querying and the date is set as dd/mm/yyyy. How can I query between the start and finish (ref cells) of each month, so the query only returns dates between the ...
1
vote
1answer
17 views

How can I sum a row in Google Spreadsheet so that the formula isn't overwritten when Google Forms adds a new row?

I'm using Google Forms to collect some data from students. Each time a new student submits a form, the data (4 columns worth) is added to a new row in a Google Spreadsheets, bumping anything ...
0
votes
1answer
205 views

Question about a Google Spreadsheet function (I don't even think of how to describe it in the title)

Pretty much what I'm trying to accomplish is the following: Cell F1 is a drop down menu. If F1 contains the words "whatever", then look up the word in A2 on sheet 2, and input the data in 3rd ...
0
votes
1answer
505 views

Query multiple Google spreadsheets

I have the following sheets: ListA ListB ListC Note: at each sheet I have a column which contains YES or NO. How do I query all my lists (spreadsheets) where myBooleanColumn equals to YES/NO?
1
vote
1answer
29 views

How to parse a date and time in the format 2012-12-12T00:00:00+00:00?

I have a CSV file with dates in the following format: 2012-06-20T00:00:00+00:00 Is it possible to parse a date or date and time in this format? The goal is to turn it into a date and time that ...
1
vote
1answer
85 views

Counting number of cells with certain word if another cell in that row is not blank - Google Sheets

I have 2 columns, machine type and install date. What I want to do is count the number of machines per type once they are installed. So if there were 3 "Machinetype1" installed 11/29/13, I want ...
0
votes
1answer
83 views

Google Spreadsheets: Create a master sheet for formatting

I have a sheet for each month's personal expenses with a chart and all. I am still changing formatting and have to change everything for every sheet individually. What I would like to have is: An ...
-1
votes
1answer
76 views

Google Spreadsheet: add automatically the same formula in each new row of a column. Also with “SUM”

I have this sheet: https://docs.google.com/spreadsheets/d/10YVUO2a-XftaCOX73tOiOwQfu0t80iKPJjQrRDiht1A/edit?usp=sharing In the column "E" I need the same operation as ARRAYFORMULA in column C and D. ...
0
votes
1answer
153 views

Google Spreadsheets (Query) - Conditional Formula

We're trying to create a query based off whether or not specific "Categories" have been selected. Here's an example of the categories they would select: Channels Arts & Entertainment ...
2
votes
1answer
54 views

Google Spreadsheets: Identifying and Working with Any Cells that Match

I am trying to find a function, or a series of functions, that allow me to (1) Identify if any cell in column A matches any other cell in column A, (2) add numbers in Column B that occupy the same ...
0
votes
1answer
25 views

Script that adds new row to multiple sheets in Google Spreadsheets

I want to add a script in Google Spreadsheets that adds new row on the second line of every sheet within a Google Spreadsheet that contains multiple spreadsheets. This will need to happen every day.
0
votes
1answer
55 views

Have a range refer to a given row even if the row number changes?

I have a table like so: A | B ------------------ 1 || Name | Age 2 || joe | 28 3 || bob | 14 4 || Size | Weight 5 || small| 150 And I have a formula to sort each section by column B: ...
10
votes
6answers
17k views

Google Docs Time report - How to add hours?

I use a Google Docs spreadsheet to keep track of the time I spend on projects. It's formatted in 3 columns: the time I started, the time I finished, and the total hours spent for that session ...
0
votes
1answer
71 views

Google Spreadsheets Validation list with Label

Thanks in advance. I have just started using Google Spreadsheets so am very new to it's ways! So far it looks incredibly powerful! I am using some data in a sheet called Jobs as a reference to ...
1
vote
1answer
35 views

Preventing Paste Overwriting Cell Formatting in Google Sheets

I have a spreadsheet used for booking employees onto training sessions. It's very simple to use; the person booking simply enters their employee number into column A and column B, C & D ...
1
vote
1answer
37 views

Start new line automatically when otherwise content would overflow cell [duplicate]

I don't know when Google changed the version of Spreadsheets. Right now when the cell's text is longer than the cell width the display of this line is no longer what it used to be. I want the display ...
1
vote
3answers
37 views

How to handle Negative Time Delta in Google Spreadsheets

If I have two cells, one is the starting time and one is the ending time. How do I calculate the time difference if the end time is in the next day? = B1 - A1 gives a negative time. =IF(B1-A1, ...
2
votes
2answers
44 views

How can I get Google Sheets to treat my form-submitted strings as plain text and preserve leading zeros?

I have Google Forms where users enter information, some of which contains leading zeros (e.g. zip codes, ID numbers). However, when this data is saved to the Google Sheet, it doesn't treat it as ...
-1
votes
1answer
23 views

How can I calculate compound interest with different interest rates?

Assume that I have the following different interest rates for different periods. I would like to calculate a compound interest rate based on these rates for lets say 200 periods. How can I do it ...
0
votes
1answer
25 views

Google Spreadsheet changing cell references on its own

I have created a Google Form with an attached spreadsheet. Within that spreadsheet I have created several sheets to sort the answers to my liking. Sheet 2 is just an exact copy of all the original ...
3
votes
2answers
57 views

Scan row for value, get column of that match, apply column in another formula in a different cell

+------+--------------+--------------+--------------+--------------+--------------+ | | A | B | C | D | E | ...
1
vote
1answer
99 views

Google Spreadsheet SUMIF Using Two Criteria

I've read through the forums but found nothing that solves my problem. My apologies if the answer is here somewhere and I've missed it. I have a Google spreadsheet with multiple pages, each tracking ...
1
vote
1answer
844 views

Creating duplicate Google spreadsheets that filter data from a master sheet and update rows on master sheet

Basically, I have a huge list of data on Google Docs spreadsheets, and a bunch of people that read it. They are not tech savvy. I am trying to create duplicate sheets on a Google spreadsheet that are ...
0
votes
1answer
811 views

Script error trying to populate form drop down menu from spreadsheet

We are trying to link a list on a Google Spreadsheet to a drop down menu on a Google Form. The twist is that this Google Spreadsheet list will be continuously updated and needs to automatically ...
0
votes
4answers
36 views

How can I append a string to a formula result?

How can I include the result of an equation followed by a piece of information in quotes? For instance if I had the code add numbers from three cells, and wanted to include the result followed by lbs ...
2
votes
1answer
3k views

Create a function for an entire column in Google Spreadsheets

I'd like to set a function for an entire column in Google Spreadsheets, and I'd like for that function to get applied whenever I add new rows to the spreadsheet. I know that I can set a function for ...
0
votes
2answers
563 views

Show data from one sheet on another if date is today

I have a list of people responsible for data verification that are changing every day. The schedule is on one sheet. And data verification is on another. What I need is to show only responsible ...