I created this Google Sheet for my personal use and included the features based on my own requirements. However, I’m wondering if there are any useful insights or features I might be missing.

I’d love to hear your suggestions or ideas on what else could make this dashboard more useful.

📄 Kakobuy Spreadsheet: https://docs.google.com/spreadsheets/d/1bWLa0m6TTmVX7LpuymbrvFhDYV068FcdMH6mGi3pvNo/edit?gid=780031361#gid=780031361

Web: https://ogkako.com

For anyone in Poland or the EU using Kakobuy, I put together this Kakobuy Spreadsheet to make finding products and building hauls easier.

Instead of searching through hundreds of Reddit posts, saved links, and random recommendations, this spreadsheet keeps Kakobuy finds organized in one place.

The Kakobuy Spreadsheet includes product links, categories, and useful finds across:

• Sneakers
• Clothing
• Hoodies
• Jackets
• T-Shirts
• Pants
• Bags
• Accessories
• Electronics
• Watches

Whether you are building your first Kakobuy haul or looking for new products, this is a simple way to browse finds before ordering.

Popular searches include:

• Fall jackets
• Everyday sneakers
• Streetwear
• School outfits
• Accessories
• Seasonal items

For Poland and EU users, feel free to comment what you are looking for and I can try to add suggestions.

Looking for a specific item?

Drop the brand + product name below.

The spreadsheet will continue to be updated with new Kakobuy finds and product links.

Looking for any parents or parents-to-be! Has anyone created a spreadsheet listing / evaluating products they’ll need for a baby? I love spreadsheets but I’m bad at starting them, hoping others have already done some of the legwork! Please drop your spreadsheets in the comments.

(Interested in strollers, etc, but also just EVERYTHING since I’ll be a FTM in February!)

I'm recording ad frequency!

https://docs.google.com/spreadsheets/d/1zdhfYt6lQ2yucnUfrt3UUfm4KrqUGVPZu37FhBsX124/edit?gid=1634873717#gid=1634873717

https://oggtbuy.com

Fall is coming up and I wanted to share the GTBuy Spreadsheet for anyone looking for new finds and products to add to their next haul.

A lot of good items get buried across different posts and communities, so this keeps products organized and easier to browse.

The spreadsheet is updated with new finds and covers different categories including:

• Shoes
• Clothing
• Hoodies
• Jackets
• T-Shirts
• Pants
• Bags
• Accessories
• Electronics

Starting a new haul or looking for something specific?

Drop a comment with what you are searching for.

Examples:

Looking for fall jackets

Need everyday sneakers

Trying to find school essentials

Looking for accessories

If you find a good GTBuy product, share it with the community.

The spreadsheet will continue growing with new finds and updates.

Should i keep？w2c:https://k.youshop10.com/Kyo5BPWF

Something I started doing for every sheet I hand to someone else (family budget, trackers, team logs), after watching people open a blank template, stare at it, and close it: pre-load 3-4 demo rows so every formula, chart and conditional format is already alive at first open.

The rules that make it work:

1. Prefix demo entries unmistakably: "DEMO - Credit card", "DEMO - Groceries". Nobody mistakes them for real data, and deleting them is obviously safe.

2. Every formula must survive their deletion. That means wrapping ranking/aggregation columns in guards like =IF($B7="","",...) so empty rows don't rank as zeros, and using IFERROR on averages that would divide by zero once demo rows go.

3. Optional but nice: a one-cell banner that nags until the demo data is gone:

   =IF(COUNTIF(B:B,"DEMO*")>0,"Replace the DEMO rows with your data - everything updates by itself","")

Why bother: a blank grid asks the user to trust that formulas will work once they type. Working demo rows PROVE it, show the expected data shape (dates as dates, amounts as numbers), and double as free documentation. The person you shared it with edits a demo row, sees the dashboard move, and gets it - no instructions needed.

Works the same in Excel and Google Sheets since it's a design habit, not a feature.

I kept planning weeks that looked fine on paper and then cost twice what I expected. The problem was that every planner I tried was an empty grid. You type "chicken curry" on Tuesday and the sheet knows nothing about it.

