I’ve created various personal spreadsheets for tracking expenses, car repairs, gas costs, and similar stuff. But I’ve also built some really cool projects like:
• an elaborate scorebook for tracking baseball games and player statistics
• a personalized fantasy football management system
• a two-person Battleship game that actually works
• a multiplayer UNO card game
• currently developing another multiplayer game project
Most of these projects run purely on formulas with minimal scripting involved. However, my latest game project will probably require more sophisticated scripting to function properly.
What cool creative stuff have you built? I’m always amazed by the innovative projects people share in this community. Would love to see what others have come up with.
I built a project management dashboard that handles client timesheets, invoicing, and payment tracking all in one place. The coolest part was making dynamic Gantt charts with just conditional formatting and date formulas - no add-ons needed. Just wrapped up a recipe database that auto-scales ingredients based on serving size and calculates nutrition per portion. The formulas get crazy when you nest multiple functions, but it’s totally worth it. Also made a workout generator that creates random routines based on what equipment you have and which muscles you want to hit. Sheets is amazing when you really push it with complex logic and cross-sheet references.
Those multiplayer games sound awesome! I’ve built some wild stuff too but hit the same walls when making them truly interactive.
My best project was an automated tournament bracket that pulled player data from multiple sources, calculated rankings, and sent notifications. The real magic happened when I hooked it up to external APIs and webhooks.
But here’s the problem - Google Sheets gets messy fast for real multiplayer stuff. You’re constantly fighting refresh rates, concurrent edits, and formula conflicts. Scaling becomes a total nightmare.
I ditched that approach and started building these as proper workflows instead. Way cleaner for handling game logic, player states, and real-time updates. You can still use Sheets for data but let automation do the heavy lifting.
For your game project, build the core mechanics outside Sheets and just use it for scorekeeping and display. You’ll dodge tons of scripting headaches.
Latenode makes this dead simple - connect your Sheet to game logic, external databases, notifications, whatever you need. Way more powerful than cramming everything into formulas and scripts.
I made a habit tracker that auto-calculates streaks and shows progress charts with conditional formatting. The trickiest part was getting the calendar view to update each month without breaking all the formulas. Also built a book reading log that links to ratings and spits out stats by genre, author, and completion dates. The key with Google Sheets projects is getting creative with array formulas and pivot tables instead of leaning on scripts. Your battleship setup sounds cool - bet you did some clever coordinate mapping with data validation for the inputs.
wow, that’s really cool! I’ve done a progress tracker that shows milestones with colors, and a meal planner that makes shopping lists. but battleship? that sounds epic! how do u manage the game mechanics without a lot of scripting?
I built a personal inventory system that tracks everything I own by room and category. The tricky part was getting barcode scanning to work with Google Forms - now I scan items with my phone and they automatically show up on the main sheet with timestamps and location data. The game-changer was using IMPORTXML to grab product details from online databases based on the barcode numbers. It keeps current values for insurance and alerts me when warranties expire. Another project that caught me off guard was a car maintenance predictor that looks at my driving patterns and suggests when to service my car. It takes mileage data from a simple mobile form and compares it with manufacturer recommendations to create custom maintenance schedules. The formulas got crazy complex but it’s surprisingly accurate.
that sounds super useful! i made a budget tracker too but never thought of using regression. your password checker sounds clever! i really gotta explore QUERY and regex combo more. it’s crazy what sheets can do if u dig deeper!