I’ve been using Google Sheets for regular stuff like tracking expenses and car maintenance logs. But lately I’ve gotten into making some really cool projects with it.
Here are some things I’ve created:
- A complete baseball scorecard with player statistics tracking
- Custom fantasy football league management system
- Two-player Battleship game that actually works
- Multiplayer UNO card game
- Currently building another multiplayer game project
Most of these projects work with just formulas and minimal scripting. My newest game project will probably need more advanced Google Apps Script to function properly.
I’m curious about what creative stuff other people have built. I’ve seen some amazing projects shared in communities like this and would love to get more ideas and inspiration from what others have made.
Back in college I built this huge course scheduling system that automatically caught time conflicts and calculated GPA for different grade scenarios. Had dropdown menus for every class and highlighted conflicts in red. The formulas were a nightmare but saved my butt during registration. Recently I’ve been working on a home inventory tracker with data validation and conditional formatting for warranties and maintenance schedules. Items change color when warranties are about to expire. Best part is the barcode scanning through Apps Script - just scan stuff to add it. Your multiplayer games are insane though - never thought about using real-time collaboration for gaming like that.
wow, that’s really cool! i made a habit tracker too, and sometimes it glows when i hit my goals. also whipped up a simple inventory for my lil biz. but wow, your games sound epic! battleship sounds especially fun.
I built a personal finance dashboard that pulls from multiple sheets and tracks net worth trends plus investment allocations. The trickiest part was getting conditional formatting to change colors based on spending categories and budget limits. Also made a workout log that auto-calculates rest periods and tracks progressive overload. The formulas get crazy when you’re dealing with different rep ranges and weight progressions, but man it’s satisfying when it all works. Your game projects sound awesome though - never thought about using Sheets for interactive stuff like that.