Questions tagged [google-sheets]

For questions about Google's web application to create and edit spreadsheets on a web browser or app. 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 chance that you get a satisfactory answer.

Filter by
Sorted by
Tagged with
0
votes
1answer
10 views

Google sheet pop up info

I use google sheets for woodcrafter members to log time to use our woodworking shop. The shop has a keycode entry and members are only to enter if they have booked time. All members were given access ...
0
votes
1answer
855 views

Pull unique values from other sheets as new sheets keep getting added

I'm trying to get a unique list of values in a master sheet based on a list of values that appear in column A of other sheets. The tricky part is that every time a new column is added in the master ...
0
votes
1answer
17 views

Google Sheets Formula Not Working in Excel

I have this formula pasted below that works in Google Sheets, but not in Excel. I've looked up possible solutions, but just cannot find what may be the problem with it. The return I get is just the ...
0
votes
2answers
2k views

Consolidate columns from a dynamic range into a single column in Google Sheets

How can Google Sheets take a range of multiple columns and rows and stack or consolidate all the non-empty cells into one column? For this case, I want non-unique cells. Also, each cell in the range ...
0
votes
1answer
119 views

Can I retrieve the names of sheets in a public document?

I am currently using the function IMPORTRANGE in a Google spreadsheet to pull information from a public document using the URL. I have to supply a range_string in the format "Sheet Name!A1:D21" to ...
0
votes
1answer
2k views

How to set cell value based on 2 conditions of 2 other cells?

I've got a spreadsheet where people enter in values into columns A through H with I being a checkbox. On another sheet, it keeps a running total of all of the values of column E based on the values of ...
0
votes
0answers
13 views

Using Google sheets to generate number based on two drop down list selections

So I'm trying to create a pricing calculator for my handmade business. I've gotten really far and have all my products separated out on different sheets based on material type, then have those sheets ...
0
votes
1answer
13 views

Google Sheets ISBETWEEN nested function pulling values outside of set range

I am using a nested ISBETWEEN function with the filter function to pull a list of items that fall in a certain range. Im using this forumula: =FILTER(U7:U,ISBETWEEN(V7:V,U5,V5)) U7:U is a list of ...
0
votes
2answers
2k views

How to Clear Cell(s) based on the Value of another Cell

I am looking for a script that will clear cell(s) when the value of another cell changes or is equal to ("X"). In the attachment I would like when Column "G" gets checked marked (TRUE), then ...
0
votes
1answer
8 views

Type error: cannot read property getid of null in google script

When I run this script it show me this error. I can't understand what I do. Its function is to transfer results from html form to Google Sheet. Can anyone solve this problem? var sheetName = 'Sheet1' ...
0
votes
1answer
37 views

Filter the data of two different column

I'm trying to filter down the data of two different columns. I have exported the Time Tracking Report from JIRA which consists of the following columns: Issue Type Key Status Priority Summary ...
1
vote
2answers
364 views

Adding 1 to a Cell with VLookup

So this is my first time trying to write a script, and the sheet I am working on is here. The script I'm trying to run would allow me to push a button and have it use Vlookup to add 1 to a cell in ...
0
votes
1answer
28 views

Adding Positive Values Only (across multiple sheets)

The example formula below works perfectly in my spreadsheet if ALL the numbers are positive. However, I would like to pull the values from the cells indicated below (from 14 different pages), but ...
0
votes
1answer
62 views

If cell y contains any word from range x:x, mark cell y green

