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

learn more… | top users | synonyms (1)

2
votes
0answers
16 views

How to avoid selecting a cell address when using the arrow keys while editing a cell

Sometimes, while editing the contents of a cell, using the arrow keys will not move the cursor but instead inserts the address to an adjacent cell. Here is an example of this problem with a ...
2
votes
1answer
134 views

Updating logging sheet from another sheet doesn't work after inserting code offset

I am trying to log the data, formulas and times of cell edits from one sheet into a logging sheet. The problem I am having is that it only seems to record changes made in the logging sheet. This has ...
1
vote
1answer
62 views

Need to Make this Code Sheet Name specific rather then the active sheet

I got this code on here but need to modify it so it only sees 3 sheets. 1 is Active Tickets. 2 is Closed Tickets. 3 is Pipeline. This is the code i currently have: function onEdit(event) { ...
3
votes
1answer
116 views

IF Statements with 3 options

I have 3 possible evaluation values in my spreadsheet (I have to use the values with digits and words): 1.0 - Doesn't meet expectations 2.0 - Meets expectations 3.0 - Exceeds expectations The goal ...
1
vote
0answers
46 views

Need ideas for Google Spreadsheet and Indexing Columns

I have a tough one here. I have a Google form where the employees enter the hours they spent working on particular cases throughout the day. The employees often work on up to for cases a day. So there ...
1
vote
0answers
29 views

Google Spreadsheet notification emails

I have a spreadsheet whereby a user puts in their email address in column A and I populate columns B & C with data. What I would like is for the user in column A to be notified when data is put ...
1
vote
1answer
2k views

Get cell row and column index in Google Spreadsheet

I have spreadsheet with two sheets inside. The name of the first sheet is "fr" and the name of the second sheet "cql". Now the first sheet contains data as the picture given below. And the second ...
2
votes
1answer
55 views

How to capture a cell when entered or selected?

I am trying to capture, programmatically, the on cell entered and on cell selected method, but I don't seem to be able to find any documentation on it. I can get the time stamp for exiting the cell ...
2
votes
2answers
430 views

CONTINUE function is annoying me?

I am trying to pull data from other Google spreadsheets into specific cells on my current sheet by using the IMPORTRANGE function. It's working well in some cells, but it others, it keeps getting the ...
2
votes
2answers
843 views

How to group data by month in Google Spreadsheets

I have a Google spreadsheet which contains various metrics for each day. Each day has it's own row like this: day | cost | impressions | clicks | conversions 2014-02-01 | $45 | 3,540 | ...
0
votes
1answer
76 views

How can I copy all the data from certain colored cells in a Google Spreadsheet to a single cell? [duplicate]

I've only just started using a spreadsheet and I'm wondering how to take all the data from cells of a certain color, then place that data in a single cell?
3
votes
1answer
157 views

How do I output a string containing quotation marks?

I am not super computer literate. I am trying to use the equations to grade my Google quiz, the problem is that there is a quote in the answer. Is there a different symbol I need to use? This is what ...
1
vote
1answer
52 views

Using SUM() and VALUE()

I have a spreadsheet with invoice amounts. Each amount is a link to the given invoice. Can I use sum() and value() (or any other functions) to somehow use the displayed value for sum() (and not the ...
1
vote
2answers
59 views

How can I copy part of a column (text) to another column in other sheet?

I'm trying to figure out how to duplicate part of the content of a column (text) to another column in other sheet. For example, I have column A in Sheet1 and I want to show only a word of this column ...
1
vote
2answers
265 views

Dynamic generation of cell list / array from range value in Google Spreadsheets

I want to create an array/ a list of cells (i don't know the exactly terminology), in rows or columns form, covering the range between 2 numbers Fox example, I have 2 cells, A1 = 3; B1 = 10 I want ...
0
votes
1answer
479 views

How to paste a comma separated string over multiple cells in Google Spreadsheets

Say I have a string of: l,f,x,a,s,f I would want to paste this every comma separated value over 6 adjacent cells. How would I do it?
0
votes
0answers
49 views

How do I allow a user to edit a specific column only?

I have a protected range but I want to do the opposite of its function. I only want a user to be edit that specific range. So, how can I have them "view only" for the whole spreadsheet but edit one ...
3
votes
1answer
590 views

How to export / import a Google Apps Script as a file into a new spreadsheet?

I fear this may have an obvious answer, but I've been knocking my head over this and can't find it! When creating a new spreadsheet, we can easily create a script within it. I like to call it a ...
0
votes
1answer
37 views

How do I combine a string with elements from a SPLITed string?

I have two cells that I want to reference: A category cell (I will call this 1A) A cell with a list of items associated with 1A I want to get the list cell separated out as you would with the ...
2
votes
2answers
74 views

How can I apply a script to every sheet but the first one on a spreadsheet?

I've been working on a shared Google spreadsheet on Google Drive. The document has different sheets with a "Last Modified Date" Cell. I found an script for this to be auto-filled searching here: ...
2
votes
1answer
53 views

Merge column headings into one cell based on a specific value

I am relatively new to Google Spreadsheets. I would like to use spreadsheets to better analyze classroom data. I am trying to write a formula to merge column headings into one cell based on a specific ...
-1
votes
1answer
26 views

Help with formula

this is what I am trying to do and need a formula for column C on the tee sheet
1
vote
1answer
76 views

Pulling most-frequently used names from across Google Spreadsheets and ranking them on a master sheet

I have created a spreadsheet with a "master" sheet and several individual sheets. On each individual sheets, I hope to have each one of my colleagues input names. The master sheet should then be able ...
2
votes
1answer
137 views

Summing Duration Format with QUERY

I want to sum the begin and end with the QUERY function, to be able to subtract them, see table: day | begin | end | -----------------------------------| monday | 9:00:00 | ...
0
votes
1answer
169 views

Google Spreadsheet Formula: Check cell value then subtract based on outcome

I have two columns - they look like the following: YESNO | AMOUNT ________________ N | 13 N | 22 Y | 13 The AMOUNT column is a value output from a condition, ...
-1
votes
1answer
143 views

Help with conditional formatting in Google Spreadsheet

I have a Google Spreadsheet with several sheets. I have it set up to where orders auto populate 3 of these sheets when entered into the Order info page. I need to set up a function where only ...
2
votes
2answers
899 views

Conditional Formatting - Range error

I am using the new Google Spreadsheet application. Here is my data... Cell B3 = 60 Cell B5 = 47 Cell B6 = 52 Cell B7 = 75.1 Cell B8 = 68.4 Cell B9 = 56 I setup this conditional formatting rule... ...
2
votes
1answer
164 views

Referencing cells above and to the left in script

I'm trying to make a script for a custom function in google spreadsheet to work out the hours worked in a day function hwtd(). I've got it perfect in the cell (((F8-E8)+(F9-E9))+(IF((F10<E10), ...
1
vote
1answer
597 views

How does one filter pivot tables by date range in Google Spreadsheets?

I have a Google spreadsheet that keeps track of time spent on graphic design projects. I am trying to run pivot table reports to understand where we can optimize projects. In these pivot tables I ...
0
votes
1answer
245 views

Google Drive Spreadsheets: how to take form responses from one sheet to update the next?

References: Identifier number is the key field which we are wanting to use to link the two sheets together (this will also be referred to as "id") First sheet is the full list of identifiers and ...
3
votes
2answers
151 views

Dividing one column by another

I am rather new to spreadsheets, and I feel like what I want to accomplish is rather simple, but I am having enormous difficulty finding anyone else doing something similar. I have values in column A ...
4
votes
2answers
1k views

How do I parse an integer in a Google Spreadsheet?

What is the equivalent of parseInt() (JS) or intval() (PHP) in Google Spreadsheet? I want to compute the sum of the numbers in a row in a separate cell. So if I had "3 cups" and "5 cups" in a row, I ...
-1
votes
1answer
35 views

How to have charts include added rows in google docs

The problem is, it it's modifying my range selection. In the chart I select ranges Sheet2!A:A, Sheet2!B:B, but after clicking ok, and going back into the chart, it modified my range selection to ...
1
vote
1answer
248 views

Using cell reference with COUNTIFS formula

I am trying to get this formula to work =countifs(J6:J365, "=David & Victor", K6:K365, "=g3") where G3 is a date value (e.g., 02/24/14). I am trying to count the instances in my spreadsheet ...
6
votes
2answers
502 views

Google Sheets: “Split” delimited string, preserving blank entries

I am trying to use the SPLIT and JOIN functions in Google Sheets (the new version) to manipulate some data, and I am running into problems because SPLIT is not preserving blank entries. The data ...
1
vote
0answers
90 views

Way to automate collection of goo.gl data into Google Spreadsheet?

Is there a way to automatically collect analytics data from goo.gl into Google Spreadsheets or Excel? Specifically I am looking to automatically bring the total clicks from my links into a spreadsheet ...
1
vote
1answer
122 views

Make dynamic array blank based on adjacent values in Google Spreadsheets

I'm attempting to indicate certain months that fall between the end of one period and the beginning of another. I have the months of the year in column C: values 1 through 12. It's a running snapshot ...
1
vote
2answers
52 views

How do I cancel editing a cell, in Google Spreadsheets?

I sometimes double-click on a cell to see the formula or whatever, or I just accidentally start typing in the cell. How do I cancel the edits? Esc and Ctrl+Z don't work, so I typically hit Enter and ...
4
votes
1answer
587 views

Can I use column headers in a =QUERY?

Reading the documentation for the =QUERY function1, 2, 3, some of it seems to imply that I should be able to use column headers directly in my query. For example, the =QUERY function takes a third ...
2
votes
2answers
321 views

Google Spreadsheet, put data in a row based on whether a cell has an X in it

I have a list of tutors in a Google Spreadsheet: Sheet 1 Name | Address | Phone | Profile | Subject1 | Subject2 | Subject3 | ... | SubjectN I would like to populate additional sheets with the ...
1
vote
1answer
138 views

Return text from multiple cells on another sheet with linefeed if dates match

I have an example here of my spreadsheet. Basically my main page has a drop-down (via data validation) where you can toggle through any month and it responds by showing data for that month. What I ...
3
votes
2answers
736 views

Upgrade existing Google spreadsheet to New Google Sheet

I keep getting the message on my Google spreadsheet that I'm using the old spreadsheet. There is an option to create the new Google sheet, but no option to upgrade the existing. Please check this ...
2
votes
1answer
2k views

Date and time stamp automatically added in column

We have a barcode scanner that we use to track student assignments. I am trying to create a Google Spreadsheet that tracks the assignments for each subject. I have been using the following script: ...
0
votes
0answers
55 views

Import info from multi tabs in a spread sheet to one sheet

I'm looking to move data from "sub sheets" to the main sheet. I know I've done this before but it's been 5 years since. So here's what I'm looking for: ...
2
votes
2answers
512 views

How do I sum MM:SS.sss (minutes and seconds) with Google Spreadsheets?

I was looking at a previous post and they used the cell input as follows =ARRAYFORMULA(SUM(TIME(LEFT(B2:B3,2), MID(B2:B3,4,2), RIGHT(B2:B3,2)))) And it works to a point. But the numbers don't roll ...
1
vote
2answers
164 views

Google Spreadsheets: Add 1 if there is data in cell

I have a spreadsheet of data which lists the inspection results of schools, in which I have a column that states the result or is empty if that particular school has not yet been inspected. I want ...
2
votes
1answer
350 views

Can you get hyperlinks to work in a published spreadsheet?

I created a Google spreadsheet, included a link within it (using the "hyperlink" function) and then published the file to the web. It turns out that when you access it from the web, links don't work. ...
0
votes
0answers
74 views

Google Docs update values on a 2nd spreadsheet and automatically links and updates values in the 1st spreadsheet

I have 2 spreadsheets. Spreadsheet 1, the initial data is entered manually. I do an importrange into spreadsheet 2 with a order by Col2. This is what I get when I perform importrange (sort on ID) ...
1
vote
1answer
366 views

How do I reference a cell string to use as a note in another cell?

I'm simply looking for how to link one cell's data into another cell as a note. What I have here simply errors telling me I do not have permission to setNote. :/ function noteSetter() { var ss = ...
1
vote
1answer
71 views

Format a Cell with Script

I need to write a script to see if a cells value is found in an array, and if it is change the background color of that cell. Can't do this with "Conditional Formatting" as it needs to compare with ...