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

learn more… | top users | synonyms

1
vote
0answers
7 views

How Can I Solve Error “Exceeded maximum execution time” in Google Spreadsheet?

I found a script which I really need (link) but it gives an error (Exceeded maximum execution time) generally. How can I solve this error? This is the script: function getTotalSum(cell) { var ...
0
votes
2answers
22 views

Date format in Google spreadsheet is not correct

Whenever entering the date e.g. day-month-year, it automatically changes to month-day-year. I went into format-number-more formats-more date and time formats, and I changed it to day-month-year. And ...
2
votes
1answer
27 views

Google sheets: Individual time stamps for individual sheets in a spreadsheet containing multiple sheets

I am using the New Google Sheets, and I have created a "Master Document" that contains a multitude of sheets, with each expressing different kinds of data. I want a "Last modified" time stamp to ...
1
vote
1answer
19 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 ...
0
votes
0answers
9 views

How can I synchronise the rows of a Google spreadsheet with Asana tasks?

My startup uses a Google spreadsheet for its client database (linked to a Google form, so that clients can fill their own data in if needs be). We also use Asana for our tasks and would like client ...
0
votes
0answers
21 views

How to create a simple dialog form in Google Spreadsheets with GAS

The functionality that I am going for is this: Click on a menu option Interactive box comes up with 6 textboxes that correspond with a label each In two of those boxes, at most three, a number is ...
1
vote
1answer
55 views

Leads per Week For Last 10 Weeks Formula With Countif

I have a long list of dates (like below) that indicate Leads and I am trying to get number of leads per week for the last 10 weeks. I know I can get the current week number with ...
1
vote
1answer
51 views

Google Spreadsheet - changing row colour if value set?

I'm trying to use the following script to change the row colour if a value in column N is set: function onEdit() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ...
0
votes
2answers
49 views

Reflect changes in on sheet to another on Google spreadsheet

I have two sheets on a Google Spreadsheet. One of which is the copy of the other. Now what I want is, when I edit one sheet, the same edit must reflect on the other. How can I do that ?
0
votes
0answers
12 views

“Object not found” error when saving a Google Apps spreadsheet in Box after edit

The corporate entity that I work for is rolling out Box.com, and since we like the collaborative features of Google Apps, I am experimenting with the Box.com integration with Google Apps. Using the ...
0
votes
0answers
13 views

Google Spreadsheet SQL subquery “where not in”

I'm attempting to perform the following SQL command concept, but with two sheets in the same google spreadsheet document: select * from table1 where column1 not in (select column1 from table2) How ...
1
vote
0answers
26 views

Google Spreadsheet Sub Columns/ Multidimensional data

So, I'm trying to create a spreadsheet to track and graph a rifle team's performance. One page with data, and the rest with the graphs. The data needs to be organized by the date of the practice, ...
1
vote
0answers
35 views

ARRAYFORMULA and COUNTIF

I have a formula: =IFERROR(COUNTIF(C14:V14,"I")/ COUNTIF(C14:V14,"<>"),) to compute a percentage of I inputs divided by <> (all other inputs) and I need to omit blank cells. The IFERROR ...
1
vote
1answer
22 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
0answers
10 views

Charts does not follow page flow when printing

I'm trying to print a sheet with a bunch of charts. When printing it seems like the charts doesn't count as part of the page as the formatting of the pdf og printed page does not at all reflect how ...
0
votes
1answer
30 views

Google Form to Spreadsheet formula questions (index/match array and 24hr-12hr clock)

I need help with a Google Spreadsheet populated by a Google form. I cannot get the following formula to work correctly with my form submissions: =(ARRAYFORMULA(if(row(H:H)=1,"Language",(INDEX('INDEX ...
0
votes
1answer
21 views

How do I merge columns but preserve data Google spreadsheets

Column A is a list of every day from 1/1-12/31, Column B is a list of specific dates within the range of column A. Columns C-N are events that took place on the corresponding date in column B. How can ...
0
votes
0answers
18 views

google spreadsheet MAX SORT FILTER ROW

I have this kind of table Row| A | B | C | D 0 | Date | Code | Operation | Prev Row 1 | 2012-01-01 | IFF | 1000 | ?? Should be 2 2 | 2010-04-04 | IFF ...
1
vote
1answer
35 views

Google Spreadsheets: Find cell with highest value of a cell range

I have a row of percent values. In the last of the row (Coloumn E) I want the text to appear, that is in the very first row above the values. What's the formula to put in the cells in coloumn E? ...
1
vote
0answers
24 views

return name of range as string

I have a range that is named apple in Google Spreadsheets. I thought a method like getRangeName("apple") would exist. I want to get the names of many ranges and set them as the header for the ...
1
vote
1answer
35 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
0answers
22 views

If statement to input the next integer

I have a row of values that sometimes returns a value, and sometimes doesn't. I want to input the first number that is actually a number. Sheet Value Indicators Column A Column b ...
0
votes
2answers
44 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 ...
0
votes
0answers
12 views

Why don't the Google Spreadsheet notes line up after several sorts?

I inserted notes into my Google spreadsheet to add comments. For several weeks no problem. Now I've discovered that after several sorts in various ways, e.g., date, name, city, etc., the ...
1
vote
0answers
55 views

Can I make a Google spreadsheet deploy as a web application?

Well, this is what I'm planning to do: my spreadsheet looks almost done to me (a few changes here and there of course, but that'll continue forever). I want to deploy it as a web-app and then who ...
1
vote
1answer
54 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
28 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
0answers
27 views

How does Google know that I am not a human?

Over on stackoverflow 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 arising ...
2
votes
2answers
30 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
54 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 ...
1
vote
1answer
24 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 | ...
1
vote
1answer
15 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
24 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 ...
1
vote
1answer
30 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 ...
2
votes
1answer
38 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
33 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
68 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 ...
1
vote
2answers
58 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
63 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
35 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
37 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
48 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
64 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
62 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
16 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
26 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
77 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
26 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 ...
2
votes
2answers
88 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
18 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 ...