In Google Sheets, I have three columns (with different lengths!) Column1 contains firm names (50) Column2 containts firm names (100) I would like to mark a cell in Column1 green (or with a number in ...
1
vote
1answer
24 views

How to stop IFS function always giving the same result for x even if greater than x or less than x

C9 being the group size, these are the formulas I used: =IFS(C9<5, "0%",C9>=5,"15%", C9>=15, "25%", C9>=40, "40%") =IF(C9<5,"0%",IF(C9>=5,"15%",IF(C9>=15,"25%",IF(C9>=40, "...
0
votes
2answers
2k views

Google Sheets - Highlighting Cells if they contain text from another range of cells

I want to highlight a cell in a column with a specific color if it contains any of the elements from a range of cells on another sheet. I believe I need to use 'custom formula is' with the INDIRECT ...
1
vote
1answer
200 views

How to create comma and hyphen separated list of sequential numbers in Sheets?

How do I create a list of numbers, where consequential numbers are reduced to being separated by a hyphen? e.g. I have a column with numbers like 1 2 3 5 6 7 8 10 12 I want this to be reduced to 1-3,...
0
votes
1answer
37 views

Conditional formatting based on string values in another column

In Google Sheet I would like to highlight in red the cells in a column "Y" if another column, say column "X", contains certain abbreviation (string variable). Column "X" ...
0
votes
2answers
78 views

Suming values in a column if value in cell next to it matches another cell

I'm trying to create a sheet to maintain a small inventory of servers. I created a segment where each type of component will be listed at the top. Below it is a series of copy-pasted chunks which ...
0
votes
1answer
46 views

How to Import Data From Another Sheet If Any Data is Present In A Cell Range Corresponding to The Same Row

I am extremely basic in my understanding of coding formulas for Google Sheets, so please help where you can. The formula I'd like to put together is to search a vertical range (column) of information ...
0
votes
1answer
15 views

How to add arrayformula function to this formula with IF function?

I made a table that has two columns (namd & State). The 4th column(check) makes conditional formatting possible for any of these combinations: (if name is either "Ali" or "John"...
0
votes
2answers
33 views

Google Sheet Formula Error

Hoping to get a little help with a formula I am making I have used it in other columns to calculate an outcome, but for some reason when I go to decimals under 0 it give me a #N/A "No Match"....
1
vote
1answer
306 views

Google Sheets row minimized to almost nothing when no data is present but needs to auto expand to be fully seen ONLY when data is present

I've got a Google Sheet I'm creating for settlement purposes and I have 8 variables that only get used sometimes. Each variable has its own line devoted to it. For example, this load has a scale ...
0
votes
1answer
38 views

Filter by Condition in a list using custom Formula

I've googled this various different ways, but haven't found anything that has worked. I have a list that needs to be Private filtered by condition using a custom formula in google sheets. In Sheet2 I ...
0
votes
1answer
15 views

Highight cell based on current time

Working on an hourly To-Do list. I have a column (H) with the list hour (on the Hr) starting with 5am all the way until 11pm. For Example: 5:00 AM 6:00 AM 7:00 AM 8:00 AM and so on.... I would like ...
0
votes
0answers
9 views

IMPORTHTML not fetching the correct webpage [duplicate]

I made a spreadsheet, a part of which uses the IMPORTHTML function to get data from this webpage. What I've written is: =IMPORTHTML("https://www.rbi.org.in/scripts/FS_PressRelease.aspx?fn=9?"...
1
vote
1answer
143 views

Conditionally format a column if it contains all the values in a set

Each of the columns in my Google Sheet represent a farm. Each farm is a list of animals. I want to highlight the entire column if the farm has a duck, a horse, and a cow. So the column may look like ...
0
votes
0answers
9 views

Import data from google sheet two into google sheet one if SHEET1CELLA1 equals a specific value

I would like to change the value in a certain cell, and have that import the complete data from another sheet that contains service information on specific unit# so that I can have multiple hidden ...
0
votes
0answers
16 views

#REF!, How to Grab the first response of form and ignore the duplicate in google sheets

I have a google form for attendance and I have a formula to automatically calculate the salary from the attendance. Sometimes people fill out the attendance twice with the same status (work/go home) ...
0
votes
1answer
332 views

Changing a cell value based on another cell's color?

In my Google Sheets in column F, I want to include the word "LATER" based on magenta color (#ff00ff) that is in column B starting from row 227, how should I write this script? I'll really appreciate ...
4
votes
3answers
3k views

How to add a link to Google Search in a range in Google Sheets

I have a google spreadsheet, where I want to link each cell in a range to the google search page, where the search term is the text in this particular cell. So if I have a cell with content 'Bikes' I ...
0
votes
2answers
333 views

How do I "bin" results in Google Sheets?

I am trying to bin my results so my groupings have lower granularity - going from a 1-10 scale to a 1-5 scale. For example, any result 1 or 2 would be renamed to 1 in the next column, any result 3 or ...
-1
votes
1answer
23 views

Google Sheets clearing every other cell with a script

I have a sheet that have formulas on column B at every other Row starting from B3, so it's B3, B5 and up to B101, I have the following script to clear the rest of the sheet except for column B, How ...
0
votes
1answer
103 views

How to Copy Cell Value and Format From One Tab to Another Using a Formula?

An answer was provided in this question: webapps: Cell reference with colour formatting for doing so within a tab, but not across tabs. Does anyone have suggestions for a script that will work across ...
0
votes
1answer
18 views

How to use importxml to pull just one of several lists

This site has answers to a game called Spelling Bee which is published daily. I want to use importxml to pull the answers (which is a list of words) into Google Sheets, but I am a novice on this ...
0
votes
2answers
29 views

Auto Sort different ranges

I have a google sheet that I would like to sort different ranges by the 2nd column in each range. Example: A B C D E F G p 7 1 h 9 1 q 6 2 j 3 2 g 9 3 p 7 3 I need the range A:C sorted by B ...
0
votes
1answer
109 views

How to use arrayformula to find and get data from only a certain, dynamic set of columns?

I have a table where my headers are dynamically generated from another source and can show up with any header values, in any order. In the example below I've got the header values: AA - BB - CC - ...
0
votes
3answers
2k views

Multiple columns as one in an Google Sheets chart

I have a Google Sheet tracking data over days, logging data at different times during the day, example: Is there any way that I can have this data represented in a chart as one continuous line ...
74
votes
19answers
158k views

How to prevent cut and paste data changing references in formulas?

Google Sheets has a feature where if you have a reference to a data cell in a formula, and you cut the data from that cell and paste it in a new location, the reference in the formula is updated to ...
0
votes
3answers
2k views

Can Weekday value be shown in natural (Su, Mo, Tu..) format in Array Formula?

For Google sheet with the following data in A2:B4 06/29/2019 1:25 PM 1 06/30/2019 1:32 PM 1 07/01/2019 1:40 PM 1 The output will show Monday 1 1 Saturday 1 1 Sunday 1 1 Can this be ...
0
votes
1answer
28 views

Google sheets range of sheets?

I have multiple sheets in my Google Spreadsheet. Let's suppose that they are named "1", "2", ... "n". I would like to sum the contents of the B4 cells in all of these ...
0
votes
1answer
15 views

How to sum cells that are in hexadecimal format

First of all, read 32, 1023 with the 0x32 and 0x1023 to identify that it is a hexadecimal number. When we only have numbers the sum is done with decimals and it seems to work. The problem is that in ...
0
votes
1answer
222 views

Google Apps Script MailApp Not Sending Email To Script Owner

I've set up a script to take information from a Google Form and email that information to multiple people using Google Apps Script. What it does not do, however, is email the owner of the script. I'...
-1
votes
0answers
15 views

COUNTIF function not showing in google sheets?

I hope you are doing fine. I am trying to count a specific text from a column but when I type the count if it does not show up. Can someone help me with this, please?
0
votes
0answers
9 views

How to use hyperlinks in google spreadsheets to email threads for multiple users at the same time?

I'm running some data in Google spreadsheets and need to link a lot of different email threads to that spreadsheet. I need different users to have an access thru these hyperlinks directly to the email ...
0
votes
0answers
40 views

Calculate number of days between dates across multiple rows

I am trying to find a way to create a pivot table in Google Sheets that lists the years as rows, the countries as columns and the number of days lived in each country as the values. I think the way to ...
2
votes
2answers
5k views

How to pull last value in a Google Sheets column and populate it across another worksheet column?

This is my first post here- I hope this is the right place for it, apologies in advance if it isn't. Context: I have a password protected presentation that I need to give users access to, but only ...
0
votes
2answers
29 views

Searching Multiple Columns From Single Source Sheet in Google Sheets

I have a Sheet where I have all of my data entered. I have been able to filter the information to other sheets no issues when only searching in one column. I am having issues when trying to search 2 ...
1
vote
1answer
9 views

Activating cell after button click (remove focus from the button)

I have a sheet with one button (a shape) which is associated with an Apps Script function. When I click the button it inserts a row and activates a cell in that row. Then if I try typing, nothing ...
0
votes
1answer
23 views

I need to extract a data validated cell content and use it as a part of a new formula

I would like to give the user the option to choose between DAYS360() and NETWORKDAYS(). For that, I thought about adding these 2 to a data validation cell. Afterwards, I would like to be able to add ...

1
2 3 4 5
151