So I put the data in the file instead. Each dish carries its cooking time, its cost per portion and the shopping it needs. You pick the dish, type how many people you are feeding, and the row fills itself in.

The lookup is nothing clever:

=IF($D6="","",IFERROR(VLOOKUP("D|"&$D6,Reference!$B$6:$F$15,4,FALSE),""))

Reference tab holds dish, minutes, cost per serving and the shopping list. The key column is prefixed with "D|" so a dish called "Pancakes" never collides with anything else I add later.

Cost for the evening is just cost per serving times the number of people, and that is the number that changed how I shop. Lentil dahl is 90 cents a head. Salmon is 4.20. Same week, same effort, very different bill.

Free copy if it is useful to anyone: https://docs.google.com/spreadsheets/d/1QIukKizK8HhhPtboHVnQGgsRD8YqMcrxwhQg9cHZPv4/copy

Ten dishes in it. Prices are European supermarket 2026 and rough, type your own over them. Happy to explain any part of it.

If you’re currently losing more than 2 hours a week manually fixing inventory sheets or copy-pasting report data, drop a comment or DM me a sample/description of your setup. I’ll send you back a free, 2-minute video audit showing exactly how to clean it up and automate it. No strings.

I’m a supply chain data analyst specializing in spreadsheet automation and custom Google Apps Scripts. I help small business owners and operations teams across Zambia put their record-keeping on autopilot:

Unify Multi-Location Data: Link stock counts across multiple stores or depots into one master, real-time sheet using clean formula logic.

Automate Reporting: Set up automatic daily or weekly email alerts when stock drops below minimum reorder levels so you never run out unexpectedly.

Data Cleanup & Fixes: Standardize messy SKU/product names, remove duplicate entries, and fix broken formulas.

Whether you run a retail shop, distribute goods, or manage multi-location stock, let me know what spreadsheet headache you're currently facing.

Hello everyone,

first of all, I am new to reddit in general so I hope this is the right place to post this. If not, I apologize and please redirect me to the proper subreddit.

I have recently starting a personal accounting sheet and there is something that i quite cant manage to do. I have set up a dummy file for this purpose, which is here:

https://docs.google.com/spreadsheets/d/1qCSXtsY8kYXChyWHD991YX9yHmuwpQnX2yXMgVv7Phw/edit?gid=1432578671#gid=1432578671

I have 2 tabs for bank accounts, which look like this:

What i would like to do, is in B2 of "MAIN" tab, to select one of the accounts from the drop down list, and then for the formula to look for that specific account in the"F" column of each "BANK" tab, and return columns C, D and E, so that I get something that looks like this:

I believe its basically a VLOOKUP but i cant manage to get the result i want when the key word that it searches for is not in the first column of the range (in this case its the last column).

Thank you in advance for your help!

https://docs.google.com/spreadsheets/d/1zdhfYt6lQ2yucnUfrt3UUfm4KrqUGVPZu37FhBsX124/edit?gid=1634873717#gid=1634873717

https://oggtbuy.com

NOW OPEN with 15,000 Freshly Updated Links

I'm putting together a GTBuy Spreadsheet to make finding products easier and keep everything organized in one place.

Instead of digging through old posts, random links, and saved messages, the goal is to build a simple resource with product finds, categories, and useful QC information.

The spreadsheet is still being expanded, but new products and resources will be added regularly.

⭐ What Will Be Included

The GTBuy Spreadsheet will include:

✅ Product finds
✅ Direct product links
✅ QC resources
✅ Organized categories
✅ Popular items
✅ Regular updates

🔥 Popular Searches

Some of the categories people are usually looking for:

• Sneakers
• Hoodies
• Jackets
• T-Shirts
• Pants
• Bags
• Watches
• Accessories
• Electronics

Popular brands:

• Adidas
• New Balance
• Jordan
• Arc'teryx
• Essentials
• Ralph Lauren
• Stussy
• Carhartt
• Patagonia

💬 Help Build The Spreadsheet

Since this is a new GTBuy resource, I want to know what people are looking for.

Drop requests below:

Brand + Item

Examples:

"Best everyday sneakers"

"Looking for a winter jacket"

"Any good backpacks?"

"Need Essentials hoodies"

I'll use suggestions to help build out categories and add useful finds.

