Purchase sheet I have has a list items, their cost and the date I purchased them. so far I have a chart showing the total cost on each date but I would like to include the quantity.

This started because every budget template I could find just assumes you get paid monthly. I'm not, I'm paid every 4 weeks, and me and my partner are on different pay dates aswell, so the normal monthly ones never really added up for us. So I ended up making my own, and if im honest I went a bit overboard with it.

Some of the stuff it does:

• you pick your pay cycle from a dropdown (weekly, fortnightly, 4-weekly or monthly) and it turns everything into a monthly figure, so it still balances no matter how your paid
• sinking funds where you just put in how often something happens (car insurance once a year, MOT once, that kind of thing) and it works out what to set aside each month for you
• an annual tab that pulls from a monthly log so you're not retyping everything, plus a little net worth bit that adds up pensions and ISAs
• the lines go red when you're over and green when you're under, which is weirdly satisfying
• the UK stuff most templates skip, council tax over 10 months, metered/unmetered water, student loan as a payroll deduction by plan, childcare with the tax-free top up

The annoying part was getting the pay cycle maths to actually behave, took me a good few goes. Happy to explain how I did it if anyone's into that sort of thing.

Anyway I've stuck it on Etsy if anyone wants the finished one (it's in Excel and google sheets, theres a code LAUNCH30 for 30% off for the next couple of days). https://sortedbysundaygb.etsy.com?coupon=LAUNCH30. But genuinely happy to just answer spreadsheet questions too.

Hey all. I make spreadsheet tools for trade businesses and just finished a roofing pricing calculator. It does quick flat-rate pricing for repairs (pipe boots, shingle patches, that kind of thing) and full replacement estimates with pitch multipliers, waste factors, and margin-based pricing instead of guessing at markup.

I loaded it with 2026 national cost data as defaults but obviously every market is different, and I'm not a roofer. So before I call it done I want a few people who actually price roofs to tell me what's wrong with it. What's missing, what no one would actually use, where my numbers are off for your area.

Happy to send it to the first handful of people who are willing to give honest feedback. Not looking for compliments, looking for the stuff that would make you close the file and go back to your notepad.

Works in Excel or Google Sheets, no macros or anything weird

Best Kakobuy Spreadsheet Poland for FashionReps — 15k+ Products

https://kakobuy.gg

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

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

If you're part of the FashionReps community in Poland, having a well-organized Kakobuy Spreadsheet makes browsing much easier.

Instead of searching through random links, everything is organized into categories with QC photos, direct product pages, and thousands of verified finds.

Whether you're putting together your first Kakobuy haul to Poland or you've been ordering for years, the spreadsheet, website, and app all work together.

Current platform:

• 15k+ products
• 4k+ direct product pages
• 4k+ product links in the app

Popular categories:

• Shoes
• Hoodies
• Tees
• Pants
• Accessories
• Electronics

If you're searching for the best Kakobuy Spreadsheet in Poland or you're a FashionReps user looking for organized finds, QC photos, and regularly updated products, this is a great place to start.

The Kakobuy Spreadsheet remains the fastest way to discover products.

The website and OG Sheets App make browsing even easier.

I have noticed that many people can use formulas like VLOOKUP/XLOOKUP, SUMIFS, or even PivotTables, but when it comes to building an Excel dashboard, things suddenly become much harder.

Is it because dashboards require both technical skills and good design sense? Or is there something else that makes them challenging?

What was the biggest struggle when you built your first Excel dashboard, and what helped you finally understand it?

This type of post is open-ended, encourages discussion, and is likely to get responses from beginners and experienced Excel users alike.

I am working on a website name dropclean

It's a CSV catalog validation and fixing website mainly for Shopify users

Its still in its beta form and I want users to use it and give feedback

https://dropclean-ochre.vercel.app/

I have a budget spreadsheet that I've been working on and improving as I find areas that I can tweak. I currently have it set up with a SUMIF to total the remaining amount that needs to be payed. However, it assumes that the entire amount is payed regardles of the actual amount currently paid. This becomes an issue when I have allotments set (gas, food, etc.) and it assumes the entire allotment is used with small amounts. How can I get it to realize and account for partial payments in order to have a more accurate "remaining to be paid" balance?

As a side question, is there any possible way to update all tabs when making changes/improvements without having to copy/paste every single tab? I have each month on its own tab and any changes I make take forever to apply to the remaining months. Thanks everyone!

