Skip to main content

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 data as markdown table to your question; this will greatly increase the chance that you get a satisfactory answer.

Filter by
Sorted by
Tagged with
0 votes
2 answers
7 views

Nested IF formula not working

I am trying to write a nested IF formula in Google Sheets. =IF(F5=1,"10", IF(F5=2, "15", IF(F5=3, "35", IF(F5=4, "60", IF(F5=5, "120", "Missing ...
Mandarc's user avatar
  • 11
-1 votes
0 answers
10 views

How can I add "settings" or custom properties to Google Sheets? [closed]

Is there a way for me to add custom key-value properties to a Google Sheet without resorting to creating a different "settings" sheet? I'm using Apps Script and prefer not creating custom ...
Bharel's user avatar
  • 109
-1 votes
0 answers
9 views

I think I need LET and Array for my formula as my Filter and Sorting formulat isn't working. Help?

Working on formating a sheet where I need to pull normalized data into an analytics page. The criteria is to pull from one tab to the next. Get data using B & E and then apply the values to preset ...
RTG's user avatar
  • 33
0 votes
1 answer
5 views

Formula to multiply a value by a factor that is based on the word found in another column

I would like a Google Sheets formula in column C that checks what word is in column A and then multiplies the value in column B by a factor selected based on the matched word. For example, if the ...
Carl Coombs's user avatar
0 votes
0 answers
12 views

Two-way sync? Updates to linked Sheets range update values in linked Docs table, but can changes to Docs table also update Sheets range?

I have a Google Sheets spreadsheet with cells linked to a Google Docs document. If I update the spreadsheet's linked cells, they update in the Google Doc as well. Is there any way to have it work in ...
Sharie Sprague's user avatar
2 votes
2 answers
16 views

Conditional format rule highlighting the wrong cells

I have a problem with a simple conditional format rule in Google Sheets. I want to color the cells in range M5:M90 whose values are greater than or equal to the value in cell M2. I thought it was ...
hubertwah's user avatar
0 votes
0 answers
31 views

How Google Sheets' new Conditional Notifications' alerts look like and why are they lost?

I realize it's a new service, but its single purpose in life is to send e-mail messages, so why am I not getting them? While the help center claims "Tip: Email notifications may not be immediate&...
LWC's user avatar
  • 1,240
0 votes
1 answer
14 views

Delete duplicates based on date (google sheets)

Essentially, Column G is a object Column V was the date that the object was sold on Sometimes the object was sold numerous times, so lets say object X was sold in 2003, 2010 and 2013. I want to delete ...
user avatar
1 vote
2 answers
25 views

Sorting Google sheet based on two columns as if they were one

This question is an evolution of this other question. I have a Google sheet (Form responses) with the following structure: | Timestamp | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | | ...
To Do's user avatar
  • 145
0 votes
1 answer
18 views

Is there a formula capable of building rows in google sheets?

Not sure if this is possible or not, but essentially I need a formula that is capable of building rows in google-sheets. My data is currently like this: Column A = Property Name, Column B = Routines. ...
user avatar
0 votes
1 answer
25 views

Sorting Google sheet in a particular way

I have a Google sheet (Form responses) with the following structure: | Timestamp | Field 1 | Field 2 | Field 3 | Field 4 | | | | | | 4 | | | | ...
To Do's user avatar
  • 145
1 vote
1 answer
40 views

Is there a way to undo all the sorting and editing done on a google form response spreadsheet?

My colleague and I did a survey on google form. Once the data started coming in, she started sorting and editing the data directly on the response spreadsheet. This led to the data getting mixed up. I ...
ing the inked's user avatar
0 votes
0 answers
9 views

Column post discord help!! please [closed]

Below is my current script, this goes to the third column and post the first row in that column to discord, great its a start... but i need to go post the entire column - third column, row 1-42. ...
ultra_iinstinct1's user avatar
2 votes
1 answer
25 views

Inserting signatures in cells

Is there a way (besides inserting an image) to format a cell in Google Sheets so that when you click on the cell, it opens something that lets you sign and have your signature show up in that cell? ...
Yosef's user avatar
  • 21
0 votes
1 answer
8 views

How to I turn the numeric value returned by MONTH() into the actual name of the month?

I have a spreadsheet of financial transactions. The Columns headers are (A) Date, (B) Category, (C) Subcategory, (D) Description, (E) Amount. I have the following query that creates a pivot table from ...
user658182's user avatar
0 votes
1 answer
14 views

How can I manually edit empty cells that are within an array returned by an ArrayFormula function?

We have a Google Form whose responses are stored in Google Sheets, and that data is used by formulas in other sheets. For example, one sheet uses the following formula to return form response data ...
Dave's user avatar
  • 1
0 votes
0 answers
9 views

Generate unique project ID based on certain criteria

I am working on my company's sales database to create an unique ID for each sale (or project) base on the customer ID, product ID and sale date as the table below. These criteria are necessary to make ...
Matheus Pereira's user avatar
0 votes
1 answer
9 views

Google Sheets Conditional Formatting not working: just the first applying rule is executed [duplicate]

My conditional formatting rule does not affect the cells even though it should. (Even if no rules whose range covers the cell modify the same properties of the cell, but, e.g., one sets "bold&...
Convexity's user avatar
  • 101
0 votes
1 answer
19 views

How to merge multiple functions to dynamically create a single table of data?

I have a spreadsheet of financial transactions. The Columns headers are (A) Date, (B) Category, (C) Subcategory, (D) Description, (E) Amount. I have a separate budgeting spreadsheet that contains a ...
user658182's user avatar
0 votes
1 answer
14 views

How to Prevent Duplicate Entries in Google Forms and Notify Users Using Google Apps Script

I'm working on a project where I need to prevent duplicate entries in a Google Form based on a barcode number field. When a duplicate barcode number is detected upon form submission, the submission ...
user avatar
-1 votes
0 answers
7 views

How to preview a webpage in Google Sheets when the URL has parameters

I would like to preview webpages in Google Sheets using Apps Script. However, the URLs that I want to preview have parameters. For example, my URL is like this: example.com/?elementor_library=thing-i-...
avashije's user avatar
0 votes
0 answers
26 views

How to perform min, max, etc on table of text stored numbers? [duplicate]

Walmart.com Target.com =hyperlink("Link to product","$10.79") =hyperlink("Link to product","$9.99") How can I turn the text in each cell into it's numeric ...
user66001's user avatar
  • 103
0 votes
1 answer
15 views

Sum my monthly expenses based on category

I would like to group my expenses in each month based on each category One sheet I have columns: billing month, post date, transaction date, description, amount and category Another sheet I have ...
Hrofme's user avatar
  • 1
1 vote
1 answer
48 views

Find the Top 5 Most Frequent Days of Week and Top 5 Times of Day using Array or Query in Google Sheets

I'm working with a sheet that has 1,000' of dates and times in one cell where the formatting for each specific cell is Month/Day/Year - Hour:Minute AM or PM. I'm looking to push out with a single line ...
RTG's user avatar
  • 33
1 vote
1 answer
25 views

How to isolate the earliest and latest times and eliminate any times in between on base on a date

I'm trying to figure out how to isolate only the first and last times from a specific day in Sheet1 A:A and determine the exact hours between the first "Load Out" and the final "Load In&...
Jay Bryant's user avatar
0 votes
1 answer
16 views

How do I make Shift+space select the full row in Google Sheets, not only a part of if? [duplicate]

I select a cell: I press SHIFT+Space. I expect the full row to be selected. But only a part of it is selected: If I press Space a second time without releaseing SHIFT it really selects all the row. ...
Xavi Montero's user avatar
1 vote
2 answers
34 views

Google sheet ROI formula not working

My Google sheet formula isn't working as intended. In order to calculate the ROI of an event I'm making I use different stats and make a big calculation of points in the ROI column The formula I'm ...
Maslie's user avatar
  • 9
1 vote
1 answer
23 views

Conditional formatting based on partial text in another cell

I have a google sheet, I want each cell in column B to change colour if the cell on the same row column F includes the phrase "RF FTE". It may also have other data in that cell but if "...
Pete's user avatar
  • 11
0 votes
2 answers
40 views

Shift space does not select the full row in Google Sheets, only a part of it

In Google Sheets, if I select a cell and then SHIFT+Space I expect the entire row row to be selected however sometimes only part of the row is selected and I need to press SHIFT+Space again. For ...
Xavi Montero's user avatar
-1 votes
0 answers
12 views

Trying to Countif Color of Cell matches

I'm currently using the following code: function countColoredCells(countRange,colorRef) { var activeRange = SpreadsheetApp.getActiveRange(); var activeSheet = SpreadsheetApp.getActiveSheet(); ...
Stephanie Keffton's user avatar
0 votes
0 answers
26 views

Spaces being incorrectly removed from text strings when importing data into Sheets

I have spreadsheet data that I want to import to Google Sheets. The source spreadsheet is a proprietary format; neither Google Sheets nor MS Excel. The issue I'm running into is that I have columns ...
Haris Serdarevic's user avatar
0 votes
0 answers
16 views

Using an IF statement in Google Sheets to pull data across worksheets [closed]

I am trying to filter by labels across worksheets. In worksheet 1, if something is labeled "Label 1" in the F column, I need it to populate in Worksheet 2 in column A. I also need if ...
user avatar
1 vote
1 answer
25 views

I can sort normally using mouse, but keyboard shortcut gives error

When I select a cell range and go to Data>Sort Range>A to Z, it works perfectly! but when I select a cell range and press Alt + D + S + A, then it gives me an error that few of my cells are ...
dudeAwesome's user avatar
-1 votes
0 answers
13 views

Need change Google Sheets to Google Drive Script to make sure the downloaded image has an extension included

This is a script I created using ChatGPT and it works but there is a small issue. The script checks a column called "downimg" to see if it contains the text "stop", if it does, the ...
itoldusoandso's user avatar
0 votes
2 answers
36 views

Calculate the duration in weeks that it would take to lose a specified amount of body weight (BW) givent 1% of body weight is lost exactly each week?

Calculate the duration in weeks that it would take to lose a specified amount of body weight (BW), in pounds, given that 1% of body weight is lost exactly each week? I would like to be able to find ...
Dal's user avatar
  • 5
1 vote
2 answers
46 views

How to divide really big numbers in Google Sheets

As part of the creation of an IBAN number generator, I need to divide a 26-digit number by the number 97 to find out the check digits in the IBAN number. After about an hour of searching, I found out ...
Ogi22's user avatar
  • 9
0 votes
1 answer
23 views

onEdit function to clear range of cells

I need some help to create a simple trigger for my Google spreadsheet. What I'd like is to enter "clear" in cell D1 and have it triggers a script that clears all the cells in the range B2:...
Colin's user avatar
  • 11
0 votes
1 answer
35 views

How to dynamically return values horizontally in Google Sheets

Say I have a column like this: user item User1 Item1 User1 Item2 User1 Item3 User1 Item4 User1 Item5 User2 Item1 User3 Item1 How can I return them like this in a filter/lookup formula: user ...
yesnomaybe's user avatar
0 votes
1 answer
34 views

Sum multiple currencies by looking up conversion rates based on multiple cell values

I'm trying to sum values that are in different currencies. The currency for each value is specified in the previous column and the final result should be in Australian dollars AUD. I use a fixed ...
Phil's user avatar
  • 3
0 votes
1 answer
43 views

Join results of a BYROW function that expands into multiple rows

I have two sheets, one containing user-entered data, and a second containing a bunch of data. I have included example sheets at the bottom of this question. I'm trying to build a formula that for each ...
Spedwards's user avatar
  • 215
0 votes
1 answer
23 views

How to force English number format for all number values in a column?

This is what I see by default in my table:  Pasted  Value    DisplayedValue                                                                                                                             ...
Tomáš Zato's user avatar
0 votes
1 answer
21 views

Sorting by date on a master spreadsheet with data imported from other spreadsheets

I have 4 spreadsheets importing data from cells A2:V, each spreadsheet auto sorts on edit by date (column 17), but when I ask the master sheet to auto sort by column 17, it sorts them by date but also ...
Psych-out's user avatar
-1 votes
1 answer
20 views

How to get a cell to autodelete contents after subtracting from another cell

I have a spreadsheet to keep track of payments on group trips and would like to be able to keep everything within that spreadsheet. I would like the ability to be able to delete from the sum that ...
Yager's user avatar
  • 1
0 votes
2 answers
34 views

How for each cell in a row return and concatenate multiple matches without dragging down formulas?

I have a list of items and in another place I have list that covers some of these items each time with a different key. How to fill in column B all matching results next to the original item (column A)...
LWC's user avatar
  • 1,240
-3 votes
1 answer
31 views

More computational capabilities per spreadsheet

I am a pro user of Google Sheets and Google Apps Script. Is there any possibility to get more computing capability per spreadsheet? Some of my spreadsheets become unusable due to a large amount of ...
Piotr Magdziak's user avatar
2 votes
1 answer
139 views

Google Sheets: how to format currency with numbers right-aligned but +/- and $ left aligned and padded with spaces?

I've already looked at: How to left align currency symbol but right align number? How to left align dollar symbol but right align number? The best number format I have so far is: [$$]* #,##0 which ...
Ryan's user avatar
  • 774
-1 votes
1 answer
27 views

Growth between 3 cells in Google Sheets

I am creating a data wall to compare student achievement across 3 time periods Beginning of the Year(H2), Middle of the Year (I2) and End of the Year(J2) and having the difference recorded in K2. I ...
Justin Barry's user avatar
1 vote
2 answers
71 views

I'm looking for a way to return multiple values in an array formula on Google Sheets - haven't been able to find a solution

Scenario: I have a roster of dog owners who have had dogs involved in various training classes. I have a list of the dogs and their respective classes, and I have a list of the owners. I want to ...
Alison's user avatar
  • 11
0 votes
1 answer
18 views

Conditional formatting formula to highlight duplicates but only if the date equals today

I'm trying to write a conditional formatting rule to highlight cells in B3:B that are duplicates, but only if today's date is in column A. I started with =COUNTIF(B3:B,B3)>1 which returned the ...
Jeremy Urekew's user avatar
0 votes
2 answers
35 views

How to use the value of a cell to find another cell?

I’m trying to create my own data sheets for reading at school but when I put the reading ages in, I need it to select the zpd level and the reading targets automatically base on what I input. Eg if I ...
Kevin Wilson's user avatar

1
2 3 4 5
180