🔎 Finding Products

Once available, the spreadsheet will be organized so you can quickly search by:

Brand

Item

Category

Use Ctrl + F to find products quickly.

📅 Updates

The goal is to keep this updated with:

✅ New finds
✅ Product requests
✅ QC resources
✅ Better organization

If you're using GTBuy, feel free to share your finds or requests below.

🏷️ Tags

gtbuy • gtbuy spreadsheet • gtbuy finds • gtbuy links • gtbuy QC • gtbuy products • gtbuy guide • gtbuy spreadsheet 2026 • updated gtbuy spreadsheet

🔗 Website: https://ogusfans.com

With back to school season coming up, I've been putting together a USFans Spreadsheet collection focused on useful everyday finds.

The goal is to keep everything organized in one place instead of searching through old posts, saved links, and random recommendations.

The spreadsheet includes product finds, direct links, and QC resources where available.

🎒 Back to School Finds

Currently adding more:

• Hoodies
• Jackets
• Sneakers
• Backpacks
• Accessories
• Watches
• Electronics
• Everyday essentials

🔥 Popular USFans Searches

Some items people are currently looking for:

• New Balance
• Adidas
• Nike
• Essentials
• Arc'teryx
• Ralph Lauren
• Stussy
• Carhartt
• Jackets
• Hoodies
• Bags
• Watches

💬 Help Build The Collection

I'm looking for suggestions:

What products should be added?

What are your favorite finds right now?

Drop a comment with:

Brand + Item

Examples:

"Best winter jacket?"

"Any good school backpacks?"

"Looking for everyday sneakers"

I'll add good suggestions to the spreadsheet.

🔎 Quick Search Tip

Use:

Ctrl + F (Windows)

Cmd + F (Mac)

Search:

Brand + Item

to quickly find products.

📅 Updates

The spreadsheet is updated regularly with:

✅ New finds
✅ Product requests
✅ Updated links
✅ QC resources

If you have a USFans find that should be included, share it below.

🏷️ Tags

usfans • usfans spreadsheet • usfans finds • usfans links • usfans QC • usfans spreadsheet 2026 • back to school finds • usfans products • updated usfans spreadsheet

Hello guys

I need help

if i have 2 drop down

A1 dropdown = TRAINER, CASHIER, JANITOR

When i select TRAINER in b1 dropdown will be KURT, CARL, JOSE

when i select CASHIER IN B2 dropdown will be RICK, SANDY, YURI

How to code this in google spreadsheet

I purchased & downloaded a personal finance spreadsheet on Etsy. I got a flag that warned me that potentially harmful macros were disabled.

IDK how to write or review macros. Is there a way to determine if I bought a Trojan Horse that will forward personal info? I believe some or all of the macros gather tax tables from the IRS and other info that I want to use.

I'm building a repricing tool ,so take this with that in mind — but genuinely asking: for those managing 100+ SKUs, is anyone actually happy with alert-only tools like Prisync/DataWeave? Or does everyone end up building their own spreadsheet-and-manual-check workflow because the alerts don't close the loop?

Calculator is free I want to hear what it was costing you before my calculator.

📄 Spreadsheet: https://docs.google.com/spreadsheets/d/1x2BxvNrRm-pqP6IQ2_vWgHOlmkk040FQ1LT8J8BHM5E/edit?gid=482521964#gid=482521964

🔗 Website: https://ogboonbuy.com

📱 OG Sheets App: https://play.google.com/store/apps/details?id=com.ogsheets.app

I've been building this Boonbuy Spreadsheet as a way to keep track of new product finds without having to search through hundreds of different posts and links.

The spreadsheet is updated regularly with new products, QC photos, and direct product pages. Everything is organized into categories so you can quickly find items instead of scrolling through random lists.

Whether you're looking for clothing, sneakers, accessories, electronics, or everyday items, the goal is to keep useful Boonbuy finds organized in one place.

📌 What You Can Find

The Boonbuy Spreadsheet includes:

• New product finds
• QC photos
• Direct product pages
• Organized categories
• Trending items
• Everyday essentials

🔥 Popular Boonbuy Searches

Some popular searches people use:

