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

learn more… | top users | synonyms (2)

0
votes
2answers
16 views

Grouping Multiple Data to Output Common Values in Google Sheets

Apologies if this has been covered before... I'm creating a Google Sheet spreadsheet to group the amount of occurrences of a particular product, based on the country that it is assigned to. Imagine ...
-2
votes
0answers
12 views

Automate calculations when adding new services [closed]

With the little knowledge I have with spreadsheets and with lots of help from Google, I've managed to create this little project management spreadsheet to help me tracking stuff and it works pretty ...
0
votes
0answers
18 views

How to reference rectangular range using IMPORTRANGE in Google Sheets

sandwich answered this question. How can I use their solution: =IMPORTRANGE("KEY"; "Sheet1!G"&B7) to import a rectangular range? I've tried =IMPORTRANGE("KEY"; "Sheet1!G"&B7":H"&B8) to ...
0
votes
0answers
18 views

Google Docs - Sheets (COUNTA also includes cells with formula)

My test sheet: https://docs.google.com/spreadsheets/d/1g3J7fumAak3ffWTiCa3vjM32zf5xEqkeuOlyDM3tffM/pubhtml I assign asset tags to a store under the "Asset Tags" worksheet. I find the asset tag that ...
0
votes
1answer
20 views

How do I add a field in Google Forms to show the sum of multiple fields (that are numbers)

Say for instance I want the user to input into 4 fields the meters they will dig up in different areas. On the form itself I would like to have a number at the bottom displaying the sum of 3 of said ...
0
votes
1answer
42 views

How to turn off Insert/Overwrite in Google Spreadsheets

