A productivity application from Google that allows you to create and edit worksheets

learn more… | top users | synonyms (2)

0
votes
1answer
2k views

Where are the conditional formatting custom formulas?

I would like to use custom formulas in the conditional formatting panel on Google Spreadsheets, such as indicated in that link: https://support.google.com/drive/answer/78413#formulas The problem is ...
0
votes
2answers
93 views

Run formula on different sheet

I need help applying this formula to a different sheet: =SUMIF(A2:A6,"3",H2:H6) I'm basically trying to discover expenses for the month of March, and hopefully having a year constraint in there ...
2
votes
2answers
575 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
2answers
39 views

Auto bracketed pricing in Google Spreadsheets

I am keeping track of some sales in a Google Spreadsheet. I have a price bracket for number of items sold and unit cost (so that people ordering in bulk have lower prices). I used to just have about ...
1
vote
1answer
64 views

How does Google know that I am not a human?

Over on Stack Overflow I asked a question regarding accessing Google Spreadsheets with CURL, which doesn't seem to be possible any more, even when setting a valid user agent string. My question ...
3
votes
3answers
8k views

Conditional Formatting in Google Spreadsheet

I have a list of addresses in column C for work orders, I'd like them to be highlighted if there are duplicates so we don't forget a work order on each visit. These work orders/results are dynamic and ...
0
votes
1answer
599 views

Why is data suddenly being pasted in Excel as a single cell when copying from Google Docs?

I have been using Google Docs for some time now and have been able to copy certain sections of columns of the spreadsheet and paste it into an Excel sheet and up until now it has transferred exactly ...
2
votes
1answer
164 views

Google Sheet sum column by referencing column header

In Google Spreadsheet, I would like to find a column using a variable matching the column header and sum the column if the match is found. Example: ------------------- Ref | X | Y | z | ...
3
votes
1answer
265 views

Query MAX group by

I'm trying to Query in only the most recent entries of each part number. I can usually figure this stuff out but cannot figure out why it only returns the (date) and not the (part number) and (most ...
2
votes
1answer
50 views

Google Sheets referenced cells and sorting

I am working on a grades input spreadsheet. Consider 3 sheets: A list of assessments containing references, names, weighing etc. A list of students, with IDs etc. A table with student names in rows ...
2
votes
2answers
208 views

Add new row while keeping functions in new Google Spreadsheets

In the new Google Spreadsheets, I'm trying to make a simple spreadsheet which will assign points to my salesmen regarding some actions they complete. I would like to be able to add a new row below ...
3
votes
1answer
297 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
57 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: ...
1
vote
0answers
135 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 ...
17
votes
6answers
106k 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
461 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
266 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 ...
0
votes
1answer
201 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
2k 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?
5
votes
1answer
2k 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
764 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
29 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 ...
-1
votes
1answer
342 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
255 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
158 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
253 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
61 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 ...
2
votes
2answers
275 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
282 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
500 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
111 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 ...
4
votes
2answers
1k 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 ...
2
votes
1answer
843 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? ...
2
votes
1answer
5k 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 ...
3
votes
1answer
85 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
1answer
67 views

Change logs for Google Spreadsheets

We've got a large shared spreadsheet which is a chart showing user permissions. It's writable by several people. Although Google Drive allows you to roll back the changes simply its interface isn't ...
5
votes
1answer
29 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
389 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
108 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
608 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
1answer
76 views

How to prepare data to be summarized with a pivot table

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 four cases a day. So ...
1
vote
0answers
38 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 ...
2
votes
1answer
7k 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
72 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 ...
1
vote
2answers
668 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 ...
7
votes
4answers
13k 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
125 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
2k 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
137 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
139 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 ...