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

learn more… | top users | synonyms (2)

2
votes
0answers
12 views

Is it possible to import cell data AND cell format from one Google sheet to another? [duplicate]

I'm trying to import data "and" formatting from one sheet to another. I'm using =importrange("docID", "sheetName!A1:A30") to get the data, but it doesn't get the format. Suggestions?
1
vote
1answer
29 views

Convert text automatically in Google Spreadsheets.

Background: We have a list of data that we import into Google Spreadsheets from Wufoo.. The data is user generated (user inputs the information into the form). After importing the data into google ...
1
vote
1answer
18 views

How to reference a range of data in another workbook (not importing)?

In Google Sheets, how do I reference a range of data in another workbook (not importing)? I want to reference a range of data in another workbook. The only information I can find is for ImportRange() ...
2
votes
1answer
23 views

Variable GoogleFinance formula (Google Spreadsheets)

I have a question regarding a formula: =GoogleFinance("CURRENCY:(A2)EUR")*B2 The content of cell A2 = USD, the content of cell B2 = 60, so the formula should be translated as ...
0
votes
2answers
37 views

How I resolve import html showing error N/A [closed]

N/A error showing on following query: =importhtml("http://www.barchart.com/commodityfutures/Cotton_%232_Futures/CT?search=CT*","table",1) and =Importhtml(A2,"table",1) Also table id is "dt1".
2
votes
0answers
12 views

In Google Sheets is it possible to print to a custom paper size?

I have a spreadsheet that I'd like to print on a single 8.5" x 22" sheet of paper. This is not a standard paper size, but my printer can print on it. The Google Sheets print settings dialog only ...
1
vote
1answer
67 views

Getting values from other sheets with a custom function

I've defined the following function, and use it in sheet1: function myfcn (sheetname,rowstart,rows,columnstart,rows){ var sheet= SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetname); ...
1
vote
1answer
22 views

Custom Google Spreadsheets shortcuts : move selected row(s) Up/Down/Top/End

As the title says, I do move rows a lot and the lack of default shortcut complicates things for me... The drag option isnt practical when I need to move some rows to the bottom of a huge sheet!! I ...
1
vote
1answer
29 views

Automatically record daily values in a new column

So I have this spreadsheet I use to control Content funnel. I've come up with a few formulas to use something else than a pivot table. But in order to get the trends and alarms I'm looking for, I need ...
1
vote
2answers
20 views

How do I calculate the sum of 2 columns using the max from each row based on a condition?

I have data in two columns. I would like to sum the two columns (A and B) based on the max value in each row and a condition (c) indicating if the row should be included in the sum. Example: A B ...
2
votes
1answer
19 views

How would I apply formatting to another cell based on whether another cell's date has passed or not?

I'm working on making a spreadsheet in Google Sheets, and I'm attempting to have a column of names and then a column of dates adjacent to it. I'd like to set up some sort of conditional formatting ...
1
vote
1answer
35 views

Change text in one cell by removing the parts entered in other cells

I want to know if there is a way to add multiple numbers with letters to one cell and each number/ letter get eliminated when that number gets placed in another cell. For example: cell b4 has: 4, ...
1
vote
1answer
16 views

Update latest spend on Google Sheets based on Date dimension

I have a spreadsheet report -- used to monitor our marketing campaign reports. So my goal here is to be able to update a cell showing the our current spending as of yesterday. How can I go about ...
1
vote
1answer
13 views

Using Arrayformula to compute running decremented total, subtracting the previous cell

This doesn't seem like it should be difficult. I'm keeping a running decremented total owed, where each line may apply some payment against the outstanding debt. Basically: A: Outstanding Owed | ...
5
votes
2answers
56 views

In Google Sheets, how does one get a 12-hour time of day *without* an AM/PM indicator?

I am trying to display times in Google Sheets without an AM/PM indicator, but with 12-hour time (not 24-hour "military-style" time). I do not need the AM/PM indicator as it is redundant in my ...
0
votes
1answer
25 views

How to dynamically retrieve and display data based on input from google forms

To be very specific, let's say I have a google form where it asks you your name (text box) and how much do you like carrots, with a multiple choice prompt of "very much" and "I hate them!" After the ...
1
vote
1answer
18 views

