Questions tagged [google-sheets]

For questions about the Google's web application to create and edit spreadsheets on a web browser. Don't use it for the Google Drive Excel files editor. Please consider adding a demo spreadsheet to your question, this will greatly increase the chances to get a satisfactory answer.

Filter by
Sorted by
Tagged with
4
votes
1answer
1k views

Programmatically create an internal hyperlink

I need to programmatically create a large number of links in a Google Sheets that point to a specific range in another sheet of the same document. I tried to use named ranges for that but for the ...
1
vote
2answers
1k views

Conditional Formatting based on other column

I have a timesheet log with columns DATE | HOURS | DESCRIPTION OF WORK | PROJECT An employee may enter several rows for the same date to log the different amount of time with respect to the ...
1
vote
2answers
34 views

When any username on a sheet matches a username on another sheet, copy over certain values into specific columns

I have a sheet with current users of a system (only by username) and I have another sheet that is a master list of username associated with employee first name, last name, and employment status. What ...
0
votes
1answer
2k views

How to insert Mathematical Equations in Google Sheets?

I have been searching for a while now and all searches lead to Google Docs, not Google Sheets. So basically what I'm looking for is similar to the insert equation function as in Excel where you can ...
1
vote
1answer
29 views

How can I navigate inside a spreadsheet cell immediately after typing text?

This seems like it's a blindingly simple question with an obvious answer yet I cannot figure out how to do it nor find solutions online. If I type some text into a Google Sheets spreadsheet cell and ...
0
votes
1answer
532 views

How to navigate to a certain sheet in Google Sheets?

In my previous related question, I asked how to navigate to a certain column, however, now I also want to navigate to a certain sheet. So I need a link from a cell, and by clicking it, I want to jump ...
0
votes
1answer
13 views

Can I navigate from a pivot table back to the original database?

Once I am "in" a pivot sheet, is there an easy way to click on a row or cell in the Pivot table and navigate directly back to the related data in the original database (Google Sheet), from which the ...
0
votes
1answer
771 views

In Google Sheets, Enter key moves selection [duplicate]

In Google Sheets, pressing the Enter key moves the cursor down a cell. For example: position cursor on the cell type to enter text press Enter key Expect: Cursor stays on the cell I was just ...
0
votes
0answers
8 views

New solution to identify BY as a column label instead of an identifier?

I'm new to this, so I've posted this question as an "answer" to this post QUERY error for BY column a previous solution for this issue no longer works, and I need a new way to tell google (via code) ...
2
votes
2answers
2k views

How to change the values of a pie chart to absolute values instead of percentages in Google Sheets

I want to be able to change the percentages under each of the fruit names to absolute numbers (the respective quantities). I tried changing the 'slice label' but that only added the numbers over the ...
0
votes
2answers
16 views

How can I make a formula ignore a blank cell in Google sheets

I am creating a budget template and have a formula that multiplies cells. However, not every cell will have a number in it. How do I make it so the formula will ignore blank cells or make them = 1 ...
0
votes
1answer
362 views

QUERY remove column and column header if blank

The attached document is a time-sheet document. There are 2 tabs, TimesheetData and InvoiceData. I want to pull through data from TimesheetData tab to the InvoiceData tab using a query. The query I ...
3
votes
2answers
558 views

Why is a blank string greater than 0 in Google Spreadsheets?

Why does ="" > 0 Evaluate to TRUE? And how can I input a value that would evaluate to FALSE that is not a number?
1
vote
1answer
16 views

Google Sheets time sorting chart

I have a MailChimp data export in google sheets and I want to create some charts that can show the best time of day/day of the week based on my data for our mail outs when compared to open rate (%). I ...
0
votes
1answer
20 views

How to transfer a cell value to another cell by pressing a button

I want to be able to click a button and the value of one cell gets transferred to another cell, and the new cell adds them up. example: If I put 5 in B6 then click the button, C5 should update to 5 ...
1
vote
2answers
3k views

Sorting alphabetically (A-Z) ignoring beginning “A”, “An” and “The” using a script

I have a Movie list using Google Sheets that I would like do some sorting with using a script rather than a formula. Column A is the movie Title. I would like to be able to sort the movie titles ...
0
votes
0answers
4 views

