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
2 votes
1 answer
89 views

Highlighting only text for google sheets

Is it possible to highlight individual text in Google Sheets, just like how you can on Google Docs or Slides?
Emma's user avatar
  • 21
1 vote
1 answer
15 views

Sorting a range of data based on a column within that data

I have a set of data spanning columns A through P in Google Sheets. I would like to add a column in Q that will return the values of A based on the top values of column P. I assume this can be with ...
Colin Davis's user avatar
4 votes
2 answers
2k views

Converting "4.8 million" into an actual number

I have a sheet that has numeric records that are a mix of three different number types: 260,000 4.8 million 870 million 1.1 billion The first one is handled just fine as a number, but the ones ...
RobKohr's user avatar
  • 151
2 votes
1 answer
110 views

How to change Google Sheets interface language?

When for example opening some Google Sheet in a private tab without signing in to Google, the interface language is determined by the IP. So how to change the interface language to English?
vstepaniuk's user avatar
3 votes
3 answers
375 views

Formula to count rows between positive values

I need a formula in Google Sheets to count the number of rows between each positive number in a column. In Column B of the table below, for every value in Column A that is less than, or equal to zero, ...
Yu Lun CHEN's user avatar
1 vote
2 answers
32 views

Finding preceding n results from a list based on conditions in Google Sheets

I have the following list in a Google Sheet: List Apple Banana Pear Grapes Kiwi Mandarin Papaya Orange Tomato Plum Watermelon Based on these two following conditions, I'm trying to get ...
pfnanc's user avatar
  • 43
0 votes
2 answers
22 views

I wanted to set the maximum value of each unique input as active

In the example data below, for each unique SYS Name, the Status column is marked Active in the row with that SYS Name's highest Serial Number. In Status, Column C, for each unique Sys Name the row ...
Vintikon Indonesia Perkasa's user avatar
1 vote
1 answer
146 views

In Google Sheets search for a string in a column, then return the row where found

In Google Sheets, I have two columns of data. The first column is labeled Category, and the second Contents I want to search Contents for a text string and return Category wherever it is matched. For ...
SeanJ's user avatar
  • 111
0 votes
2 answers
27 views

Inverse column and row relationship

I have 2 sheets that looks like this: Manager Bob Manager Sally Manager Samuel Team A Team C Team G Team B Team X Team Y Team Z (Real data contains 25 columns and 40-50 rows) I would like to &...
FailedUnitTest's user avatar
2 votes
1 answer
152 views

alphanumerics in duration in sheets - how to convert to a number of minutes

Working in google sheets, I am getting input from another program in the form of "Xh Ym Zs" to track time. I'm trying to write a formula that will just yield a number of minutes, so "2h ...
user8531's user avatar
1 vote
0 answers
31 views

Deleting Google Sheets's row automatically after a specific date [closed]

I've the following table: My goal is to delete the 2th row automatically when the current date is equal to the date in the cell A2 plus 2 days. Example: in figure the A2 contains the date 10/04/2024 ...
Federica Guidotti's user avatar
1 vote
2 answers
37 views

How do I make dropdown selections add value to a totals column in Google Sheets

Very new to Google sheets and very lost. I am trying to create an awards tracker for school Merits 2024 Ideally, I want to include drop down menus with options for each week we hand out merits at ...
MHLO17's user avatar
  • 13
1 vote
1 answer
41 views

Return the percentage of the month that has elapsed up to today's date

I want a formula to return the percentage of the month that has elapsed up to today's date. For example, if today is April 6, and April has 30 days, then the result would be 20%: 6 / 30 = 20% What ...
peterK88's user avatar
0 votes
0 answers
22 views

How to return multiple items from a range to a single cell as a list but user chooses how many items in Google Sheets?

I have variable lists that will have 200–1000 values in them. ex: 1 Reliable 2 Practical 3 Responsible 4 Organized 5 Detail-oriented 6 Logical 7 Hardworking 8 Dedicated 9 Honest 10 ...
kodarr's user avatar
  • 1
1 vote
2 answers
44 views

Formula to calculate the sum of consecutive 0's and -1's

I am hoping someone can help me with a Google Sheets formula to calculate the minimum sum of consecutive 0s and -1s in a column. 0s and -1s are consecutive until interrupted by any other integer. For ...
Will's user avatar
  • 13
1 vote
1 answer
29 views

Formula to return a value when the adjacent column's text contains any value from an array of text strings

In Google Sheets I have an array named "Tech_issues" with the following values: Array name value 1 value 2 value 3 value 4 Tech_issues crash froze glitch error I'm looking to create a ...
flipskyrain's user avatar
0 votes
0 answers
25 views

Google Sheet formula to search all columns that match a specific keyword and sum values from them [duplicate]

I'm trying to paste a formula on cell AS2 that searches the column names on Row 1 for an occurrence of a keyword and if that column has such a keyword on its title searches Row 2 for numeric values ...
MACC's user avatar
  • 101