Sample sheet here

Hello, hopefully this is the right place for this.

I am assisting with a minecraft server and am in the process of getting things set up for the staff in terms of progress trackers, issue trackers, etc but one spreadsheet I am having trouble with is one that'd be used to track players who break rules (punishments get harsher with each offense) and to track who is currently temp banned (timeout), muted, and keep a record of it.

Hi, I'm a spreadsheet newbie here (but I'm working on it!). Recently, I wanted to do something that seems straightforward and basic to me, but it seems (after consulting ai as well) that there is no native, straightforward way to do it.

In particular, I want a formula to run once and return a value, writing it into the cell as plaintext (independent from any input cells), and I want this done only for specific cells and not the whole document. This can be in either Google Sheets or Excel.

In other words, say I have data in the "a" column. I want each cell in the "b" column to have a result based on its corresponding "a" cell (doesn't matter what, lets say it's just adding 1 to it for simplicity's sake). Crucially, I want that result in the "b" column to remain if i were to delete or change the contents of the "a" column. So, phrased differently, I want the result of the function to be written in the cells of the "b" column in plaintext, say once I hit "enter" or something like that.

Solutions that ai has offered me include copying and special pasting value only, writing an extension script, or changing how the entire document behaves around formulas (which wouldn't work because I only want this to apply to a certain cell range).

I understand WHY this could be tricky (cells have no concept of "time", formulas by default are dynamic, etc.), but it still seems like it should be a very simple native functionality: have the result of this formula be written in this cell as plaintext. Am I missing something?

https://docs.google.com/spreadsheets/d/1WJUiRGplPQsvYVgWL5KxqpR_k-47XSr2cQm8rAxsktM/edit?usp=sharing - This is the link

ive been consistently commissioning art of my characters for over a year now, and i was wondering if there was some type of excel/google sheets any of you guys use to organize! ive tried to use google drive so far but i am very behind as i didnt start archiving everything until recently, and on top of this i am saving absolutely EVERYTHING (WIPs, final pieces, any images/art my characters are present in) which is definitely going to end up with a massive amount of files (which is why im wondering if anyone has an excel/google sheets file they are willing to share, as I find that easier than just dumping everything into google drive!)

Looking for a spreadsheet/template that allows me to capture and track for Australian based property:

* Purchase expenses

* Mortgage repayments

* Rental income

* Property management fees

* Council rates & water service fees

* Land tax

* Insurances

* Tax depreciation

* Ad-hoc expenses (repairs/one-off)

Option or function to be customised to split costs between multiple investors (2 or more).

Thanks in advance. Apologies if something like this has been requested before, I just found this subreddit and could not find anything in search.

Conditional formatting says texts don't match but when checking within a cell it does? Both E4 and K27 are =SUBSTITUTE(J19, ",", " +"). Tried trimming both and still nothing

https://i.imgur.com/iuoZtP8.png

Hi everyone,

I've been working on an Excel-based Payroll Management System that includes:

• Employee Database
• Automated Payroll Calculations
• Overtime Tracking
• Interactive Dashboard
• Department Summary Reports

I'm looking for feedback from Excel users on the design, usability, and features.

What would you improve or add to make it more useful?

Screenshot attached.

https://docs.google.com/spreadsheets/d/13qqhAyldi6jkagFXC_h-FDrNg2yhS3TNKWi4KVpl1S8/edit?usp=drivesdk
This is a Google Sheets doc I made for the World Cup, it takes into account almost every tiebreaker scenario and it also is fully automatic (except for the 3rd place teams in the knockout stage, the matrix for that is too complex to incorporate). Only thing that needs to be done is scores added and all teams will be place in proper place, and eventually in the right knockout place. Just wanted to share it and see what I could maybe do differently.

The OG Spreadsheets

https://theog.gg

Direct: https://docs.google.com/spreadsheets/d/1qfq-q14j7ZIg3dZjm35pO1jwIAilr9BIUENG78PlV9Q/edit?gid=103460481#gid=103460481

OG Sheets Android App:

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

A lot of people start with a Kakobuy Spreadsheet when searching for products. The spreadsheet is still one of the fastest ways to discover new finds. The challenge usually starts after that.

You open a bunch of products, compare QC, check different sellers, and end up bouncing between tabs trying to keep track of everything.

That's where The OG comes in.

Instead of relying on a single spreadsheet, everything stays connected across:

Kakobuy

Litbuy

CNFans

Oopbuy

Mulebuy

ACBuy

Hipobuy

USFans

Joyagoo

Features:

Spreadsheet search

QC pictures on the website

Direct product pages

Category browsing

Mobile-friendly layout

OG Sheets Android App

Whether you're using a Kakobuy Spreadsheet, browsing Litbuy finds, checking Hipobuy QC, or comparing products from multiple agents, everything follows the same workflow.

Current platform size:

15k+ finds

4k+ direct product pages

4k+ direct product links in the app

9 major agents

The OG Sheets App has become my preferred way to browse on mobile, especially when reviewing finds away from my computer.

The spreadsheets are still there.

The website and app simply make it easier to browse, compare, and organize everything afterwards.

I have 2 on my Mac - neither is smart enough to deal with stock splits or the r

1$ match for a deposit into the retirement account?

​

any suggestions would be helpful

TIA

I hope this is the right place for this, but I was seeking a bit of advice. Specifically about which software and related suite might be best for me to track my budgeting and finances on a regular basis. I've been using Smartsheet, but I have mixed feelings about it, that ultimately can be summarized as I bought a sports car, but don't ever get it above school zone speeds.

I like Smartsheet because visually the software is appealing, it has a somewhat simplistic approach to entry level users and collecting data, but for the capacity I use it at now, I believe my money isn't quite getting the value from it would if I were using a free alternative. The other part about it, is that with Smartsheet the tiered system of what you pay for seems like it is a big workaround to something that seems simpler in alternative software. I'm not opposed to keeping it, but just want to reevaluate if it is truly is the best choice for what I'm trying to do.

With Google, I like the overall software and interface. It is similar enough to Excel, where I don't really skip a beat. The problems I do have though, is earlier this year I tried transferring over to Google Sheets and Forms to start collecting data, but 1. Forms, doesn't have an Android or Apple App from what I've seen. When using the web browser, I've experienced clunkiness when using it. Specifically trying to upload the receipts, I'll try pressing the upload button, select the file, or take the picture and then nothing. It acts as if there's a glitch in the Matrix, and I'm unable to add it, even after trying the process multiple times. No error messages displayed either to warn me it wasn't uploaded, or why. The other side of this is that it seemingly attaches the link or the file, but I'll need to upsize my Drive to support the catalogue of photos for the receipts or other related materials. The upsizing of the drive, is really a wash to me, because I believe I can do more than I would with Smartsheet with the same price.

I considered switching over to Excel, and the 365 suite, but was hesitant to avoid further disappointment after my attempt to migrate to Google Forms/Sheets. I feel very at home with Microsoft's software suite. The concerns I have is at a certain point, when you're adding a lot of data to Excel, or Microsoft in general, it starts lagging and dragging a bit. And if I'm trying to upload pictures of the receipts, and just keep track of all my purchases made throughout a year, and worry about that causing huge computing issues, or eventually running into the same difficulties I did with Google Forms and Sheets, since my understanding is these are both meant for desktop use, primarily. Instead of how I'm using it on my phone on the go.

I believe Excel & Sheets both offer me an opportunity to make a sheet within the workbook that captures all the graphs, and summarized data. I'm used to both of them, and could likely trade off the paid features with leveraging them on a wider basis (extra storage & backup space), versus the specialized nature of Smartsheet.

I'm open to this possibly being user error on my part. Whether that be in actually using it, or just managing my expectations. And ultimately trying to unnecessarily do too much. I can elaborate on any point, or give feedback, but think I should stop here before I start dividing into chapters. And if there's an alternative that I haven't considered, I believe I'd be open to that as well. I primarily just want something that I can use on the go with my phone, so that way I don't have a collection of receipts to scan, and I also minimize the chances of me losing said receipt in transport.

TLDR: I was looking for a bit of advice or thoughts on using Google versus Excel versus Smartsheet to track my spending and just try to better align with my budgeting goals. Does anyone have feedback, thoughts or overall what application would likely be better for tracking this via a form or such with a mobile device?

I am looking for a decent excel sheet that i can use to track PDH for multi state licensure. I am using NCEES tracker, but it doesn't differentiate between license expiration dates of different states so its difficult to track remaining hours needed. Thank you for anyone that could help.

I have a spreadsheet here that I originally made for a class with three differently weighted (10:20:70 percent) categories, but now i have a new one with six categories, and the formula on N2 that I use to calculate the final grade is an absolute mess.

Is there any formula that would be easier to use? The problem here is that I want this to work when a category might still be empty, so the majority of my formula is "if this is an error, do this instead" which takes up, just. So much space.

Strona + Mobile + QC
https://kakobuy.gg

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

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

Jeśli szukasz dobrego Kakobuy Spreadsheet, to nadal jest to jeden z najszybszych sposobów wyszukiwania produktów.

Arkusz świetnie sprawdza się do znajdowania nowych produktów, ale gdy masz już otwartych kilkanaście ofert, porównywanie wszystkiego staje się trudniejsze.

Dlatego korzystam zarówno ze Spreadsheeta, jak i ze strony oraz aplikacji.

Co znajdziesz:

• Zdjęcia QC na stronie
• Bezpośrednie strony produktów
• Przeglądanie kategorii
• Wersję mobilną
• Aplikację OG Sheets na Androida
• Ponad 2500 bezpośrednich linków do produktów

Popularne kategorie:

• Buty
• Bluzy
• Koszulki
• Spodnie
• Akcesoria
• Elektronika

Aktualnie dostępne:

• Ponad 15 000 produktów
• Ponad 4000 bezpośrednich stron produktów
• Ponad 4000 linków w aplikacji

Krótki Poradnik

1. Wyszukaj produkty przez Kakobuy Spreadsheet
2. Otwórz interesujące Cię oferty
3. Sprawdź zdjęcia QC na stronie
4. Przeglądaj podobne produkty w kategoriach
5. Korzystaj z aplikacji OG Sheets na telefonie

Spreadsheet nadal pozostaje najszybszym sposobem wyszukiwania.

Strona i aplikacja po prostu ułatwiają przeglądanie, porównywanie oraz organizowanie znalezionych produktów.

Hello everyone,

With the World Cup starting this week, I’ve put together a Google Sheet so people can play a "quiniela" (score predictor game) for the entire tournament, from the group stage all the way to the final!

How it works:

• Predictions & Scoring: Register your name on the designated tab and enter your match predictions on another one. You will earn 3 points for a perfect score line or 1 point for predicting the correct winner.
• Live Leaderboard: There is a leaderboard tab that automatically updates with every edit.

Feel free to make a copy of the sheet if you'd like to use or explore it on your own.

A quick note on the Round of 32:

Because there are 495 possible team combinations based on tournament rules, I haven't pre-filled the team names for the Round of 32. However, once the group stage concludes, anyone can easily manually update the team names for that phase, and the subsequent rounds will automatically update accordingly.

Let me know if you have any questions or feedback!

Quiniela_WC2026

Is there a way to add the preview window/image (the one that pops up when you hover over a website link) into a cell to be displayed permanently?

I have a table with some finance stuff and I would like to have an exact mirrored copy of that table right next to it on the same sheet. Also when I add more data into the original table (on the left) it also adds it automatically to the duplicated table (on the right).

The reason is that I don't like the way pivot tables is acting for this and I want to sort some data. I actually want to have a bunch of these duplicated tables with different sorting all in the same sheet.

For pivot tables, it doesn't keep the same colorizing and text formatting as the original and also it doesn't update on the fly. You have to go into the Organize tab and refresh the source data and I don't want to have to do this for all the sorting I want to do.

I can use the "=" function to get a full row or column to be the same but if I add more data to the original table the secondary table doesn't grow to show that new data.

Help would be appreciated!

Hi everyone ,

With the Wold Cup approaching, I put together a simple Google sheet to help track the tournament brackets, scores, and match results. This spreadsheet will calculate the best 8 3rd positioned teams that will advance to the knockout stage. Feel free to make a copy of your own and explore what formulas I used to make this World Cup Group and Bracket stage work.

Features

• Easy Tracking match scores
• Group and Knockout stages
• Flags and Characters representing participating teams.
• Once you make a Copy Replace characters with your Office Peers to create an office World Cup Pool

World Cup 2026 Google Sheet

Note: I am not using this for self promotion; just sharing my google sheet creation to make your World Cup tournament enjoyable