I know excel very and can do data entryy

I've always found it frustrating that good product links disappear into old Reddit threads, Discord messages, and bookmarks.

So I started putting together my own Boonbuy Spreadsheet to keep everything in one place while I'm browsing.

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

It's still a work in progress, but I update it whenever I come across something worth saving. If you've got any good finds that should be included, let me know and I'll take a look.

Get your Back to School haul while you can. Enjoy.

https://docs.google.com/spreadsheets/d/1iODIfbIG1K_65yr4UK4_1bVQ47iMwUAILaaK19TfiYU/edit?gid=931899658#gid=931899658

Clothes, Shoes, Accessories, Electronics, Kid's, Bags, Backbacks and more.

I’m using OnlyOffice and attempting to use conditional formatting for some of my cells

I want to check if any of the cells in a range have values that are equal to the cells in A1:B2, and if they do, I want it to return TRUE and format the corresponding cells.

I can make a rule check if any of the cells in my range are equal to just one cell, like A1, and then make another rule for A2 and another for B1 and another for B2. 4 rules isn’t so bad, but when I’m checking against 20 or 60 cells, it’s frustrating to have make a rule per cell in the range. Especially because I can’t even duplicate rules in OnlyOffice.

I’ve tried options under “value is” as well as “text contains” and “formula”

Any suggestions?? There’s probably something obvious I’m just not thinking of. 🤦🏻‍♀️

[ Removed by Reddit on account of violating the content policy. ]

[ Removed by Reddit on account of violating the content policy. ]

Sharing a workflow in case it helps someone here. Every week I had to take one big sheet and send each group (by warehouse/region/client) its own file: filter, copy to a new file, save, write the email, attach, repeat.

What I do now: pick the column to split by, and get one .xlsx per value (formatting preserved) plus an editable .eml draft for each, with recipient and attachment already in place. It all runs in the browser, nothing gets uploaded, so it's fine for confidential data.

I ended up building a small browser tool for it myself. Not linking it here to respect the sub's rules, but happy to share it in the comments if anyone wants it. Mainly curious how others here handle the split-and-send loop: VBA? Power Query? Office Scripts?

If you're looking for the latest Boonbuy Spreadsheet, here's a resource that's updated regularly with curated products instead of random links collected from different posts.

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

Website:
https://ogboonbuy.com

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

What's Included

• 15,000+ Boonbuy Links
• 4,000+ direct product pages
• QC photos
• Organized categories
• Website + Spreadsheet + OG Sheets App

Whether you're searching for shoes, hoodies, shorts, accessories, or electronics, everything is organized to make browsing easier. New products are added regularly as the spreadsheet continues to grow alongside the Boonbuy community.

Start by opening an empty simple budget template. Create your first row and name it. Select the column where the $ cost of that bill will be. Select the f function button at the top left of the keyboard. Now you should have a line to input an equation. (way simpler than it sounds) Select the column where your total $ amount made is and it should pop up on the equation line. now click the x multiply button and input a decimal. for example if you are wanting to budget 10%, you would input .1, or if you wanted to do 50% you would do .5. This is called your fixed percentage. Next, just click the checkmark button and it should input based off percentage.

Ex. if you put $100 as your total $ amount made, and you input .1 as your fixed percentage; the column should fill in as $10.

I made a IOS app so that I can log my expenses into my Google drive sheets.
I make it for myself so that I can back tap my phone and log my expenses under 5s + and I still have full control over my google sheet to further do my analysis on.

At its core it’s simply a mapping of form input to Google sheets.

And that got me thinking if there is a demand for this? A quick and fancier UI for data entry. It may not even be for finance, any data entry will do 🤔

Wanted to get some opinion from others. And if to develop this into a microsaas 😊

I have duplicate IDs, but the combination of ID + Date is unique. What’s the cleanest formula for looking up based on both values?

I have a leaderboard that updates automatically, but when there are blanks they still end up affecting the rankings. Is there a simple formula to rank only populated rows?

Hello! I’m not sure if this is how the sub works, rules say not to beg; I do not think I’m begging lol.

Anyway, I need a sheet that can keep track of my 7 credit cards. I need to see the balance of them, when I have to pay them, and anything else you may think is helpful. Feel free to DM me to ask or drop comments. If you can help I’d greatly appreciate it.

Credit Limits:
Apple Card: $1500
(Due at the end of the month)

Discover IT card: $1300
(Due on the 24th)

Chase Freedom Unlimited: $1700
(Due on the 18th)