2 votes
1 answer
70 views

How to concatenate all further columns from duplicated items of a first column?

In Google Sheets I have two or more columns of data: Column 1 is a list of items that may include duplicates. Column 2 (and any additional columns), contains keys each associated with the item from ...
LWC's user avatar
  • 1,240
2 votes
2 answers
173 views

I want to sum a column in table A when a criteria is met in table B (per row)

Table A: Exp Inc Cat $10 Car Repair $300 Salary $5 Car Repair $300 Salary Table B: Cat Sum Car Repair $15 Salary $600 I have been searching query, sumif and other commands to generate ...
timindaburgh's user avatar
1 vote
1 answer
23 views

Keep matching columns aligned when stacking ranges from different tabs that are missing certain columns

Since a while back, I have been trying to find an alternative to Power Query in Google Sheets to combine several sheets of data into one by matching on column letter. For example, in tabA I have the ...
CMM00's user avatar
  • 11
0 votes
1 answer
36 views

Why does my count function stop counting the cells once I cross work order 9999?

I am using the count formula on google sheets to calculate total work orders submitted and counting by the work order number. Well when my work order number crossed 9999, it stopped counting them in ...
Adam Droege's user avatar
-1 votes
1 answer
33 views

Google Sheets Auto Categorize Budget from Statement

I have a Categories sheet and a Statement sheet. The Categories sheet contains a list of all possible categories, and the Statement sheet is an export of my credit card. How can I automatically ...
user325057's user avatar
0 votes
0 answers
27 views

How can I format my x-axis to include time in order from 6pm to 2am?

I want to create a scatterplot for Number of Days Late To School Each Month vs. Typical Bedtime from survey data provided by my stats students. However, my x axis "starts" at 12:00am and &...
Jennifer Preissel's user avatar
2 votes
3 answers
75 views

Multiply/Concatenate String Arrays

Suppose I have three columns importing data from elsewhere, like so: Name Company Division Adam Meta Ops Betty Nvidia Sales Carl OpenAI Development The number of values in each column may change ...
dee123's user avatar
  • 23
2 votes
0 answers
64 views

Increase canvas size on a drawing in Google Sheets

I am using the drawing tool in google sheets to create a flowchart. My flowchart requires more space than the standard canvas size. How can increase the canvas size? I could not find an option to ...
Kisheon Alexander's user avatar
-2 votes
1 answer
22 views

Any idea why I am getting duplicated cells in google sheets?

