A ready-to-use Google Sheets calendar template for 2023 (plus how to make it appear as an app on your phone). Sounds useless... It isn't.
I'll skip past the "why". You're here, so there must be a reason.
Click to create your own copy
This thing is pretty self-explanatory. I'll only call out a few points:
There's conditional formatting so that <today> gets highlighted blue
It's intentionally narrow. That's so that it renders better on your phone
There's a key for color-based "Tags" up top. On my calendar, I use the tags to indicate where I was or will be on a given day (I travel a lot). Here's a snapshot
How to create an iPhone App Icon (optional, but I like it):
Here it is in action:
Here's how you do it: (iPhone only)
Make sure you have the Sheets app downloaded to your phone
Follow these instructions (the first response is exactly what I did, except I typed "googlesheets://" rather than "googledocs://"). Here's me doing it:
(Updated 12/26/2022)
Let me know what you think!
I have to say, this Google Sheets calendar template is such a simple yet practical tool! I love how it's designed to be phone-friendly, and the conditional formatting to highlight the current day is a nice touch. The color-based tags are also a great idea for staying organized, especially for someone who’s always on the go. Plus, the step-by-step on making it an app icon makes it super convenient. It might not have all the bells and whistles of Google Calendar, but sometimes less is more, and this is perfect for quick and easy access. Thanks for sharing!