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

learn more… | top users | synonyms (1)

2
votes
1answer
67 views

How can I fill the diagonal of a matrix with zeros?

I have an empty matrix: I would like to fill the diagonal of a matrix with zeros: Is there any clever way to do it? The matrix can be pretty large and it's tedious to do this manually. I could ...
1
vote
1answer
40 views

How can I copy the lower triangle into the upper triangle?

I have a matrix in Google Drive Spreadsheets. Only the lower triangle is filled. I would like to copy the values of the lower triangle to the upper triangle. How can I achieve that? Example: ...
2
votes
0answers
83 views

How to make script slow down in GoogleSheets Script Editor?

I have a script thats attached below, and the problem I'm facing is that after it has keyed in "ticker" to Raw Data in b1, my entire sheet is never done loading and thus when its time to check if it's ...
2
votes
2answers
2k views

Checkbox function to automatically add to total

I'm doing my club's accounting in a Google spreadsheet. I am looking for a way to put a checkbox at the beginning of a line in order to tick off the members who paid their dues and then have a ...
1
vote
1answer
100 views

How do I write a formula in Google Spreadsheets to to compare two cells and write answer into another cell

I am running into some obstacles while trying to design my ideal Google Spreadsheet. I am trying to do the following listed below and I am having a hard time. I was wondering if anyone can help ...
1
vote
1answer
45 views

Fix Value of Row or Column from Another Sheet

In a given sheet, if you have a formula that involves a value, it's possible to fix either the column or row for that value as you expand the equation, i.e. : =A1 + A!2 But how do you do this when ...
1
vote
1answer
51 views

Calculating Time Zones in different columns

I'm trying to reflect different time zones across columns. In Excel, I could just e.g., =A1+2 and it would give me the right time. A B C EST CST PST 1 9:30 11:30 13:30 ...
1
vote
1answer
78 views

How do I multiply column values?

I simply want to multiply column h with column j, and store the result in column k in each row. What do I type in as the formula to do this?
2
votes
1answer
428 views

Export all sheets in a spreadsheet to csv in Google Apps

Is there a way to export all sheets in a google spreadsheet to csv as individual files ?
2
votes
1answer
115 views

Changing cell color in a range

i have 4 columns of values in each cell, the cells are different colors : Cell A1 = 12 (color - Green) Cell B1 = 10 (color - Pink) Cell C1 = 11 (color - Blue) Cell D1 = 13 (color - Red) Cell ...
1
vote
0answers
23 views

Google Spreadsheet Exporting Results

First of all, I have a Survey Form (JotForm) and I export the statistics in Google Spreadsheet. So I have on each column my specific field that was completed in my Survey. What I would like to do is ...
0
votes
1answer
33 views

Google Spreadsheet, countif with multiple data points

I'm having some trouble figuring out a formula for Google spreadsheet. Am getting answers but they're not counting what I'd like. I've pasted an example scenario below: Here's the report I'm trying ...
2
votes
2answers
99 views

Incrementing value read from spreadsheet exploding. 1 + 1 = 200 000 000 000

I read a value (in this case 7) from a Google Spreadsheet with a script, increase that value using source++ and write the increment back to the spreadsheet. I expect a series of 7, 8, 9, 10. ...
1
vote
1answer
30 views

Button in column C in each row

I have a spreadsheet with three columns and lots of rows. Column A has a numerical ID Column B is empty Column C is empty I want to have a button in each row in column C. When pressed, it should ...
3
votes
2answers
114 views

Combine text from rows got by specified date in a Google Spreadsheet

I am trying to create a summary sheet that combines the values and descriptions from my bank transaction into individual dates I want to paste the transaction csv into google spreadsheets. The ...
2
votes
1answer
28 views

Moving down the fixed page numbers in a Google spreadsheet

Can you move the page numbers on the left side of the screen down? I have a list that I need numbered, but the very top of the list (meaning the first column) has the categories for said list. So that ...
1
vote
2answers
134 views

Automating Calls to New Google Sheets Add-ons

I'm building a Google Spreadsheet that uses an official add-on to pull data from Google Analytics using the new add-on store. What I'd like to have it do is automatically refresh the data every day at ...
2
votes
2answers
84 views

How to write this formula “If X = Y, TRUE, else(look at this range, find the position, then ”do this")?

Since I don't know exactly the kind of function I'm looking for, be aware that maybe my terminology isn't right to describe what I need to do. I suppose that I need something close to an if/else ...
1
vote
1answer
57 views

Formatting integer to Gold/Silver/Copper using custom number format

I have number in coppers: there are 100 coppers to a silver and 100 silvers to a gold I need the raw number to stay in the cell so it can be used in calculations. Ideal format: 1 ==> 1c 123 => 1s ...
0
votes
0answers
110 views

How do I use a script to reference multiple cells in relation to the host cell? [duplicate]

I'm trying to make a script for a custom function in Google Spreadsheet to work out the hours worked in a day. My problem is after searching I can't work out how to reference cells relative to the ...
2
votes
0answers
67 views

Can a Google Spreadsheet be recalculated if it's not manually opened?

We have some Google Spreadsheets that use the ImportHtml() to pull in some real messy tables. Then on on an alternate page we access the above data and pull it into a nice cleanly formatted table via ...
1
vote
1answer
82 views

Create chart from single column in Google Spreadsheets

I used a survey to collect data about people's opinion. The question is answered using a check-box (Yes/No). I would like to visualize the results using charts. How can I do that using one column? ...
1
vote
1answer
440 views

Does IMPORTDATA() refresh when an Apps Script runs even if the sheet isn't open?

We have a Google Spreadsheet that pulls data from an external source via an IMPORTDATA() function and then a Google Apps Script that is on a timed trigger that performs other things with the imported ...
2
votes
1answer
45 views

Display Columns For this weeks Data

I'm trying to create a to do list schedule like spreadsheet that would show only the data presented for the current week. I've been having some difficulty figuring out how to display the data of ...
2
votes
0answers
35 views

Change logs for Google Spreadsheets

We've got a large shared spreadsheet which is a chart showing user permissions. Its writable by several people. Although Google Drive allows you to roll back the changes simply its interface isnt ...
2
votes
0answers
13 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
96 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
47 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
80 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
36 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
28 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
859 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 ...
1
vote
1answer
36 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
271 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
156 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
44 views

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

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
67 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
35 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
56 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 ...
0
votes
2answers
186 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
100 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
34 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
325 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
36 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
53 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
44 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
68 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 ...
1
vote
0answers
78 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
96 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, ...