When editing text in Google Spreadsheets, in the formula bar, or editing the name of the sheet, overwrite is toggled, and pressing the insert key (numberpad or 'regular' insert key, numlock active or ...
2
votes
1answer
28 views

How to use Google Spreadsheets to chart completed tasks using time series graph?

I have the following columns in Google spreadsheet Date and Completed Tasks Sample data includes May 17, 2016 3 May 18, 2016 10 May 19, 2016 9 May 20, 2016 8 May 21, 2016 9 I ...
1
vote
1answer
13 views

How to add columns if a neighbor does not exist in google sheets

I have a sheet that looks like this: estimate | actual | name 10 | 1 | Bob 20 | 9 | Sue 30 | | Bob 40 | 3 | Sue How can I get a sum of where the ...
-3
votes
1answer
29 views

Use regexmatch to determine if one cell's content contains another's

I want use a cell in regexmatch as regular_expression parameter. My goal is to draw green background for A1 if B1 contains A1 inside of it. How to do this with regexmatch?
1
vote
2answers
28 views

Combine text from multiple cells into a single cell with multiple mixed delimiters

Does anyone know a formula to combine several cells into a text in one cell with mixed delimiters between words? Cell A1 - First Name Cell B1 - Last Name Cell C1 - Job Title Cell D1 - Company I ...
-3
votes
0answers
36 views

How do I automatically populate a table in Google Sheets [duplicate]

I want to populate a table using Google Sheets. I have two tables with different data being on different sheets within my Google Sheets. Both tables have a service ID (this being my key). I want to ...
0
votes
0answers
9 views

Google Sheets Autosort without using additional sheets [duplicate]

I am looking to create a dynamic task list on Google Sheets, such that the columns are sorted alphabetically (I have put A: B: etc in front of the things I want to sort so that it can work) ...
0
votes
3answers
74 views

How do I compare the values of two columns and return the result in new columns?

EX. https://docs.google.com/spreadsheets/d/1CwFXSwIgnPdMocbrhTFZbEPRyXZUiovvWNy9MtOagxE/edit#gid=0 I wanted to compare two column "fix version" and "Affected version" and return the result bases on ...
0
votes
1answer
48 views

Query to Import HTML / XML Data Into Google Spreadsheets

I'm using Google Spreadsheets to retrieve a data table ('id=idp6855942304') from this site. The full sets of tables can be viewed by clicking on "All Reports" from the menus on the left side of the ...
2
votes
1answer
40 views

How to find URL of the current sheet

In Google Sheets, how do I create a hyperlink to this sheet? I have a sheet which I'm about to download as PDF for archive. It would be useful to include a link in the sheet, pointing to itself, so ...
2
votes
1answer
20 views

Can I protect rows in a Google Docs spreadsheet from sorting?

I can sort a Google Docs spreadsheet on any column, but that sorts ALL of the rows. I don't want to sort the rows that contain the column labels. Is there a way to protect them from being sorted? I ...
0
votes
2answers
19 views

Three nested IFs in CONCAT throwing error

So I have this formula: =CONCAT(=IF(F26 = " Kb","0",IF(F26 = "16 Kb","16",IF(F26 = "64 Kb","64")))) I'm trying to return the result "0" or "16" or "64". Three possible inputs, and three outputs. ...
1
vote
2answers
51 views

How to Determine the Xpath Query to a Datapoint in a Table for Use with IMPORTXML?

I'm looking to retrieve the most recent financial figure for a single data point from a table using IMPORTXML. The target page displays three sets of financial figures for a company on quarterly and ...
1
vote
0answers
28 views

Google Forms - Show unique ID on the form (before submitting)

I need an anonymous form (no names, emails etc) that shows unique ID so that if a person decided to reveal that ID to me I will be able to find his/her answers in the spreadsheet. The ID can show on ...
1
vote
1answer
12 views

How to use user-defined functions for custom formatting?

I’m writing a simple Google spreadsheet to list every account number which could come in handy to our non-profit in the future. Of course, one can expect some typo will get in some point in the future....
1
vote
1answer
18 views

If a string is contained in a row return return the value of the first cell of the row

I've this Google Spreadsheet: https://docs.google.com/spreadsheets/d/1-QV49oKCf58HgLBgC8gJ3gc6IXJZAo2xvh6vPTjY05o/edit?usp=sharing check the row in Sheet1 where the domain in Sheet2 is contained ...
2
votes
1answer
14 views

Autoincrement a date in a formula when dragging horizontally

I have a date in column A, and a formula in column B that references the date. I'm trying to drag the formula over to 6 more cells horizontally, representing the 7 days of the week, Column A being ...
1
vote
1answer
26 views

How do I copy data if cell contains text?

Basically, I have a book which gets data anytime someone fills a form. There are five groups I need the data divided into. If a cell contains one of the five answers all the answers by user need to ...
1
vote
2answers
34 views

JavaScript To Dynamically & Daily Select The Next Worksheet In An Open Google Sheets File

At work using Chrome, I have a Google Sheets file saved on my Google Drive folder that's shared with me with edit privileges that I keep open on my MacBook Pro. After I've originally opened the file ...
3
votes
2answers
32 views

Conditional format for column headers where all cells are numbers

I'm trying to color the header if all of the cells in that column are numbers. Blank or non-numbers should break this. I have: custom formula: =ISNUMBER(A3:A) But it styles the cells instead. Not ...
2
votes
2answers
33 views

Organize employee time log into a table with a row for each employee

I want to get all the Timestamp of an employee (EmpID) from one sheet to another using Google apps script or otherwise. Explanation In Google Sheets, Sheet1 has the following items in 3 columns | ...
0
votes
0answers
14 views

Conditional format — copy format of another cell (Google Sheets)

I'm using Google Sheets spreadsheet, hope it's ok to ask about it here (in superuser). Chances are the methods to accomplish this might be different from Excel or LibreOffice, if it can be done at all....
6
votes
1answer
72 views

How to open a Google Sheets file and go immediately to the end of the file

I have a Google Spreadsheet with 100 lines. Every time I open that file, I want to insert a row on the end of my table. How can I jump to the last line of the table when I open the doc? Because ...
0
votes
0answers
5 views

Google sheets: Automatically including new rows on separate sheet

I have a google sheet document with two separate sheets, Sheet1 and Sheet2. I want column A on both sheets to stay the same. Column A of S2 simply has ='Sheet1'!A2 for cells A2 on down. Let's call ...
2
votes
1answer
33 views

Different bar types based on column value

Instead of having one column for each new "type" below, is there any way to achieve the same result using the non highlighted cells in the image below? To elaborate, I would like different bar types ...
0
votes
0answers
12 views

Add days of the month to a chart [duplicate]

I have 2 columns, a boolean value (nok/ok) and a date. I am tracking in which particular date I have completed a study module(s). When I add a chart to show the progress through time, the chart shows ...
1
vote
0answers
15 views

Pasting multiple formulas at once

I have a column of formulas (each created by concatenating several parts of a formula in cells to the left of it on each row), I want to be able to copy and paste these into a new sheet, whilst ...
0
votes
0answers
11 views

How to format cell if date is 7 days past the date listed in cell [duplicate]

I'm trying to keep track of regular due dates based on the last time the task was completed. Example: I have a task that needs to be completed about once every month. In column B I'm inputting the ...
0
votes
0answers
22 views

One form submit produces two updates to spreadsheet

I have an application in which a user submits a form, the data are logged in a spreadsheet, the form submit triggers a script that records the new data and deletes any previous form responses from ...
1
vote
1answer
24 views

Combining columns horizontally with an arrayformula

I need to join columns with a formula (not a script) in Google Sheets in a different way than others I've found--here is my original data, supposing that the Avengers train by playing racquetball: ...
3
votes
1answer
100 views

Using Google Spreasheet's IMPORTXML Function to Download Selected Multiple Columns

I use Excel's XML mapping to download RSS feeds and select elements to display in column. I'm currently using Google Spreadsheet's IMPORTXML functions and trying to recreate my below Excel results. ...
1
vote
1answer
35 views

Hide row if cell contains specific text

I am trying to hide a row when a cell is filled with "x". I have tried using scripts but they don't work. So there are "A", "B" and "C" filled in column F. I want the script to hide rows where "A" ...
0
votes
1answer
19 views

Hide a row of cell when a specific cell is filled

I am trying to hide a row of cell when a specific cell is filled in on Google Sheets For example: On row 2 cell E2 is filled in with "1", I want to be able to hide the entire second row. Is there ...
0
votes
0answers
10 views

Google Spreadsheets: add hours to date problem

I've encountered some kind of strange problem with Google spreadsheets. I've 2 cells, in one I've date, lets say its 10/10/2010, in 2nd one is hour, 12:00:00. I get those from input cells, but when I ...
3
votes
1answer
56 views

Unable to parse query string for function Query, when using ImportRange

This is the problem I'm getting: Error - Unable to parse query string for function QUERY parameter 2: NO_COLUMND The formula is of the form =query(importange("...", "Sheet!A:V"), "select D ...
3
votes
1answer
27 views

Using cell value to define sheet reference, e.g.: “=A1!B2”

I have data across different sheets in my Google Spreadsheet, called "data(Joe)", "data(John)", etc. From another spreadsheet I want to review that data in a structured way. I would like to be able to ...
2
votes
1answer
21 views

Lock two Google Sheet cells to each other

Is there any way to lock two Google Sheet cells to each other? What I need: I have data in cells A1 , B1 ; A2 , B2 , ... A1-B2 / A2-B2 must be adjacent. I need to sometimes copy A1-B1 to different ...
0
votes
2answers
46 views

How to sum cells in Google sheets that contain numbers and text

This has already been addressed in Excel but I was wondering how to do the same in Google Sheets. So suppose the B cell has this formula: ="frontend (days) total: "&sum(B2,B10,B14,B20) and the ...
0
votes
1answer
27 views

Sync multiple cells so that if any one of them is changed, the others change as well

I have 4 hard coded cells on 4 different sheets (within a google sheet file) that I'd like to keep synced. If any of those four cells have been changed, I'd like the other three cells to be updated to ...
3
votes
0answers
15 views

Populate column with editable range based on drop-down

So, here's my issue. I've got three sheets. One sheet has all of the classes for Mondays and Wednesdays, one sheet has all the classes for Tuesdays and Thursdays. The third sheet has a drop-down menu ...
3
votes
1answer
42 views

Import only those cells from a spreedsheet that have certain conditional formatting

I have created a Google form which links to a spreadsheet. There is an option which asks for the person's name. For the answers in the sheet, I've created a conditional formatting which highlights the ...
1
vote
1answer
22 views

Align the rows of one sheet with the rows of an imported sheet

I have a spreadsheet of employee names. I am using =IMPORTRANGE() to import the names into another spreadsheet that tracks expenses in rows next each of the imported employee names. The problem is ...
4
votes
1answer
29 views

How many spreadsheets are stored in my Google Drive?

A Google survey asked me: About how many spreadsheets are stored in your Google Drive? I ended up guessing, because I couldn't find a way to find the real number. In Google Drive interface, ...
0
votes
0answers
22 views

IMPORTDATA() with Google Sheets

I am trying to use the IMPORTDATA() function on Google Sheets. Initially I tried downloading yahoo finance data, which didn't work. However, I cannot seem to get the function to work even using ...
0
votes
0answers
27 views

Is it possible to link an Excel document to a Google Sheet?

I have an Excel file that needs to be updated weekly, but I also have a clone on Google Sheets that needs to have identical changes done each week as well. I currently am trying to use the =...