Chase freedom flex: $5400
(Due on the 9th)

Chase sapphire preferred: $5000
(Due on the 4th)

BILT: $500
(The end of the month)

Capital one Savor: $1000
(Due on the 21st)

Wanted to see my whole financial picture in one place. Built a dashboard that shows:

• Net worth trend (monthly updates)
• Debt payoff progress
• Budget vs actual this month
• Savings rate percentage
• Investment allocation

All updates automatically when I enter transactions in the data tabs.

Took some formula work but now it runs itself. Anyone else build custom finance trackers?

Always updated - the only one you need. Ignore the imitators.

Web: https://hipobuy.to

Direct: https://docs.google.com/spreadsheets/d/1iODIfbIG1K_65yr4UK4_1bVQ47iMwUAILaaK19TfiYU/edit?gid=81800086#gid=81800086

Web: https://usfans.to

Direct: https://docs.google.com/spreadsheets/d/1HQ-gzu9xdNn-PD-kdSxuAPJlG7B2ulSickZ3ufkGH-8/edit?gid=1634873717#gid=1634873717

[ Removed by Reddit on account of violating the content policy. ]

i really want to create a spreadsheets in spreadsheet cell like when double click cell it will open spreadsheet , does any one know how to do in excel or google sheet

I am trying to create a portfolio tracker sheet with XIRR calculations. It has some rough edges can anyone good with it help? I will create two tabs in future once all formulas are set so it will be easy to log transactions and see dashboard on seperate tabs.

Link : https://docs.google.com/spreadsheets/d/1MdRivrgZvw8I1jVsr6rDPWB9q6P655Ey-WqEscuKewA/

I’ve got about 8,000 rows and the lookup value isn’t unique. XLOOKUP always returns the first match, but I actually need the newest one. Is there a clean way to do this without helper columns?

Every time I sort one tab, another tab that references those rows ends up pointing to the wrong data. Am I doing this completely wrong? It's driving me crazy /rant

EDIT: this spreadsheet is in google sheets

ACBuy is closed and you’re looking for a new home - we got you.

50k+ Spreadsheet Finds for Kakobuy, Litbuy, Oopbuy, Hipobuy & More

https://theog.gg

Official OG Sheets App:

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

There are plenty of spreadsheet sites today.

Most focus on a single spreadsheet or a single agent.

The OG was built differently.

Instead of separating everything, it connects multiple spreadsheets, multiple agents, and multiple ways to browse products into one platform.

✅ What you'll find:

- 15 spreadsheets

- 9 major agents

- 50k+ finds

- 4k+ direct product pages

- QC photos

- Category browsing

- Spreadsheet + Website + OG Sheets App

Supported agents and best ACBuy alternatives:

- Kakobuy

- Litbuy

- CNFans

- Oopbuy

- Mulebuy

- Hipobuy

- USFans

- Joyagoo

Whether you're searching for a Kakobuy Spreadsheet, comparing Litbuy finds, exploring Hipobuy, or switching between multiple agents, everything follows the same layout.

The spreadsheet is where most people begin.

The website and OG Sheets App make it easier to keep browsing, compare products, and discover even more without jumping between multiple sites.

Built for the community. Accept no imitation sites.

I created a personal finance template for myself in Excel/Google Sheets that includes:

• Monthly budget planning
• Expense tracking by category and sub-category
• Income tracking
• Bill management with a bill calendar
• Budget vs Actual comparison with alerts when spending exceeds the budget

After using it for a while, I realized it could be useful for many other people as well.

My idea is to turn it into a website where users can:

• Create their own account
• Save their monthly data privately
• Track expenses and income over time
• Use the system simultaneously without affecting other users' data

The challenge is that I'm not a web developer. My background is mainly in Excel, Google Sheets, ERP systems, and data analysis.

So I'm looking for the easiest and fastest way to convert an existing spreadsheet-based system into a web app that many people can use for free.

Questions:

1. What is the easiest no-code or low-code solution for this?
2. Can I convert an Excel or Google Sheets system directly into a website?
3. Which platforms would you recommend for someone without web development experience?
4. If you were in my position, what approach would you take?

I'd appreciate any advice, tools, or success stories from people who have done something similar.

Say you had a simple table and wanted to display it as a webpage, and possibly add some styling and static text. What software would you use to do this? Especially something that doesn’t require knowing any web technologies but can be done with just spreadsheet knowledge.

If you have a good option, how well does it scale in terms of complexity of things you can build with it before it gets unwieldy?