How to convert or parse olson timestamp in google spreadsheet?

How do you convert 2016-03-05T08:30:00 to time in google spreadsheet? I would like to convert it to hh:mm:ss. Thanks.
-1
votes
0answers
8 views

Adding cells from two different books in google docs [duplicate]

I have 12 different books. jan2016database, feb2016database, march2016database...etc for the year each book has 9 different sheets all titled the same i need to add cell b5 from sheet "compared" in ...
1
vote
1answer
25 views

How to receive a notification when changes are made to a specific tab in Google Sheets?

If would like to receive an email notification if a new row is added to a specific tab in a Google Sheets. The default notification rule settings are too limited and the Google Sheets Add-on Store ...
2
votes
1answer
38 views

Complex views in embedded Google Sheets

I have a Google Sheets contact list for a multicampus boarding school. The sheet at present summarizes the contact info for each person into the first 4 cells of the row. Entry is made using the ...
2
votes
1answer
14 views

Time query in Google Spreadsheets

I've started using Google Spreadsheets for our logbook and it's been a great help. I have data with a time component in it (start and end time) and I'd like to query or filter the data where the ...
3
votes
1answer
40 views

Filter multiple values using filter by condition tool in Google Spreadsheet

I'm trying to filter a long list of URLs to narrow down which ones I'm interested in. I've got my URL list in Google Spreadsheet and I'm using the filter tool to remove data that I don't want. At ...
2
votes
1answer
42 views

Forms Data Manipulation In Google Sheets

I'm trying to develop a solution using Google Forms with Google Sheets that will collect Google Forms data and then automatically divide that one form submission's data into multiple rows of data in ...
1
vote
1answer
39 views

Referencing a range in a sheet with variable name in another cell

When I would like to import (query) many columns in another sheet I use this code: =QUERY(sheet2!A1:D1;;) Now I would like to make this formula a little dynamic making sheet2 variable. So I put the ...
2
votes
1answer
27 views

QUERY data based on Alpha Range in Google Sheets

I'm trying to figure out if I can pull data from a sheet in a Google Sheets Workbook based on an alpha range. For example. I only want data associated with 'last name' that start 'A' and goes ...
0
votes
0answers
25 views

google.script.run.withSuccessHandler not working

In my Google Sheet script's page.html, I have <input type="button" value="Apply" onclick="google.script.run.setAttributes('abc');"> where setAttributes() is a function defined in Code.gs. ...
1
vote
1answer
24 views

How should I automate graph generation and image output in Google Sheets?

I am trying to send graphs of data to email recipients. I would like to output images of row-specific graphs based on cells in a Google Sheets document. In combination with Google Sheets/Drive, I am ...
4
votes
1answer
68 views

Can I check that all cells in a column contain unique values?

I'm have a list of IDs in a column on Google Spreadsheets. I need to check: That there are no duplicates in the column Which cells contain the duplicates Is it possible to do this?
0
votes
1answer
18 views

Using time values in conditional statements with IF formula

Algorithm: if time is 9:00am, display 6 I used the if formulas but it keeps on displaying "x" Time is in 24-hour format. =if(G2=20,"6",if(G2=21,"12",if(G2=22,"18","x"))) ...
1
vote
2answers
57 views

Basic date manipulation in Google script

I would like to define a custom function in Google Sheet. This function should do something very simple, yet I have not managed to find how to do it. I am very confused with all the answers I read ...
1
vote
1answer
40 views

How to retrieve email address of current user?

In Google Spreadsheet I am having the following issue: I am using Session.getActiveUser().getUserLoginId() to fetch the current user's email id but other than creator of the spreadsheet it is ...
3
votes
1answer
48 views

Adding a Month to a Date in a Google Spreadsheet with a Script

I'm trying to create a Google App Script that adds one month to a date already on a Google Spreadsheet. In the example below I was trying to take the date from cell B2 (1/1/16) and add one month and ...
2
votes
1answer
35 views

How to automatically wrap text to new responses from form?

I had a working Google Spreadsheet where when new responses were filled in on the form, they would automatically get textwrapped on the Form Responses sheet. Now recently I had to remake this ...
3
votes
1answer
37 views

