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
0
votes
2answers
22 views

Copy other cells if EITHER column has specific text

In a single sheet wanting to copy D3:N if either B3:B or C3:C = S2. I'm sure there is a simple formula to do this I am just unable to find it!
0
votes
1answer
12 views

How to modify my formula to take 1 hour off?

E6 = Finish Time. B6 = Start Time. My working formula: =E6-B6+(E6<B6) =Time worked in Hours/Minutes How should I modify my formula to "minus 1 Hour" for a break? Sounds easy, but I can't get ...
0
votes
0answers
14 views

Why is not possible to activate an event only at single cell change in google sheet?

Why is not possible to activate an event only at single cell change in google sheet? It would be very usefull. Are there a way or the only possibility is to check the cells you want to control on a ...
0
votes
0answers
23 views

Google Sheets CSV Download Loses Data from Other Worksheets

I'm trying to save a single sheet in Google Sheets to a CSV. In my example it's historical stock quotes formatted for Quicken import. All of the "work" is done in other sheets - specifying date ...
0
votes
1answer
46 views

Timestamp format with carriage return

I have this time stamp format: var timestamp_format = "yyyy-MM-dd HH:mm:ss"; Which produced a result like: 5/25/2019 10:52:43 but I would like to have a carriage return between the date and time ...
0
votes
2answers
20 views

Importing data found to be true from one Google sheet to another

I am trying to find a way to import data (text) from one sheet to another, via the same book. I assume it's going to need an IF or IFS formula because I only want data is that found to be "TRUE" (via ...
0
votes
0answers
15 views

Google sheets does not label one of my ponrts on my scatter plot

I don't know what to do. I have my data in a graph and all points are labeled apart from one. How can I fix that?
0
votes
1answer
1k views

Pivot Table Filters - Custom Formula

In my pivot table, I want to only display the entries in the column "Which Event" if the name contains "Baseball" or "Softball". I can very easily do part of this by adding a filter for the field "...
0
votes
0answers
57 views

Google sheet printing problem

I have my language set to English but whenever I am about to print, it changes to another language. I have tried this several times, but it's not changing; it keeps printing in the other language even ...
0
votes
2answers
38 views

Google Sheet use filters to sort with Unique

In google sheet, I have a data set A: In another sheet I am creating a dynamic list using the UNIQUE formula: However, when I use filters to sort the data, it gets all scattered leaving empty cells ...
0
votes
1answer
29 views

Conditional formatting formulas in Google Sheets

I want to use Conditional formatting so all of the cells in column A change colors whenever the matching cells in column B have the word "later". ex: If cell B20 contains "later", then I want A20 to ...
0
votes
1answer
40 views

Google Sheets Pivot Table, Summary by Day

I have a sheet with 2500 dates & times of when customers have placed their order. I want to do a heatmap or a bar graph to show which days of the week are the busiest. I rounded the exact times ...
0
votes
1answer
16 views

Changing cells formatting based on another cells date

I've been looking and can't quite find the answer I'm looking for. I have a spreadsheet with columns Monday through Saturday with data lining up underneath. I would like the current day to highlight ...
0
votes
0answers
24 views

Google sheets sub-chart in chart… possible?

I have 3 different data ranges that I need to plot on a google sheets chart. On the main chart I have different value ranges, thus I'll use a left y-axis and a right y-axis, but the 3rd data range is ...
0
votes
1answer
28 views

1 plot with several lines with a common X axis but unique X and Y values… is this possible?

I am trying to create a graph which shows several smooth lines that are defined by an X and Y value. the problem is that they have to share the X-axis. Is there a way to efficiently add the other ...
0
votes
1answer
13 views

How to change cell range without deleting it?

In a function, let's say the SUM function, I have a range H25:H37 I want to change this range to H23:H40 using the mouse. The only way I could find is to delete the initial value, then I can drag the ...
0
votes
1answer
44 views

How do I get responses in Google Forms to automatically be updated when updating the spreadsheet?

I'm in a situation, where I have been given a source of information, with all sorts of people. And with that, I wish to insert all this inside of Google Forms, in the response section. And so I was ...
0
votes
1answer
49 views

