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

learn more… | top users | synonyms (1)

1
vote
1answer
116 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 ...
1
vote
1answer
102 views

Hide gridlines in Google Docs spreadsheets by default?

I general like to hide spreadsheet gridlines. Google Docs has them on by default when you create a new sheet. Is there any way to have them hidden by default?
1
vote
1answer
2k views

Does text overflow a Google Spreadsheet cell if the cell next to it is empty?

In Microsoft Office Excel a long text string is readable over multiple columns whenever the next (right) column is empty. Is that also possible within Google Spreadsheet?
0
votes
1answer
71 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 ...
2
votes
1answer
406 views

Google Apps Script - exceeded maximum execution time

I'm currently developing a new spreadsheet for my company to make one of the tasks we do on a weekly basis more easier - the way it works is data is imported into this spreadsheet and then the scripts ...
4
votes
1answer
114 views

Force cell to zero if result is below zero or N/A

I currently have the exact function set up here: Summing a column based on another column in Google Spreadsheet The number I'm getting from the query is almost always negative (a list of ...
0
votes
0answers
32 views

Google Sheets Custom Sort

I need help creating a script to select only rows 15 to 630 (a15:z630) of my "DASHBOARD" page and sort these rows by column A (date). The first 14 rows are frozen and must never be sorted. ...
1
vote
1answer
25 views

Take data from a specific row

I'm making a form where people can enter in certain dimensional grades for a specific name. So each row of the spreadsheet will probably read something like: Name | Strength | Agility | Luck John | ...
0
votes
1answer
84 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
vote
2answers
51 views

How to display a character when a value in the same row is the highest value in its column?

I have the following example table: A | B a | 5 b | 3 c | 1 d | 9 <=== expected result e | 0 f | 4 So it should display d as in the other column 9 is the highest value.
1
vote
2answers
124 views

How to zero out cell if filtered sum is less than 0

I currently have the exact function set up here: Summing a column based on another column in Google Spreadsheet I would like to know how to make the value 0 if the real sum is less than 0. Any help? ...
1
vote
1answer
559 views

In Google Script, get the spreadsheet cell calling a custom function

In VBA for Excel, I can get the column of the cell making the call to a custom function like this: ThisCol = Application.Caller.Column What is the equivalent in Google Scripts? I've been trying to ...
2
votes
1answer
219 views

Arrayformula with dates before and after

Here is what my spreadsheet looks like I enter recurring weekly payments details in G,H,I,J & K (Name,Amount,Day of week, Start Date, End Date respectively). This arrayformula: ...
1
vote
2answers
79 views

Possible To Get Average Function For Accumulative Input?

I am trying to figure out an average function for my Google spreadsheet, but I am not sure if it is possible, see screenshot: I could not fit all the spreadsheet in the pic, but the column A goes ...
1
vote
2answers
159 views

In Google Spreadsheets, how do you iterate over a cell range and use the index counter?

I have a table in which I have a list of amounts, each belonging to one of 15 categories A B 1 cat | amount _____|________ 2 1 | 12 3 1 | 4 4 4 | 18,90 5 ...
3
votes
1answer
123 views

How to convert 1.33 hours to 1:20 (hours:minutes)?

How to add minutes in Google Spreadsheet? I've got a Google Spreadsheet that looks roughly like this: min | min | min | min | min | total min | total time 20 | 20 | 20 | 20 | 20 | 80 ...
1
vote
0answers
255 views

Export CSV from a Google Spreadsheet page from command-line

I'm using a Google Spreadsheet document to configure a data-driven program. The program consumes a CSV file, which now I have to export manually from the document. It is rather inconvenient, as ...
2
votes
1answer
74 views

Get data from specific date in Google Spreadsheets

I’m trying to collect data from specific dates in a Google spreadsheet. For example, I want to get the data from January only. Is this possible?
0
votes
1answer
115 views

Time Triggered Script to Change Cell Contents

What I want to do is for example: A time will be manually entered into a cell say D3, when it is 20 minutes before this I want cell D1 to change to "20 MIN", WHEN IT IS 5 minutes before I want to ...
1
vote
2answers
78 views

