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

learn more… | top users | synonyms (1)

1
vote
3answers
109 views

Google Spreadsheets: How to drag down 'A1:A2', 'A1:A3', 'A1:A4'

Title basically says it all lets say every day (1 day = 1 row) a number is being added in column A I want to have column B show the total of these numbers. However, if I drag it down, it keeps ...
0
votes
2answers
317 views

Make first row in Google Spreadsheet column names

I cannot figure out how to turn the first row of a Google Spreadsheet into column names so that I can sort the spreadsheet by column without losing the variable names at the top of the spreadsheet. I ...
0
votes
0answers
96 views

Continue formula on Form submission

I want the following formula to be continued on form submission: =ARRAYFORMULA(D2:D*E2:E+L2:L*M2:M+Q2:Q*R2:R) I came across =ARRAYFORMULA(FILTER(D2:D;D2:D<>""*1.2)) this formula works perfect ...
0
votes
0answers
456 views

Create a checkbox-type function that works on the Android Drive app for Google Spreadsheet?

How can I create a checkbox-type function that works on the Android Google Drive app for a Google Spreadsheet? I want to make a to-do list (groceries, trip prep, etc.) that the user can check "done" ...
0
votes
0answers
29 views

Google Spreadsheet print column-wise

I want my Google spreadsheet to import data from another Google spreadsheet. And I have successfully done that. But now I want to design a game in which I need the data to be imported and written ...
1
vote
1answer
476 views

How to search multiple columns in Google Spreadsheet and return values in other columns?

I have two spreadsheets and would like to enter a value into cell A1, have it check multiple columns in a spreadsheet named 'data' and output information from other columns if it's a match. ...
5
votes
3answers
176 views

Looking for an “isFormula” formula for Google Spreadsheets

Is there a function that will tell if a specific cell has a plain (manually entered) value or has a formula?
2
votes
1answer
302 views

How do I debug “The action you're trying to perform is causing a fatal error and cannot be performed” errors?

Since today, I'm no longer able to edit a specific Google Spreadsheet. Every time I try to make an edit, no matter which kind, an error message is displayed: The action you're trying to perform is ...
1
vote
1answer
41 views

Group by and ordering inside a group in Google Spreadsheets

I have the following data in a Google Spreadsheet: 1 shiplu rice 2 sharmin rice 3 sharmin fast food 4 sharmin salad 5 rafiq burger 6 nazia noodles 7 rafiq salad 8 rafiq ...
0
votes
1answer
62 views

Use sort function but filter results

I'm looking to use the =SORT function on some data, but I only want the first result with that name. Column A contains a Name, column B contains a level, and column C contains a date. I'm currently ...
3
votes
1answer
151 views

Is there a way I can set only a certain sheet visible in Google Spreadsheets?

So lets say I have a Spreadsheet and I press the share button to Public (no edit except me). I have 2 sheets but only want other users to see 1 sheet. Without having to create another document is ...
2
votes
1answer
636 views

Split content with multiple lines into multiple rows and columns in Google sheets

I like to know if it is possible to split an entire paragraph contained in a single cell, into multiple columns and paragraphs using formula's in Google sheets. This is what the text in the cell would ...
2
votes
3answers
246 views

Count the number of Fridays in a specific month

I would like to find the number of Fridays for a specific month via function in Google Spreadsheets. For example, for January 2014 the value would be 5 and for February 2014 the value would be 4. ...
3
votes
2answers
87 views

Cube rooting a negative number does not work?

I tried using this formula for cube rooting but it doesn't seem to work. =ROUND(C38^(1/3)) The value of C38 is -2. I'm getting the following error: Imaginary numbers are not supported in real ...
0
votes
1answer
123 views

How do I write or read Google-Sheets “comments” on mobile devices?

In a Google-Sheet called Field Schedules for Google web-apps at http://drive.google.com you can right click on a cell to open a context menu with the option to "Insert comment." Let's say for example ...
1
vote
0answers
41 views

Google Drive: Pasting Spreadsheet Into Doc Woe's

I'm trying to paste a few cells from my spreadsheet into my document. The problem is that the spreadsheet never fits correctly into the document, even though all the cells are smaller than the space ...
1
vote
0answers
55 views

Simultaneously sort multiple ranges on a single sheet in varying orders

I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, ...
2
votes
1answer
136 views

CONCATENATE a string with an ArrayFormula

I have the following string in column H and I. H2="http://" I2="aaa" H3="http://" I3="bbb" I want to have a auto-generated J column, which results like: J2="http://aaa" J3="http://bbb" So I put ...
-1
votes
1answer
41 views

Help with a previous question you answered

I noticed this code from a thread I was reviewing as I needed the same functionality to provide a timestamp when a particular row is edited in a Google Spreadsheet; function onEdit() { var s = ...
0
votes
0answers
30 views

forms automatically generate individual sheets

Is there a function which will allow data submitted via forms to create an individual sheet within my master file, in addition to being incorporated into the master list. For example, in the data ...
1
vote
1answer
34 views

sharing only select rows

I'm trying to create a sheet with data compiled via application forms which are filled out by many people. I want to be able to edit that information and share portions of it with the people who fill ...
1
vote
1answer
91 views

Daily running average in Google Spreadsheets possible or not?

I work at a job wherein I receive tips. I have set up a sheet to keep track of the tips I make throughout the year. I have all the formulas set up that I want, save for one. I am trying to figure out ...
1
vote
2answers
42 views

Is there a more efficient formula to use than just copying and pasting?

D3 =(B3^3.0)-(B2^3.0) D4 =(B4^3.0)-(B3^3.0) D5 =(B5^3.0)-(B4^3.0) D6 =(B6^3.0)-(B5^3.0) D7 =(B7^3.0)-(B6^3.0) .... I rarely used Excel but since I don't have it installed on my computer I'm using ...
2
votes
1answer
105 views

Applying IF Statement to entire column

I currently have an IF statement that checks a cell in column B if it is blank. If it is blank it returns No in the corresponding A cell. If it does have a string, it returns Yes. I currently have ...
1
vote
1answer
117 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
116 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
75 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
421 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
139 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
90 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
125 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
585 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
225 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
170 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
132 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
259 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
76 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
128 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
79 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
521 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
322 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
127 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
43 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
93 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 ...