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

learn more… | top users | synonyms (2)

0
votes
1answer
27 views

Copy and paste information once a day form a Google spreadsheet

I have a Google spreadsheet that is being modified during the day, and need to copy and paste the final information (at 8 pm) in a different tab, each day, pasting the new information under the old ...
0
votes
1answer
38 views

Can I cut and paste projects from a Google sheet using a script?

I want an automated method of cutting and pasting completed projects from one sheet to another sheet. I want to have a column where users can go in and type "DONE" at the end of a row to state that ...
1
vote
2answers
26 views

Create an OR conditional statement from a list of options

I want this: input in A1 and output in A2. input: 0 output: AND (A=0) input: 0,1 output: AND (A=0 OR A=1) input: 0,1,2 output: AND (A=0 OR A=1 OR A=2) etc... I've tried a few things with the REPT ...
1
vote
0answers
16 views

Sum the same cell in a range of sheets [duplicate]

I have an Excel spreadsheet that has this formula: =IF(ISBLANK(B6),"",SUM(Sheet1:Sheet10!O6)+Sheet11!P6+Sheet12!T6) I would like to use this spreadsheet in Google Sheets so I can get it on other ...
1
vote
1answer
26 views

How can I force a Google Spreadsheet to have column in one tab have the same width as the same column in a different tab?

Is there any way to force a Google Spreadsheet to have column i in tab j of same width as column i in tab k? In other words, can I configure Google Spreadsheet so that a column width change is always ...
1
vote
1answer
22 views

Time stamp on last row of column for changes in predetermined range

I am looking for a way to add a time stamp to the last row of a column of figures any time there is a change in the above range. I have been able to find a number of examples where you can timestamp ...
1
vote
1answer
20 views

Finding task with highest date

I have this sheet where I want to do simple project planning and resource booking The columns 6-17 show week numbers and each main objective within a project has a start week and end week - no actual ...
0
votes
1answer
14 views

Google sheets, how to grab a html link from a table

http://www.nasdaq.com/markets/ipos/activity.aspx?tab=upcoming under each of the company name is a html link to another page. How do I import that html link into Google sheets?
2
votes
2answers
26 views

How to recombine text into one line in Google Sheets

=index(ImportXml("https://www.google.com/finance?q=ibm", "//div[@class = 'companySummary']" ),0,1) Put that anywhere in a Google sheet and it will give you a cell with a block of text. This text is ...
2
votes
0answers
22 views

Map Chart using decimal degrees in Google Sheets

I have a column with decimal degrees (locations) and another one with values. Can I plot a Map Chart on Google Sheets (with markers)? If I have to use the Script Editor, any existing (working) ...
1
vote
1answer
30 views

How to convert text of the form Month-Year to date format?

How do I convert the text "Oct-14" to date, so that it's being read as "Oct 01, 2014. I tried to go to Format > Date and selected the format: Oct-2014, but google sheets is interpreting it as "Oct 14, ...
1
vote
2answers
140 views

How to calculate the percentage of a date in the same year in a Google Spreadsheet

Given a date, I need to calculate the percentage of its position in the year. So that 31-12-2015 would return 1 or 100%, because it's the 365th day of 365 days in that year. And 1-1-2015 would return ...
1
vote
1answer
20 views

Remove any sheets not listed in an array

I have a Google App Script that has 6 sheets. onOpen, I would like to see if the user created any additional sheets, and if so, delete them. So far, I have: function onOpen(){ var ...
0
votes
2answers
59 views

Which factor will give most speedup to every update to a large Google Spreadsheet?

I have a huge spreadsheet in Google Spreadsheets, and it takes about half a minute to complete every change I make to its contents: UI stays responsive, but there's a slow progress bar showing the ...
0
votes
1answer
18 views

Count number of times a term appears in an array of lists

I have a question the count function. Lets say a have a single column of data coming in from a google form. Its going to have 3 data inputs coming in from each response of the form. The possible ...
1
vote
1answer
28 views

How to get most frequent terms from a set of lists?

I have a list on Google Spreadsheets. Each line is a mission, and one of the columns indicates who I've worked together on the mission (which is between 1 and 3 people). The format is "Aquaman, ...
0
votes
0answers
23 views

How to jump to a certain sheet when I click the hyperlink in Google Spreadsheets

How to prevent the hyperlink creating a new tab when opened? Is there a way for the hyperlink to 'replace' the current page - rather than open a new tab?
3
votes
1answer
56 views

How can I create a checklist in Google Keep from a Google Sheets spreadsheet?

I exported my list of books I own from Shelfari, and want to create checklists in Keep for certain authors that will make it easier to browse second hand stores and not buy things I already have. I ...
0
votes
2answers
48 views

Date format in Google Sheets

I have a Google spreadsheet file and I need to convert the date column from this format: Sun, May 4, 2014 4:30PM to this format: mm/dd/yyyy. Basically, I need the date to be in a simple format and ...
2
votes
1answer
27 views

How to list which values from field A don't appear in field B? (Survey recipient responses)

I have a weekly survey I send out to the same list of people using Google Forms, and they populate a 'responses' spreadsheet. I delete the responses weekly, and new rows are added as new responses are ...
3
votes
1answer
44 views

How do I create a data validation function to print the values of a specified column across all pages?

I have a specific task that I believe might require some kind of custom script. Here is (a copy) of the spreadsheet in question: ...
3
votes
2answers
53 views

Having trouble getting rating sheet to update as games are entered

I keep a spreadsheet that uses the elo equation for chess where I work that updates players ratings when I enter the two players names and who won or lost (1 for win, 0 for loss). My issue is that it ...
2
votes
1answer
99 views

Getting COUNTIFS to work in complicated Google Sheets formula

I'm having trouble with COUNTIFS on Google Sheets. I've been able to use SUMIFS and now I need to use COUNTIFS. I tried to do a Find and Replace, changing SUMIFS to COUNTIFS, on what I thought were ...
3
votes
0answers
76 views

IFTTT to Google Drive (Sheets) - How to write on the same row?

I'm looking for a way to get a recipe from IFTTT to Google drive (sheets) in the same row. The recipe writes in the first 3 columns, but if there is anything already in the same row it skips that row ...
1
vote
1answer
48 views

Restricted view of a sheet, with each person seeing only their rows

I created a Google Spreadsheet. Column B contains the name of my employees. In Column C there is a task for every employee. Different employees need to have access to this document, but I prefer my ...
2
votes
1answer
50 views

IMPORTHTML at a certain time of day in Google Spreadsheets

I am looking for a way to import the table from this formula once per day at a certain time instead of automatically updating as the formulas seems to do. I need to do this in order to track certain ...
2
votes
0answers
16 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 ...
5
votes
1answer
72 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 ...
1
vote
0answers
75 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
61 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
23 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
49 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
615 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
63 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 ...
4
votes
1answer
46 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
97 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
39 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 ...
3
votes
1answer
35 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
69 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
33 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
41 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
32 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
168 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
25 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
102 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
36 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
54 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
26 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 ...