Hi there can anyone tell me why am getting a duplicate on the following code in cell c3 I am getting this anytime a new form was added function onEdit(e) { // Get information about the edited cell ...
Omar's user avatar
  • 1
0 votes
1 answer
53 views

How to get values from sheet of Google Form responses to main sheet?

In Google Sheets I have spreadsheet containing two sheets. The first, 'main sheet', contains formulas that reference data stored in the second sheet, 'Form Responses 2', that stores Google Form ...
Fysyx's user avatar
  • 3
0 votes
1 answer
86 views

Google Forms/Sheets - How to recover ownership access for a form and sheet that has no Owners, only Editors?

I have inherited a Google Form with its corresponding Sheet, for which the original owner is unknown. In the list of collaborators, there is no owner. Everyone at the company who has access is only an ...
BadHorsie's user avatar
  • 1,461
0 votes
1 answer
78 views

Apps script cannot find Google Sheet

I set up a simple script to download a CSV into a Google Sheet. I saved the code, gave permissions on running, ran it from the script editor associated with the correct sheet, double and triple ...
Drewbot's user avatar
-1 votes
1 answer
20 views

How to get the first cell's text in a row given a value from a column?

This is what my sheet looks like and I want to look through the first percentage in the rows labeled overall (C6, C9, C12, C15) find the highest percentage and then return the corresponding grouping ...
Jace's user avatar
  • 1
0 votes
1 answer
21 views

Google Sheets ignoring url links

I'm trying to upload a product to Google Marketplace. It says I can do it with Google Sheets. Two fields require a URL. When I import my tab-delivered text file into the sheet, everything goes in just ...
CheeseFlavored's user avatar
0 votes
1 answer
41 views

Absolute cell references not working as I'd expect, what am I doing wrong

I am working on a sheet that tracks yearly budgets to review/see trends in the data. I am trying to make it user friendly and essentially "dummy-proof" for lack of a better word. Most of the ...
cotimms's user avatar
1 vote
1 answer
28 views

Conditional Formatting based on date and other cell with multiple options

I'm having trouble with conditional formatting. I would like a cell with a date to be highlighted after a certain amount of time has passed. That amount of time depends upon another cell. For instance,...
Jesse's user avatar
  • 13
0 votes
2 answers
60 views

How to use a cell's array value

Simple question, but I can't figure it out. In the spreadsheet above I have a table in A1:B5. I have a filter in A7 and its value is an array. In A11, I want to textjoin all the values of the filter ...
Hugh Beyer's user avatar
0 votes
1 answer
12 views

Grouping or linking data I added on a sheet to its corresponding filtered data brought over from another sheet

The small towing company I work for uses Google sheets for our calls logs. I filter logged calls so that all police calls are copied from the "General Log" sheet and show up on a different ...
Jann's user avatar
  • 9
3 votes
1 answer
60 views

Place multiple values returned by FILTER into a single cell instead of multiuple rows

I'm using the FILTER function to return a short list of items from a separate sheet. This is my current formula in B2: =FILTER('In Care'!D2:D999, A2='In Care'!J2:J999) The results spill into the rows ...
Graham's user avatar
  • 133
1 vote
1 answer
58 views

Combine two SUMIF formulas into a single formula

I have two SUMIF formulas. Both do what I expect them to but I need to combine them together. The first formula gets all values from Column I where a specific word (eg "Word") is written in ...
A.bakker's user avatar
  • 125
-2 votes
1 answer
31 views

How to determine a streak of "perfect sets" of data?

I would like to be able to track a metric for some trading drills I'm doing in "sets" of typically 10 to 20 trades. I already track winners and losers, and a "perfect set" is a ...
JVC's user avatar
  • 1,246
0 votes
1 answer
21 views

SumIfs, looking to match part of a string in criteria range with criteria driven from another cell

=SUMIFS('Unspecified Clean URL - Freefor'!B:B,'Unspecified Clean URL - Freefor'!A:A,"*Orlando*") I can manually type in the City Name I am using as criteria, but I have a column of them and ...
monooptical's user avatar
0 votes
1 answer
18 views

Changin format of the number in google sheets

Need to change format of the numbers from 7500,00 to 7.500,00 Changing the custom number format doesn't help ass it recognize the dot only for the decimal separator but in my case dot - thousands ...
gadhumurz's user avatar
1 vote
0 answers
19 views

Image from Google Sheet not pulling through in Google Slides

I'm using Google Sheets to convert a URL to an image and you can see in the 1st screenshot, but when I copy the table (linked) into Google Slides the image doesn't pull through, as you can see in the ...
Jerremy's user avatar
  • 11
-1 votes
2 answers
45 views

Changing text styles within parentheses (partial cell values)

I'm trying to write a Google Apps Script to italicize any text in parentheses in a specified range in Google Sheets (partial cell formatting). Ideally it would also remove any existing text-only ...
gills's user avatar
  • 192
0 votes
2 answers
56 views

How do I use google sheets to remove items as they are selected from a list that may include duplicates

I would like column C to be column A with everything in column B filtered out. Column A may have duplicates and those should carry over into column C, unless the same number of that item appears in ...
KyAnSan's user avatar
1 vote
0 answers
85 views

Can I replace percentages in legend with another value?

I would like to change the default percentages shown in a Google Sheets Pie Chart with the actual dollar values. Is that possible? I don't see anywhere to choose something other than the percentages. ...
user avatar
1 vote
1 answer
43 views

I have some phone numbers with names in data set 2 that match some names in data set 1 without phone numbers... how can find these and condense?

I currently am working on creating filled out contacts in data set 1. I have around 600 names, some filled, some missing phone numbers. This set of data has several columns but the only one I'm ...
Camden Vicknair's user avatar
0 votes
1 answer
42 views

Can I make it happen that when I check a checkbox I created in a cell it will not display that checked item anymore?

This all should happen in a cell. I have several items in checkboxes that when i select one or multiple it will not display that item anymore in the cell For example, this cell will contain: Option 1 ...
Marlon P Montebon's user avatar
0 votes
2 answers
42 views

Specify the Phase based on the Dates

I have dates listed in Column A and I want to convert them to Phases in Column B; e.g. if the date is >= 5 Feb 2024 is equal to Phase 1 & if the date is >= 1 March 2024 is equal to Phase 2 ...
Deccal's user avatar
  • 3
-2 votes
2 answers
59 views

How to sum across columns automatically?

Would like your help to solve the problem as file attached. https://docs.google.com/spreadsheets/d/1E3KTOYHuYIJy9uQKsvlXwbCpwL6cU1IHAQ-Yirb-AfQ/edit#gid=0 I would like each column to sum automatically ...
Anakin Teow's user avatar
0 votes
1 answer
38 views

Syncing two cells in Google sheets

Is there a way to sync two cells on google sheets? So if I have a formula for import data function from another sheet in a column, then I add notes about it in the second column, I would like the ...
Jamie's user avatar
  • 1
0 votes
2 answers
81 views

Formatting dates based on year

I'd like to create a Google Apps Script that changes the format of all dates in a sheet based on the year. If the date is in the current year, the format should be, e.g., Aug 5 If it's in an earlier ...
gills's user avatar
  • 192