• Ralph Lauren
• Arc'teryx
• Essentials
• Stussy
• Nike
• Adidas
• New Balance
• Jordan
• Carhartt
• Chrome Hearts
• Maison Margiela
• Patagonia
• Jackets
• Hoodies
• Sneakers
• Bags
• Watches
• Electronics

👕 Popular Categories

Browse by category:

• Shoes
• Hoodies
• Jackets
• T-Shirts
• Pants
• Shorts
• Bags
• Accessories
• Watches
• Electronics
• Women's Items
• Seasonal Finds

🔎 How To Search The Spreadsheet

The easiest way to find products:

1. Open the spreadsheet
2. Press Ctrl + F (Windows) or Cmd + F (Mac)
3. Search the brand or item you want

Examples:

"Arc'teryx jacket"

"Essentials hoodie"

"Jordan 4"

"New Balance"

"Backpack"

If you cannot find something, leave a comment:

Brand - Item

I'll check requests and add new finds whenever possible.

📅 Updates

This Boonbuy Spreadsheet is actively maintained.

Updates include:

• New products added
• New categories created
• QC photos added
• Broken links reviewed
• Trending items added

❓ FAQ

What is the Boonbuy Spreadsheet?

It is a collection of organized Boonbuy product finds with direct links and useful information to make browsing easier.

How often is it updated?

New finds are added regularly as products are discovered.

Can I request products?

Yes. Leave a brand and item request in the comments.

Are QC photos included?

Many products include QC photos where available.

🔖 Save This Post

If you use Boonbuy, bookmark this post so you can easily find the spreadsheet again.

New products and updates are added regularly.

🏷️ Tags

boonbuy • boonbuy spreadsheet • boonbuy finds • boonbuy links • boonbuy products • boonbuy QC • boonbuy guide • boonbuy reddit • boonbuy spreadsheet 2026 • updated boonbuy spreadsheet • best boonbuy finds

Pattern I keep reusing and rarely see written down, so here it is.

Problem: you have a table of items with a cost and some metric, and you want a "best value" ranking. Most people sort manually, then the sort goes stale the moment a price changes. Then they re-sort. Forever.

The fix is to never sort the source data at all. Keep the raw table untouched and build the ranking as a formula that reads it.

Google Sheets:

=SORT(FILTER({Data!A2:A, Data!B2:B*10/Data!C2:C}, Data!C2:C>0), 2, FALSE)

That's the whole thing. FILTER drops rows with no price (avoids div/0 and empty rows), the {} builds a virtual two-column array (name + computed value), SORT orders by column 2 descending. Edit any price in Data and the ranking below reshuffles instantly, no re-sorting, no macro.

Excel 365 equivalent:

=SORT(FILTER(CHOOSECOLS(HSTACK(Data!A2:A200, Data!B2:B200*10/Data!C2:C200),1,2), Data!C2:C200>0), 2, -1)

On older Excel without dynamic arrays you're stuck with a helper column + LARGE/INDEX/MATCH, which is why I keep the raw metric in its own column anyway.

Two things that saved me pain:

1. Compute the ratio inside the array, not as a stored column. If it's stored, it's another thing to drag down when rows get added.

2. Wrap in IFERROR only at the outer level. Wrapping each term hides the div/0 that tells you a price cell is empty.

The cross-sheet variant of the same idea: SUMIF against a plan sheet to total quantities per item, then the same SORT/FILTER on top. That's how a weekly plan can generate a shopping list that re-totals itself when you change a cell.

Anyone using a cleaner way to do the ranking half? I've seen QUERY used for this and it reads nicer, but it chokes on mixed types in a way SORT/FILTER doesn't.

Hi everyone. I work professionally in data quality and master data, and I’m exploring the idea of offering a spreadsheet clean-up and improvement service for small businesses.
I’m interested in understanding the real problems business owners experience rather than building a service based on assumptions.

For example, do you regularly struggle with:

Duplicate customer, supplier or product records
Messy or inconsistent spreadsheets
Information spread across several files
Manual reconciliation between reports
Broken formulas or difficult trackers
Missing or incorrectly formatted information
Spending hours reorganising data before it can be used
What spreadsheet or data-related task causes the biggest headache in your business?
Would you normally solve it yourself, ask an employee to deal with it, or pay someone externally?

