| A | B | E | F | G | |
|---|---|---|---|---|---|
1 | Jump to sheet | Thread title | Thread description | Category | Notes |
2 | External | Named functions | useful tools | ||
3 | 11yrha9 | Optimizing a schedule with conflicting appointment requests | I'm working on scheduling over 30 peoples schedule to see open availability among different time slots and days. Ex: someone might have an… | applied | appointment availability checker |
4 | 121fc05 | How do I select multiple options in a drop down menu? | So I’m creating a sheet with all my recipes and wondering if I can select more than one option with the categories. For example: these are the… | applied | recipe book with searchable backend |
5 | 123bvjd | Adding or subtracting from a column by specific amounts at various rows in the column | I've got a column of various numbers #42 #62 #72 #121 etc. And I often have to add and subtract from various points in the list. Eg. From #42 onwards… | applied | subtitle/CC line adjustment |
6 | 12c538j | looking for formula to count of multiple columns | Sheet: https://docs.google.com/spreadsheets/d/1NcRSMO-_pE-BAFaHLgk6ofn3y1jgb5_zsnfxLvbyZn0/edit?usp=drivesdk Issue: I can't figure out how to tell… | applied | jewelry design and purchasing tracker |
7 | 12moi5m | Dynamic Relationship Chart with changing reference list of Characters not working because both Columns and Rows need to be dynamic. | I have created somewhat of a Punnett Square/Multiplication Table for keeping track of how characters in my story think of each other. The sheet… | applied | visualizing and organizing relationships for story writing |
8 | 132ctj4 | Google Sheets - Generate current month schedule based on yearly raw data | Hi, I'm trying to move from Excel to Google Sheets, so although I know my way around in VBA, I'm a complete noob in Google Scripts, and sheets in… | applied | calendar and work coverage schedule |
9 | 132qr17 | Can anyone create a sheet like this for golf skins? | I found this on YouTube. It's a few years old but exactly what I'm looking for. I've been put in charge of handling the skins for our golf trip this… | applied | 🏌️⛳ |
10 | 134fkg3 | Meal Plan with Automated/Autopopulating Shopping List | hi hi! I have been seeing this type of meal planner all over my TikTok since the new year started and have been so curious as to what goes into… | applied | shopping list for meal ingredients |
11 | 135ml3s | Lock cell change after certain time | Ok so I have this spreadsheet https://imgur.com/a/2M34SW6 where people choose what time they want to eat lunch and dinner, and wanted to know if its… | applied | cheat-proof meal selection |
12 | 11qhmql | Multi-category charts in Google Sheets | Hey! I have a 2 part question: I would like to create a multi-category chart in Google Sheets but I've been unsuccessful in finding a way. Does… | charts | workaround for Excel-like chart features |
13 | 11w915j | Formula to fill values between known milestones that would form a polynomial trend line | Currently, I am using a formula =cell_to_the_left*(end_number/start_number)1/steps_from_start_to_end The problem is that these exponential values… | charts | interpolate between known values |
14 | 11r6n2l | Google Sheets Complex Edit | In a spreadsheet with 1850 rows, columns a and b always have only the first row of a set filled. The sets may be 2 rows, 3 rows, up to 8 rows each… | data cleanup | fill blank rows with previous entry |
15 | 11u07cf | Help with Ascending Query | I am trying to make a spreadsheet that automatically returns the top 8 results from different track meets. I am running into a problem with ASC quer… | data cleanup | reformat one column from imported data |
16 | 1213kzz | sum formula using color-filled boxes | hi ! i was wondering if it is possible to add a group of cells ( EX: =D3+E3+F3+G3 ) but exclude any cell that is filled in with a color? thanks in… | data cleanup | count cells by color (sort of) |
17 | 121xq6x | Cascade Labels | I have a custom label sheet i want to print on that isn't in any add on, its in Averys online label maker... there has to be an easy way to just cop… | data cleanup | "de-pivot" data |
18 | 1247yec | Rename multiple cells that each have a different hyperlink | For the life of me I can not find a logical solution for this. I have hundreds of cells with different hyperlinks but I want them all to have the… | data cleanup | extracting sheet IDs (or other info) from raw HTML |
19 | 131xme6 | How to compare & find any matching CSV’s from multiple datasets, and then have the answer listed in a single cell, either CSV format or otherwise? | Hi, What Google sheets formula would I use if I wanted to compare & find any matching CSV’s from multiple datasets, and then have the answer listed… | data cleanup | compiling and counting list items |
20 | 11rts9p | Group recurring relationships between two columns | 19K subscribers in the sheets community. Everything related to Google Sheets: Your sheets, best practices, questions, and discussions.… | other | novel and complicated function |
21 | 123opxu | Populating sum/avg/median/max/min data from master list into summary tab | Hey folks, I have a master list that contains a brand's 2022 social media content performance metrics: - each row represents a post published by the… | other | data source for Query+ named functions |
22 | 13cbngp | Creating a macro for an indie TTRPG initiative calculator and I have no idea what I am doing. | So, I think this is more complicated than I intend it to be but here is what I am doing. I have a sheet. It has one table that is three columns. Characters name in initiative is A, | other | script-like incrementing with iterative calculation |
23 | 11x3fsc | How can =B1=C1 be true but =B1-C1=0 false with numbers? | Hello, I am making a sheet where I need to compare 2 numbers, and I have conditional formating if the difference between the 2 cells is 0 (Let's cal… | quirks / pitfalls | floating-point values cause problems if not rounded |
24 | 11z60ks | MMULT "empty parameter" | Hi all, I have a formula that I have to update each time more data is added and I was wondering if there was a more time effective way to do it… | quirks / pitfalls | cautionary tale about multi-value cells (see thread) |
25 | 120ria9 | Conditional Formatting - Highlight cell if before given date in another cell | I want to have cell x turn red when the date is prior to the date in cell y. I've gotten this to work in columns N & O by doing the following… | quirks / pitfalls | absolute vs. relative ranges with conditional formatting |
26 | 12f1z07 | Can't remove space dividing numbers | I have a sheet which happens to have a column of prices, which came with a space in between the numbers. I can't for the life of me remove the space… | quirks / pitfalls | whitespace characters are evil |
27 | 12ym2fg | Can someone tell me WHY this formula works? | From a thread I can't respond to. The information + formula is below. It WORKED for me, but I want to know why/how it's working to better my… | quirks / pitfalls | External link to blank vs .empty cells from u/AdministrativeGift15 |
28 | 11pmm4e | #REF! | useful tool | match multiple values at the same time | |
29 | 11xveqp | Draft style sheet with dropdown selection. How do I make the options unique? Can I remove an option | Here is an example of the spreadsheet . I currently have it set to show an indicator when a pick is chosen (with color to make it obvious) But i… | useful tool | dependent dropdown lists and limited slots |
30 | 11ylm95 | Way to manually overwrite if an IF statement is false | Here's what I want to do =IF([Condition], [output if true], [option to manually write if false]) The part I want to see if possible is the "option t… | useful tool | switch cells between blank (editable) and filled |
31 | 11z7s1e | [Request] Need help with Scroll Downs associating with Cells | Option A | | Option B | | Option C | | Option D | Scroll Down |… | useful tool | cross-join / Cartesian product method 1 (med/small data) |
32 | 123nriu | I am importing data from other spreadsheets and putting it into another less busy sheet | In the sheet cell (AK3) that I am importing from has a formula in it. When I put "=Importrange(googlesheetURL, "Sheet1! AK3" will the less busy sheet… | useful tool | import functions from other workbooks |
33 | 124vxld | Generate huge list of all possible combinations, then lookup and get sum of values | Please bear with me as I try my best to explain what I'm trying to do... I want to analyze some data from a video game. The player can equip four… | useful tool | cross-join / Cartesian product method 2 (large data) |
34 | 1281fwg | Using a wildcard character when referencing other worksheets | Hi, I'm trying to have a summary sheet where I gather data from cells/ranges in all worksheets with a name that starts with a certain word. Specific… | useful tool | consolidate data from many sheets with INDIRECT |
35 | 129yrck | Conditionally create new COUNTIFS by using COUNTIFS from another cell | I fear this will be difficult to explain. Apologies if long. I have inherited a google sheet with multiple COUNTIFS that look like a table. There is… | useful tool | COUNTIFS template to avoid editing conditions in-cell |
36 | 12e6h8d | How to avoid writing huge IF cascade of conditions when dealing with nested conditions? | There is a better practice or style for writing nested formulas with many conditions? Mines are a mess, and I'm trying to improve readability because… | useful tool | dynamically filter list of items by multiple criteria |
37 | 12ha3vo | Formula for Filtering Multiple NUMBERS at once | Hey all, its so funny i consider myself very computer literate and im good with technology however today ive found myself in an absolute fix. I have… | useful tool | match multiple values at the same time - improved |
38 | 12iq8ih | I want to add a last time modified cell and I'm having trouble | So I'm running a community spreadsheet for a reading challenge I am in and I wanted to add a last time updated cell for each column because I wanted… | useful tool | timestamps |
39 | 12jmxuq | Help with creation of a function, Sheets won't recognise an argument. | I want to make a function under the name 'SUMALLCELL' that will find the sum of all values for a given cell across multiple sheets. I set up a table… | useful tool | named functions to pull cells from multiple sheets simultaneously |
40 | 12l66eh | Calculating String Similarity in Google Sheets? | Hi Folks, How would I identify which characters in two different cells overlap? (For example, if cell A1 had "EATS" and cell A2 had "EATED" then the… | useful tool | similarity measurement for fuzzy matching |
41 | 135q2xw | Count how many time I searched an Input | Hi guys, I can do basic stuff in google sheet but this I can't find how to do it. I've made a search bar in a sheet usong "=Query(" referring to a… | useful tool | search tally with lambda |
42 | 1364gi3 | How to write an App Script that will Increment each cell in a range, regardless of current value in other cells. | EDIT: THANK YOU to everyone who replied, especially u/JetCarson . My final functions for those who may search later are: function increaseUsed() {… | useful tool | auto-increment with lambda |
43 | 137lufw | Filling a column from the adjacent column | Hello Community, I have a table that looks as below I am looking for a formula to fill the Column AN4:AN with the values from the Column AO4:AO… | useful tool | SCAN with multiple values |
44 | 138c4q8 | Dynamic scaling of a spreadsheet | I am trying to create a simple spreadsheet, of which I want to control the size with a user variable. In the example below, let's say that I want to… | useful tool | SCAN with multiple values |
45 | 139swfe | combinations w9th criteria | does anyone know if theres a way to say i have X slots which can each have either 0,1,2,3,4 or 5 in them but the total of all slots cant excede Y and… | useful tool | SCAN with multiple values |
46 | External | Glitchy recursive formula | So, I was experimenting with making a nested version of the Advanced Default Values Without Hidden Column method | quirks / pitfalls | click at your own risk! |
47 | 12iergh | Automatically copying data from Form Responses into second sheet | Hi everyone. We've got a Google form (call is Sheet1) that gradually populates a spreadsheet like the following: Submission 1 | A | B | C | D |… | ||
48 | 12j0k9e | Is it possible to track repeated values as a single value on chronological charts? | I'm not familiar with the correct terminology, so it's being a hassle to found information on it, but i'm trying to create a chronological chart to… | ||
49 | 12j4h5o | Trying to recreate a pivot table with QUERY function | Given the following data set: PLAYER | VALUE | Player One | A | Player One | A | Player One | B | Player Two | A | Player Two | B | Player Two | C… | ||
50 | 12kxezy | Calculate total products sold quantity including "bundle" products | Hi there i am kind of stuck with the following: I have a list with a Date, SKU and "Sold Quantity". This table represents the how many of a product… | ||
51 | 12l3gzk | Filtered Dropdown List | Hi all! I've got an example sheet of something I'm working on and running into issues with. This is a way to organize cards for a trading card game… | ||
52 | 12ym69o | Adding times for the laps of a race | I'm a track coach and whenever I time a race for my athletes, I get the splits for each lap of the race. I'd like to input those times into a… | ||
53 | 12ynpaw | Paid Gig - Need Google Sheets Formula Expert | (thread deleted) | ||
54 | 130a64k | Trouble adding categories to my weighted list generator. | I have a rather niche tool I am creating to help out an online community. It's a tool that pulls from a list of map names (for a video game) that get… | ||
55 | 134fwfz | Iterative Calculations and filling bags with beads | Hi, I'm trying to logically fill columns to state whether certain beads are able to be in a bag, based on their colour and how full the bag already… | ||
56 | 134wei4 | How to make charts doing percentages of Yes vs No (EXTREMELY BEGINNER) | I am trying to analyze early illuminated manuscripts and whether not they may be iconic or aniconic (if Jesus or apostles are figuratively or… | ||
57 | Old Archive | Make checking one checkbox uncheck the others. | I'm making a character sheet for a game I'm working on and I want to have 3 checkboxes that can only have one checked at a time. I would like to set… | ||
58 | Old Archive | Creating a list of entrants from a tally list. | I have a list of names with a number of tickets next to each name. How do I make a list of all the names to put in a raffle. Eg. If Fred has… | ||
59 | Old Archive | Help with 2 complicated QUERY formulas (Link to Sheet provided) | Hey there ! After seven hours discussing with ChatGPT, I've arrived at the two formulas in the Google Sheet below (cell AW1 and AZ1). They kind of… | ||
60 | Old Archive | Using cell input in hyperlink | Hello! I have a sheet where I have a list of numbers refering to a product. (Lets use 123 as an example) Our suppliers have a webadress similar to… | ||
61 | Old Archive | I am having trouble making a graph for this. I want to make a line graph that has a line for each a | 19K subscribers in the sheets community. Everything related to Google Sheets: Your sheets, best practices, questions, and discussions.… | ||
62 | Old Archive | help with formula to filter cell entires | I'm not sure how to articulate the Sheets function I need so I've written a desicription and example below. We are using some archiving software that… | ||
63 | Old Archive | I have a form that populates a google sheet. Can I populate the same sheet manually as well? | Let's say the form submissions populate sheet 1. Can I produce rows of data manually in sheet 2 and then, when a line of data is complete, it… | ||
64 | Old Archive | Super long formula problems | I run a courier service. I have 50 clients and there is a two character abbreviation for each. if I write "yc" in A1 I want my spreadsheet to write… | ||
65 | Old Archive | How do I multiply the rows by a value such as 2,3, etc and have them add up into the total column | https://docs.google.com/spreadsheets/d/1zmj5AThuDP4F4ecW717M_k_zhONUmDOt3IxdNVGNq0g/edit#gid=0 Id like to have it so that the quantity, calories… | ||
66 | Old Archive | Is there an easy, somewhat compact way of doing all combinations with repeats? | So what I have is 14 names. I'm trying to make a collection of sheets that will (to start with) list all combinations of those names, including… | ||
67 | Old Archive | Function to find specific differences between the text in two data sets? | I am a translator and I need to find a way to show the differences between the text in one cell in comparison to text in another cell. I've looked… | ||
68 | Old Archive | Trying to create 'Month progress' formula from mid-month to mid-month | OK, I'm trying to piece together one formula from various date and day functions and I think I am getting tripped up in the layering, for lack of a… | ||
69 | Old Archive | Skip/Pause indexing? | I want to copy data from another sheet, but I want it more spaced out, is there any way to have the index skip columns/rows in the destination sheet?… | ||
70 | Old Archive | Trying to auto-populate data as live data populates | It's really hard to explain this without showing you the sheet, but I'll do my best to explain my dilemma. In row 1, there will be titles such as… | ||
71 | Old Archive | How do I make a Google Sheets spreadsheet that automatically totals tallies in a chart? | How do I have Google Sheets automatically total the tallies that I make in a chart? Refer to the example chart below. Say that I am conducting a… | ||
72 | Old Archive | Importrange Array_Literal Error | Can anyone help me with this? I have two Google Sheets. I’m trying to use import range to copy the information from one sheet onto another. I’ve done… | ||
73 | Old Archive | automatic number change | Hi! I need to make a file number from 001 to 999 / Number of the month( ex: 567/03). I can't develop a way to restart numbering at the beginning of… | ||
74 | Old Archive | ORDER BY first 2 characters in a date column - nested IMPORTRANGE QUERY | Heya, I have the following IMPORTRANGE QUERY: =QUERY(IMPORTRANGE("https://file_URL", "Sheet1!A:E"), "SELECT Col1, Col5 WHERE Col2 = 'value' ORDER BY… | ||
75 | Old Archive | Calculate Hourly Rates from Gross/Day Rate | Hello! I'm trying to optimize a timesheet I use at work. When our technicians work 13 or less hours, we pay them a flat Day Rate. Because that numbe… | ||
76 | Old Archive | I need to automatically sort cell values, not formulas. | 39K subscribers in the googlesheets community. A subreddit for collaborating and getting help with Google Sheets. Unofficial.… | ||
77 | Old Archive | Trying to automatically vertically merge rows that have the same information in the first cell | So I have a gigantic spreadsheet with 4,000 rows, with an English word or phrase in the first column and then the rest of the columns have different… | ||
78 | Old Archive | A workaround for MatchIndex duplication issue? | 39K subscribers in the googlesheets community. A subreddit for collaborating and getting help with Google Sheets. Unofficial.… | ||
79 | Old Archive | Chart with Grouped Data | 39K subscribers in the googlesheets community. A subreddit for collaborating and getting help with Google Sheets. Unofficial.… | ||
80 | Old Archive | Using filter/query formula | I have a dashboard I am trying to create in google sheets. I want to basically track a recruiting downline. There may be multiple recruits from one… |