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

learn more… | top users | synonyms (2)

2
votes
0answers
15 views

Coordinates of an external named reference

In a spreadsheet, I've got a column named range: Sheet1!I:I, named NamedRanged1. In another sheet, I'd like to get the index of that named range, i.e., 9 (I is 9th column). I tried with ADDRESS and ...
4
votes
0answers
37 views

Copying data to *and from* another sheet based on the month of a date

This is a follow-up to Copying data to another sheet based on the month of a date, with a different requirement: instead of one-way data transfer (from Master sheet to others), two-directional ...
0
votes
0answers
25 views

How do I print a Google Docs document directly from Firefox?

Using Google Docs/Spreadsheet. If I open a Google Doc and select print (either via the menu, ctrl+p, or toolbar icon) from within Chrome or Opera it then opens a print preview screen where I can ...
6
votes
2answers
45 views

How to use formula values present in another cell in a formula

I am using the formula from this question =ArrayFormula(sum(sumif(A:A,{"Bus";"Train"},B:B))) I am planning to use it for multiple categories. For example the above can a sum of my travel category ...
3
votes
1answer
20 views

Copying a cell with partial formatting of text

I have a cell in Google Sheets with formatted text content. Something like this: You must complete both parts of the assignment. If I copy that cell into another cell, the bold formatting is ...
4
votes
1answer
28 views

Copying data to another sheet based on the month of a date

I hope someone can assist me in looking in the right direction. I have a sheet (Master) which has rows of data regarding different types of projects and deliverables. One column in this sheet has ...
7
votes
3answers
288 views

How to include multiple IF statements in one cell in Google sheets

I am attempting to change the value of a cell in Google Sheets based on the value of an adjacent cell. This adjacent cell gets its value from the colour of the cell adjacent to it using the formula ...
3
votes
2answers
41 views

Coloring cells according to the value to which its content is closest

I am trying to make a guide for my dragons on a game I play but I'm not quite sure how to code what I am trying to do. Link ex. if has values "Guardian"(C2:C100) and "Dragoness"(I2:I100) in its row ...
3
votes
1answer
25 views

Is it possible to 'reset' the value of a cell in one sheet from another sheet?

I have two separate google sheets (GlobalReport & IndividualReport). Both share information between each-other, but I need to be able to "reset" a cell value in the IndividualReport sheet. Cell ...
2
votes
1answer
68 views

Is there a way to have a Slack overlay in Google Sheets?

Google Sheets lets you chat with other people actively using the sheet, but it has no history and overall feels like the simplest thing that could work. Slack, by contrast, seems like everything you ...
2
votes
0answers
11 views

Avoid redundancy in formula in Google Sheet [duplicate]

Say I have a long expression (i.e. with a lot of characters) expr. I want to give a cell the formula =if(expr>10,expr,0) (this is an example, the condition could also be =if(iserror(expr),expr,0)). ...
2
votes
0answers
30 views

Google Sheets <copy Data from one spreadsheet to another>

Could you help me to understand how to made next couple: Table M Table 1 Name -> Name Qty <- Qty Table M has original field Name, Table 1 takes this name and ...
2
votes
1answer
23 views

Google Sheets Conditional Formating “IsEqualTo” value in referenced cell

What do I add to the text field directly below the "is equal to" selection if I want the test to be the value of a specific cell? I want the condition to pass and format a cell "IF" it is equal to ...
2
votes
2answers
60 views

Lock the formula of a cell, even if the cells it references change

I have this, in D1: =sum(D3:D) I want D1 to always be the sum of the rest of column D (D2 is a header) I sometimes move a row, from eg 8 to 3, and that causes D1 to change to sum(d4:d). I want ...
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
30 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
20 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
27 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
39 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
15 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
30 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
20 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
14 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
61 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
28 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
28 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
39 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
42 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
46 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
41 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
28 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
28 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
71 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
58 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
45 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
57 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
36 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
41 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
80 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
39 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 ...