Google Spreadsheet Formula relating to dates

I need a formula that will do the following: If cells in columns L, O or Q have a date of today or earlier then cell B must show the text "CHECK".
0
votes
0answers
32 views

'New Row' Spreadsheet List function

I have set up a Google Docs Spreadsheet to use as a job booking in system for my design agency. I'd like to have this where the newest jobs are at the top, but at the very top is a blank row, where a ...
1
vote
2answers
484 views

Formula to populate one column based on the value in another one

I would like to populate a column R with the value YES, if another column N has a value of NO.
1
vote
1answer
278 views

Having an issue with horizontal scrolling in Google Spreadsheets

When I try to scroll horizontally in Google Spreadsheets using the track pad, nothing happens. However, if I scroll vertically first, I can then scroll horizontally if I don't pick up my fingers from ...
1
vote
1answer
125 views

How to get total count of matching counts from different, but matchingly named sheets in same spreadsheet?

I have an inventory spreadsheet with each chest having its own sheet with the sheet numbered and each of those sheets have identical syntax. Rows 1-4 are protected by the separator line, so data ...
2
votes
1answer
41 views

Creating a Chart with independently indexed series

I have a data series that looks like this: 0 317.59 1.4 317.59 1.5 408.77 2.15 408.77 2.25 440.46 2.98 440.46 3.08 471.37 3.12 471.37 3.17 ...
1
vote
0answers
91 views

Entering time data quickly using code for a specific range of cells

What API code do I use if I want to quickly enter 24 hour times (without entering the colon and still retaining time formatting) for a certain range of cells? I know the following code works for ...
1
vote
1answer
238 views

Count non-blank cells based on arrayformula in Google Spreadsheets

I am trying to get a count of all non-blank cells in a column that belong to a certain market. The formula I'm using (and that is not working) is: =ARRAYFORMULA(SUM(('GR Live Campaign ...
1
vote
1answer
63 views

Sum every 9th row starting from the 4th row in Google spreadsheet

I have a column where there is a number every 9th row. The problem is that my first value starts on 4th row then all the next ones every 9th row. So far I tried this: ...
1
vote
1answer
58 views

IF OR Google Spreadsheets Formula Problem

I'm getting an error back for this formula. I've tried with commas, without space, short formula and I still can't seem to get it to work. Here's the formula that I'm using: =IF(OR(C3 = "Jenna"; ...
1
vote
2answers
1k views

Check if Column contains value, when found return contents of another column in that row

I'm using a Google Drive spreadsheet to organize guests I want to invite to my wedding. On one sheet I want all my guests and information relating to them (are they friend/family? Are they an ...
0
votes
0answers
72 views

“ImportXML” function in Google spreadsheet for “answers.yahoo” site

Please help me understand why this formula =importXML("http://answers.yahoo.com/search/search_result?fr=uh3_answers_vert_gs&type=2button&p=cloud","//ul[@id='yan-questions']") is not ...
1
vote
0answers
109 views