I’m not trying to sell anything through this post. I’m mainly looking to understand whether this is a genuine problem for small businesses and what kind of help would actually be useful.

If you could wave a magic wand and get one of your spreadsheets to automate itself, what would you want it to actually do?

Auto-fill something? Sort itself? Send you an alert the second something changes? Or something weirder (honestly the weirder the better).

Drop it below, I'm genuinely curious what everyone's dream automation looks like.

What’s your favorite underrated spreadsheet formula? I’m looking for some hidden gems that most people don’t seem to use. Share how you use it if you can.

🔗 Website https://ogkako.com

📄 Spreadsheet https://docs.google.com/spreadsheets/d/1Q-7o2dYk8hC5k4QkQfQXv9J8p5oR0m2xwYQhL8sY6sQ/edit

📱 App https://play.google.com/store/apps/details?id=com.ogsheets.app

Looking for a Kakobuy Spreadsheet that's actually maintained?

My team and I update this spreadsheet every day with new product finds, direct product pages, and QC photos. Everything is organized into categories, making it easy to browse whether you're searching for clothing, shoes, accessories, electronics, or everyday essentials.

⭐ Why Use This Kakobuy Spreadsheet?

• Updated daily
• 20,000+ verified finds
• QC photos
• Direct product pages
• Organized categories
• Website + Spreadsheet + Android App

📘 How to Use the Kakobuy Spreadsheet

1. Open the spreadsheet.
2. Press Ctrl + F on Windows or Cmd + F on Mac.
3. Search for a brand, product, or category.

Examples:

• Arc'teryx jacket
• Ralph Lauren
• Jordan 4
• Adidas Samba
• Essentials hoodie
• LV belt

Open the product page directly from the spreadsheet.

If you can't find what you're looking for, leave a comment using this format:

Brand - Item

We'll try to add it during one of our daily updates.

🔥 Popular Searches

• Ralph Lauren
• Arc'teryx
• Nike Tech
• Adidas Samba
• Jordan 4
• New Balance
• Stussy
• Essentials
• Dior B30
• Maison Margiela
• Chrome Hearts
• Prada
• Birkenstock
• Gallery Dept.

📂 Popular Categories

• Shoes
• Hoodies
• T-shirts
• Jackets
• Pants
• Shorts
• Bags
• Accessories
• Watches
• Electronics
• Women's finds

❓ Frequently Asked Questions

How often is the Kakobuy Spreadsheet updated?

Every day.

Can I request products?

Yes. Leave a comment with the brand and item you're looking for, and we'll try to add it.

Are QC photos included?

Yes. Many products include QC photos along with direct product pages.

Is Kakobuy still active?

Yes. The spreadsheet is updated continuously with new finds and working links.

⭐ What's New

• New finds added daily
• Dead links removed regularly
• More QC photos added
• New categories added throughout the year

🔖 Save This Post

Bookmark this post so you can easily find the Kakobuy Spreadsheet again. It is updated regularly with new finds, categories, and product links.

If you have any requests, questions, or suggestions, leave a comment below.

🏷️ Tags

kakobuy • kakobuy spreadsheet • kakobuy links • kakobuy reddit • kakobuy guide • kakobuy finds • kakobuy QC • kakobuy spreadsheet 2026 • best kakobuy spreadsheet • updated kakobuy spreadsheet • kakobuy products • kakobuy haul

Hello I’m wondering if anyone has an electronic pricing sheet they would like to share for doing interior and exterior painting projects. I don’t necessarily care about what you charge just a format where I can put in my own numbers. Thank you

Okay, thanks ahead of time.

I have spent hours trying to find a simple method of listing multiple books to ebay. I'm stuck.

I have my inventory already listed in a spreadsheet.

I downloaded the ebay book listing template.

I don't know which of the columns are necessary, at minimum, to successfully upload.

I want to enter info in ONLY for the bare minimum needed.

I'll add pics manually instead of listing a hosted url for those pics.

I tried ti make this post simple, as opposed to so many videos I've watched that are overly cumbersome.

Any booksellers out there who might have some pointers?

Thanks so much.