Funny alignment in Google spreadsheet

This is driving me crazy. I have searched the web for an answer, without success. All results are simple pointers on how to use the formatting on the sheets. This misalignment seems to be something ...
0
votes
2answers
1k views

How to use IMPORTRANGE when I have multiple tabs?

I have to export some data from a Sheet with 30 tabs(a tab for each day of the months) and I have to extract data under specific criteria from all the sheets which have to be done every month on a new ...
0
votes
1answer
27 views

Query Function Not Putting Consolidated Data in the Right Place

So I don't know how to explain this completely, but basically, I'm using the query function to consolidate data from multiple sheets into one Master Sheet. The function itself seems to be working fine ...
0
votes
1answer
256 views

Sending pdf with Google sheet email

Trying to send a pdf attachment to an email using Google sheets. I have checked and tried to use the replies in previous responses but my code fails after sending the first email. This is the code I ...
0
votes
1answer
425 views

Check if value exists before copy-paste

Can someone help please as I am new to Google Scripts. I have this simple code that copies values from one sheet to another function copyrevision() { var ss = SpreadsheetApp.getActiveSpreadsheet ()...
0
votes
0answers
3k views

Change default zoom on a Google Sheet?

I use a shared Google sheet to display apparatus issues for a fire department. This is displayed on a tv using an Asus Chromebit. Every time someone logs into the sheet it resets the zoom to 100% ...
0
votes
1answer
27 views

Joining Two Working Formula's

I have the following working formula Located in K2 =IF(INDEX(Details!B18:B81,MATCH(C2,C2,0))<>C2,S30,"0") So I want it to only use the number in S30 if the date in C2 is not in a range of dates ...
0
votes
1answer
20 views

How to pull data from a random cell on page load in Google Sheets?

Basically, I'm just trying to figure out how to make a cell pull a random cell's value within a range at random when the page loads. For example, have cell A1 pull a cell at random from range B1:B20 ...
0
votes
1answer
43 views

Filter column based in other column (using query prefer)

I am trying to make a filter with a query based in a column, but I cannot make it works. https://docs.google.com/spreadsheets/d/1zKMW8vuyHRpS8eVEmRgAOg_dBQ0r2OIXnqV3_TFEm9o/edit?usp=sharing This is ...
0
votes
1answer
261 views

Get the name and link file based on Folder ID

I created a script to get the name and link file based on Folder ID. The file name and link are displayed on sheet 'Get_Link'. File spreadsheet The script that I wrote like this: function ...
0
votes
1answer
368 views

Running script to replace “null” with nothing in Google Sheets

I tried to do this through a macro but I'm unable to have it actually record. I'm not a coder so I've been recording macros and using the code from there to create an add on. I need a script that can ...
0
votes
1answer
2k 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
18 views

Build a value-over-time line chart from monthly values?

I have a spreadsheet that looks like this: +---------------------------------------+ | |01|02|03|04|05|06|07|08|09|10|11|12| +---------------------------------------+ |'16| ?| ?| ?| 1| 2| ?| ?| ?| ...
0
votes
2answers
30 views

Add columns based on rows

I'm currently working on setting up a sheet, but I want to add columns in one worksheet based on rows in another worksheet. I have no idea if this is even possible, I've tried googling it. Might be ...
0
votes
1answer
44 views

Repeatable questions

I'm trying to create a daily personnel report. Each manager needs to report who their personnel are, whether they are Present, Sick, On Leave, etc, and where they are. I then plan on having a set of ...
0
votes
2answers
244 views

Google Forms Duplicating answers to Google Sheets

I have a google form to capture order information, When the user captured all order information, it pushes to a google sheet so we can keep an order history of who ordered what, when and how much. ...
0
votes
2answers
228 views

IF Function with too many arguments

I want to apply this formula =IF(A2= "", "", IF(REGEXMATCH(A2, "Brand"), "Brand", if(regexmatch(A2, "Loans"), "Loans" , if(regexmatch(A2, "Cards"), "Credit Cards", if(A2, "Generic"),"Generic",...
0
votes
2answers
213 views

Google Sheets API call creates scientific numbers that I cannot then run calculations on

I am using API in Google Sheets to call prices of cryptocurrencies vrs Bitcoin from URL: https://api.coinpaprika.com/v1/tickers?quotes=BTC In some cases I am getting scientific notation instead of ...
0
votes
1answer
623 views

Increment number in array formula based on a condition

I have a data set with Sub-Total rows at various intervals. As the data can have rows inserted or deleted, I am trying to use an array formula to give each group of data an incremented integer as a ...
0
votes
2answers
354 views

Using a checkbox to auto-populate a row on another sheet

I have this spreadsheet which is used for receiving and recording work. SST responses sheet is where people submit requests, Workload is where we record all work. I'm wanting it so that when someone ...
0
votes
2answers
7 views

Look for a value that might be in many columns

Say I have a value in $A, to match to another sheet of the same file. That value (in this case, a student id) might appear in many columns of the other sheet. In the following example, I am looking ...
0
votes
1answer
23 views

How to auto-calculate without a need to drag down the formula?

How can I fix formula to a row so that when data is inputted in any cell within that column, it auto-computed in Google Sheets? the % doesn't work Without having to drag the formula down. Example: ...
0
votes
0answers
71 views

How to fetch data in Google sheet using Import XML function with Xpath?

https://www.monito.com/send-money/australia/india/aud/inr/1000 Please open the URL and see what Query should I put to extract following data (=IMPORTXML("https://www.monito.com/send-money/australia/...
0
votes
1answer
44 views

The cell is filled with $0,00 but IF(Cell >0;True;False) return True

In Google Sheets, when I compare a Cell filled with $0,00 using: CELL [$0,00] IF(Cell > 0; true; false). It returns true, but Cell is = 0. It should return false. It seems to be related to ...
0
votes
1answer
21 views

Bar Chart Merge 2 columns in a single bar

I have the following table, I want to generate a bar chart where for each year I can see a single bar, including both Cash and Credit. Today I only see this: Link here
0
votes
2answers
902 views

Applying IMPORTRANGE formula in Google Sheets between tabs

I have one Google sheet having three tabs, Sheet 1, Sheet 2, Sheet 3. I have another tab having the name "Sheet 4" in which I want to import all data from these three tabs, but the problem is data in ...
0
votes
1answer
660 views

Auto-populate cells based on previous cell values in Google Sheets

I have two columns with information. Values in Column B have been manually added to match the values in Column A. Is it possible to have a function that auto-populates column B with the right values ...
0
votes
0answers
109 views

How do we determine shape parameter of a Weibull plot using Google Spreadsheet?

I have a spreadsheet with time to failure data that follows the weibull distribution. The slope from the plot of time-to-failure and median-rank gives me the scale parameter. Is there a function to ...
0
votes
1answer
24 views

How to get the SUM total value to appear in cell vs the formula?

So I have created a spreadsheet to add cells =SUM(B2:B20) ... When I hit enter the sum value should be in the cell I created the formula but instead, I have just the formula after hitting enter. How ...
0
votes
1answer
242 views

Filtering a QUERY using MATCH - how to pass column value into function? Or is there a better way?

I want to get a subset of data from another tab. Eventually, this will become a script and pull data from a different sheet. I can use QUERY to get all the data available, but I only want to return ...
0
votes
0answers
18 views

Code (in google sheet) to search text in Google Docs or PDF's or Google sheet

From GoogleSheet I would like to search text if it exists in docs, pdf files with matching file names (or fileID). Is there a way to do that? I am somewhat familiar with Scripting in googlesheet ...
0
votes
2answers
25 views

Find changes in imported data daily

I have a workbook that pulls data from a website and changes daily. I would like to know what has changed from day to day (or even week to week). Is there any way to do this? I'm using the ...
0
votes
1answer
69 views

Average first 3 values excluding empty cells in google sheets

Trying to find the average of the first 3 values in the column. I'm already running a query to find the average data within the last 3 days =average(query({$A$10:$A$107,$E$10:$E$107},"Select avg(...

1
106 107
108
109 110
123