SUM(SUMIFS Array in Google Spreadsheet

Now that Google Spreadsheets support SUMIFS I'm trying to import an expense tracking spreadsheet but I've run into a problem with a formula. Here is the current code: =SUM(SUMIFS('RE ...
0
votes
0answers
52 views

Error in Query function with aggregate function in two column & Pivot

I have an error while using query function which I have used in “Solution” Sheet. Below is the function that I have used: =QUERY(Problem!A6:G3493,"Select C,sum(F),Sum(G) group by C Pivot D label C ...
0
votes
1answer
116 views

Creating a document (e.g,, MS Word) attachment in Gmail from a spreadsheet script

I've created a document file in the spreadsheet script. What I want to do is, from the script, create an email message with the document file (NOT a PDF) as a Gmail attachment. I spent about 2 days ...
1
vote
2answers
782 views

Script to automatically change text value

In GDocs under Tools > Preferences, I can define automatic corrections, so that if I type l*, it spells low, h* -> high, etc. In Google Spreadsheet there is nothing like that. Can I do that with ...
1
vote
1answer
351 views

Limiting Range in OnEdit Timestamp Script in Google Spreadsheets

I would like to be able to limit the range of cells being assessed by this script to the first column. Apply the timestamp to the last column and only have the script run on a specific sheet "Short ...
4
votes
2answers
192 views

Google Sheets - How can I use row values to index into another sheet?

I have an arbitrary google spreadsheet Data. alpha | 0.1 beta | 0.2 gamma | 0.3 delta | 0.4 epsilon | 0.5 And another sheet in the same file, Data Subset that holds an arbitrary ...
0
votes
1answer
630 views

How to apply formulas, validation to newly added row (using add more rows at the bottom not using insert)?

I have formulas and validation in columns D, E, L, M and N. I want these formulas and validation to be automatic whenever I add rows using the option "Add more rows at the bottom". Not using insert ...
2
votes
2answers
1k views

How do I create a multiple choice question in Google Forms based on spreadsheet data?

I am making a Google Form for evaluations. I will have a multiple choice question in there and the available options have to come from a list of items, say on a spreadsheet or a text document. I have ...
0
votes
1answer
329 views

How can I record the date/time when a new row is added?

I want to add a date value when a new row is added in Google spreadsheet. I have seen the script on Add a 'creation date' value when a new line is edited, but I was not able to modify the code to my ...
1
vote
2answers
72 views

What is the best approach to adding additional costs to items in Google Spreadsheets?

In Google Drive I'm keeping a spreadsheet of everything I spend money on. I have a heading for the cost but alone that's insufficient. For example, if I tip after a meal I really want to have that ...
2
votes
1answer
327 views

Hover to see value on a chart

I have a Google Spreadsheet on Google Drive, which until today I was able to see a value when I hovered on the dot with, but now it's not working anymore. Unfortunately I can't remember if I changed ...
3
votes
1answer
1k views

Google Spreadsheets Scripts Gallery menu item missing

How do we access the Scripts Gallery in Google Spreadsheets? Documentation around the web says that it should be in Tools -> Scripts Gallery. But I only see Script Manager and Script Editor. Going ...
2
votes
1answer
2k views

How can I use ARRAYFORMULA and SUM together to get a column with the sum of the proceeding rows

In google docs, I have the following data | A | B | C | ... | N | TOTALS | 1 | 123| 425| 324| ... | 234| =SUM(A1:N1) | 2 | 123| 425| 324| ... | 234| =SUM(A2:N2) | ...
1
vote
1answer
600 views

Is it possible to feed multiple form drop down lists?

I am using Tom Horwood's code which has worked for me for updating one drop-down. But my form has multiple drop-down lists which I would like to make dynamic. Is this possible? Tom Horwood's code ...
1
vote
1answer
507 views

Get value of cell based on the value of another cell

I'm looking for help on the following : Exemple sheet I need the word Frisbee to be put in the green cell Any idea ? The value researched will always be text, and depending on a date. Edit : Just ...
0
votes
0answers
55 views

Auto receipt filler

I have a spreadsheet that has two sheets, in which I pull data from for making printable receipts. At this point, I am doing it manually by copying the data from the first and second sheet and putting ...
5
votes
1answer
2k views

Why doesn't “Custom number format” show up in Google Sheets (Google Spreadsheets)?

According to this Google help article, I should be able to do the following to apply custom number formatting in a Google Sheets document. Highlight the data you want to format. Click the Format ...
1
vote
2answers
68 views

Google Spreadsheet - periodically stamp sheet contents

As the title, is there a way to have a "print" of the content of a sheet periodically? i.a., I'd like to have a trigger that every Monday at 08.15 A.M. copy the contents of a group of a cell of a ...
0
votes
1answer
26 views

IF Formula where X = an unidentified (but stable) #

I really think this should be simple - but I am stumped. Please see image. All I want is that my clients be able to put an "x" in the tasks they want performed. Each has an associated cost, which I ...