Increase line spacing in Google Sheets [duplicate]

I am using Google Sheets and want to change the line spacing of text within a cell. cannot seem to find any information on this.
0
votes
0answers
20 views

Google Sheets - Historical Data not returning yesterday

The formula below is been used to get the historical data until today: =GOOGLEFINANCE("GOOG","ALL",DATE(YEAR(TODAY())-1,1,1),"12/05/2019","DAILY") Unfortunately I don't receive today's data (until ...
0
votes
1answer
56 views

Count unique tags

I’m trying to list and count all tags in my table. For some reason, anything after comma, is getting a white space before the word. So if the tag is found on the beginning of a record, it is seen as ...
0
votes
1answer
41 views

Conditional Formatting based on another sheet, tying a value to a colour, Google Sheets

Does anyone know how I'd be able to make a specific value always appear with the same formatting & colour in my sheet, based on another tab in the sheet? The spreadsheet I'm trying to do this on ...
0
votes
1answer
551 views

Google Sheets intersection query

I'm trying to write an intersection query in Google Sheets that lists all the rows in sheet 1 that contain a cell in sheet 1, column A, that matches at least one cell in sheet 2, column P This is the ...
2
votes
1answer
908 views

Put the timestamp of last edit on master sheet, next to edited sheet's name

I'm trying to come up with a script that will print a timestamp of the last edit made to a specific tab within a google sheet. Imagine you have 17 retail stores, each one having its own tab with a set ...
-1
votes
0answers
11 views

12 Week Scheduled Contact Sheet

I'm trying to create a sheet that will have data imported from Zen Planner through webhooks. The data will be for new students at a martial arts academy. There are 5 of us that will be working in ...
1
vote
1answer
32 views

How can I change the formula of one cell based on the value in a different cell?

COLUMN D: Dropdown list of values COLUMN E: IF function returning different values depending on COLUMN D contents I have the functionality described above working properly. My problem is that I want ...
0
votes
1answer
131 views

Absolute References [duplicate]

I've been looking for answers to my need, but seem to keep finding answers to the opposite problem. Here is my challenge. I have a google sheet to process payroll. On the first tab is data ...
0
votes
1answer
54 views

Create named Versions of Google Sheets (or other documents) automatically on a schedule

I'm trying to create named versions of a file on a schedule, say once per week. Refer here for an example. The named version should be something like the file name + date so that it can be ...
-1
votes
0answers
8 views

ctrl-v sometimes triggering the copy/paste warning in Google Sheets

Curious if anyone else is experiencing this. I am using google sheets in Firefox 70 on Ubuntu 18.04, and some times using ctrl-v brings up the copy/paste popup warning instead of pasting as expected. ...
0
votes
1answer
43 views

How to open Google docs in new tab in Firefox

When I click a Gdrive item in Firefox it always opens in the current tab. How do I get it to open in another tab. When I click on any other URL it opens in a new tab why not Google docs? In Chrome ...
1
vote
2answers
551 views

Import Bitcoin price in EUR using the IMPORTXML fucntion

Hello does anybody know how to import the Bitcoin price in euro into a Google Sheets document by using the IMPORTXML function? I am as far as I get the Bitcoin USD price - =IMPORTXML("https://...
3
votes
4answers
8k views

Google Sheets – copy and paste a cell's value while preserving a hyperlink

I'm working with exported data that I've pulled into Google Sheets. I have a column with URLs and a corresponding column with text labels. I can combine the two into a hyperlinked cell using a forumla:...
17
votes
4answers
12k views

Is it possible to have plain text and a link in the same cell?

I've got a document that's convenient to keep in a spreadsheet because of calculations, but I also have a significant amount of text that I'd like to keep in the same place. Some of that text involves ...
-1
votes
0answers
14 views

Test cells to fill in others from separate sheets

I know there’s a way I just can’t process it completely right now. Can someone help me process this: I’m wanting to have cells multiple automatically populate from other sheet depending on one cell ...
0
votes
1answer
13 views

How to get data from a different sheet based one the adjacent sheet in Google Sheets?

How would I change the sheet name in B3 when the name is changed in A3? Could someone please assist me with this?
0
votes
1answer
23 views

Google Sheets - If cell contains text that matches text from a column, return another cell

https://docs.google.com/spreadsheets/d/1GG7ekrD6CxxpowrRDm9DMvv3xHdvtAa8MHYCk4gI4D4/copy 1) If D10 (or I10 or N10) matches an exercise from the corresponding column to the right, return another cell (...
0
votes
0answers
14 views

Concatenate multiple columns automatically [duplicate]

I have three columns A B C D E F G H I I want to write a formula such that it will combine the three columns, one on top of the other such that my fourth column is: A ...
0
votes
0answers
11 views

Sending edit logs from multiple Google sheet files to one “edits log” spreadsheet

I'm creating a large amount of spreadsheets in google drive, and i would like to monitor/log the changes in a single spreadsheet(eg; file/date/time/user) My goal would be to track how often and who is ...
1
vote
2answers
92 views

Querying if cells exist in an external Google Drive file

I have a huge list of names stored in Google Drive as a TXT file (constantly updated externally). Can I put a small list of names in a Google Sheet and see if any of them exist in the big external ...
4
votes
1answer
5k views

Duplicate and rename sheet in one action on Google Sheets

I have a script which references the name of a sheet in Google Spreadsheets. When I duplicate a sheet with a cell that uses that function, the function is called right away and returns something like ...
1
vote
1answer
759 views

How can I prevent editors from accessing the script editor in Google Sheets?

I have an auto sort script on a Sheets document that I will be giving multiple people editing permission to, to add to the file. I have created a trigger so the script also runs when other users edit ...
0
votes
1answer
15 views

Multiple Unique Values Across Worksheets in Google Sheets

I rarely use spreadsheets, but I thought creating a workbook for a contest would be really helpful. I am not sure if what I am asking is possible without a custom function. I am grateful for any and ...
1
vote
1answer
11 views

How to access the “unformatted” date in Google Sheets?

I am working with a spreadsheet that includes a row where each cell contains the date of the first day in each month in a series of years: 1-Jan-18, 1-Feb-18, 1-Mar-18, ... , 1-Dec-18, 1-Jan-19, 1-Feb-...
1
vote
1answer
18 views

Conditional Formatting Duplicate Invoices in Google Sheets

My workplace uses Google Sheets to track invoices across all locations. The two most important columns are next to each other and titled Invoice number and Vendor. I wanted to highlight the Invoice ...
1
vote
2answers
2k views

QUERY error for BY column

I'm using the following query to pull data from one sheet into another. =query(data!B2:CL,"select B, C, D, E, F, G, H, I, J, BB, BZ, CA, BA where J = 'Industry Certification'",false) The above query ...
0
votes
1answer
23 views

Import and SUM chosen (from drop-down) column to Sheet1 from Sheet2

What formula I can use in cell C2 to import one column from sheet 2 using a drop-down list? Here's the document.
0
votes
2answers
31 views

How do I find out what is slowing down google sheets?

I have a multitab google sheet that now and then slows to a crawl. The progress ribbon takes several passes to before it quits. At times the progress ribbon stops entirely for minutes at a time. This ...
1
vote
3answers
21k views

Does Google Sheets/Docs have a desktop client?

Other web apps like Trello and Airtable have desktop versions of the app via electron.js. Is there a similar solution (provided by Google or 3rd party) for Google Sheets or any other G suite apps?
2
votes
1answer
6k views

Delete multiple sheet tabs in Google Sheets

In a Google Sheets spreadsheet (Excel terminology = workbook) is it possible to delete multiple tabs (Excel terminology = worksheet) in one go without having to right click each one and delete it.
0
votes
1answer
186 views

Max value conditional formatting rule not working in Google Sheets

I want the max value in Column B to show up. I put in this formula but it's not working. What am I doing wrong? Here is the table
0
votes
1answer
37 views

Generating a list in Google sheets with checkmark filters

I've been wracking my head over this for a few days now, basically I tried to use a index/match/if/countif setup to try to get a unique list generated based on filters made by checkboxes. (not ...
-1
votes
1answer
5 views

IF THEN Google Sheets - referencing different workbook

I'm hoping to do the following: Spreadsheet 1, cell A1: pull in data from cell A1 in Spreadsheet 2, but ONLY if cell B1 contains exact text of "partner". Is this possible?