Use a Google Form to update an existing Google Sheet

Is there a way to update an existing sheet in a Google spreadsheet using a Google form? I only see how to update to a new tab (sheet) on an existing spreadsheet.
0
votes
1answer
66 views

INDEX-formula throws random #REF!-errors due to [illogical] column value out of range

I have built a spreadsheet to help me keep track of my spending during my holidays. Whichever currency I buy in, it converts the raw amount into my local currency (Malaysian Ringgit MYR). Here is how ...
0
votes
0answers
34 views

Importrange() Error: “Results Too Large”, how to work around?

I'm trying to Importrange() from a range containing 240,000 cells (40 columns, 6000 rows). The Importrange() function is erroring out with "results too large". What are the limitations of ...
4
votes
3answers
59 views

Split a column of strings with a single formula returning an array

I have a column of strings like this: +---------+ | a bb | | ccc d | | ee ffff | +---------+ (exactly one space in each string), which I'd like to split by the space into two columns: ...
1
vote
2answers
39 views

Function name to add rows in Google Sheets

Is it possible to add rows with a built-in function (such as MIN() or INDIRECT()) in Google Sheets? I would like to fill rows in the main sheet such as +---+----+--------+ | A | 18 | Atext1 | | A | ...
3
votes
1answer
24 views

How to turn a list of months string into a list of month numbers?

I have a table with month headers at the top: January | February | March | ... Is there a way with one formula that I can get a list of month numbers? January | February | March | ... ...
2
votes
1answer
38 views

Insert current date to cell based on content in other cell

Background: I am trying to create a sheet which tracks my costs on daily basis. Instead of entering the current date everyday, I want the sheet to store the current day based on the content I enter ...
2
votes
1answer
15 views

What is the difference between the DELTA and EQ functions?

The new Google Sheets includes the DELTA function, which Compare[s] two numeric values, returning 1 if they're equal. How does this differ from the EQ? From what I can tell, the EQ function ...
3
votes
2answers
40 views

Sum a column if another column contains any of the values

I have the following data in a google spread sheet. ColumnA ColumnB ======================= Bus 205 Train 10 Train 10 Fruit 10 I want to sum all ...
0
votes
2answers
20 views

How to sort spreadsheet by date+time column but with a modified hour column?

I have a spreadsheet generated by a google webform and it produces a standard spreadsheet with a full timestamp column that is two hours behind and a hour column (hh:mm am/pm) that the user fills in ...
1
vote
1answer
13 views

Drag and drop open csv in Google Sheets

The current process for opening a csv file in Google Sheets is cumbersome. Open Google Sheets > New Document > File > Import > Upload Tab > Drag in File > Select 'Replace current sheet' Would love ...
2
votes
1answer
24 views

Google Spreadsheets: Sum values for each month

I would like to sum the values that match each month in a spreadsheet. The spreadsheet looks like this: 2015-12-10 15 2015-12-19 10 2016-01-02 15 2016-01-05 25 And I want to obtain this: ...
1
vote
2answers
15 views

Set a formula for all cells in a column

I would like to use a same formula for cells in a column. Instead of writing it for all cells, is there a way to set it in a cell and tell to apply this formula to all cells in a column (or any set of ...
3
votes
1answer
30 views

How to change cell value, looping through a provided list and record result in Google Sheets

I have built a stock tracking worksheet on Google Sheets where if I enter XYZ symbol in a cell B1, the spreadsheet will pull in Google Finance data (sometimes very slow), do a series of calculations ...
1
vote
0answers
15 views

Google Sheets - Named Ranges

I have a problem in that I am using named ranges in my G-Sheet and, although the named range is picking up the entire range, it only allows a selection down to "P" on the drop down list on the sheet. ...
0
votes
0answers
33 views

Selecting and unselecting checkbox not updating response sheet

I have a Google Form and a response spreadsheet that is updated as soon as a recipient of the form answers and submits the form. I have several different types of field ( multiple choice, grid, ...
-1
votes
0answers
16 views

Google Sheets password protection

Is there any way to password protect an entire sheet as to hide certain elements of it until i have entered a password? Or is there some script or formula anyone knows of in order to accomplish this? ...