Dynamic Calendar Google Sheets Tutorial + FREE template
HTML-код
- Опубликовано: 21 сен 2024
- In this video I will teach you one of the many ways in which you can create a Dynamic Calendar in Google Sheets. When it comes to calendars there's a LOT that you can play around with so I will keep on making tutorials about them. I hope this one is a good start!
Please let me know your thoughts and thank you so much for watching! 😊👩🏻💻✨
📌 Get the FREE template here: optimistic-app...
Please note: The template is sent automatically to your email (don’t forget to check your promotions folder). It should arrive within a few minutes, if it doesn’t please send an email to hello@thinklikeagirlboss.com
📌 Shop Daily Life and Small Business Spreadsheets:
thinklikeagirl...
📌 Other Google Sheets Tutorials:
thinklikeagirl...
If you followed the tutorial till the end I would love to hear about it in the comments! 😊👩🏻💻✨
#googlesheets #tutorial #productivity #calendar
Thank you so much! i own a small bussiness and had been looking for a way to view my orders in a calendar which used the data of my google sheet for ages!! I didn't know it could be done this way!!
You are the best teacher, my first time making a social media calendar and I could not asked for a better teacher then you! Thank you so Much!!!❤❤
I'm so happy you liked it! Thank you so much for watching!! 😊👩💻✨
I’ve been looking for a smart calendar tutorial for monthsss!!! This was sooo helpful, thank you so much ❤😢😊😊😊😊
I'm so happy you found it useful! Thank you so much for watching!! 😊👩💻✨
I've been looking for this formula for weeks now. Finally I was able to fix my calendar so It could get the data from cells in another sheet. Thank you for sharing!!!
I'm so happy it was useful! Thank you so much for watching!! 😊👩💻✨
If you don’t mind me asking, how do you get the data from another sheet??
THANK YOU, you do not understand how much finding this video means to me, i have been searching for a tracker app or temple for a few days because this is EXACTLY what I wanted but I didn't know how to make it and all the apps were to complex, YOU ARE AMAZING THANK YOU SO MUCH ♥♥♥♥♥♥
Hi! Thank you so much for watching and taking the time to comment! I'm so happy you found it useful! 😊👩🏻💻✨
This was EXACTLY what I needed after struggling to figure out how to do what I wanted to do - thank you!!
Yes, the ctrl key in Windows selects separate columns or cells👌👌
Thank you so much for confirming that!! 😊👩💻✨
Thank you so much for this! Im using this for college this year as im taking 5 classes and working! I totally needed something like this! Just changed it from Tasks to assignments and dates to due dates! Its amazing so far!
I'm so happy to hear you found it useful! Thank you for commenting 😊👩🏻💻✨
Your tutorial was exactly what I was needing for a 4 week trip that I am taking. Your tutorial was very easy to follow. Thank you! 😃
I'm so glad it was helpful!! 😊👩🏻💻✨
Hi, I truly cannot thank you enough for your amazing videos. I did your habit one a couple of months ago and it is working amazing! I was in desperate need of a calendar since uni is starting but I cannot use notion or anything else for the life of me, and I don’t like how every other calendar has the time grid embedded in it. And then I found your amazing video! It saved me! Thank you so much!!!
Wow thank you so much for your comment! I loved reading this! I'm so excited you found them useful 😊👩💻✨
Thank You. You're a life saver. I have been searching for a good tutorial and finally found yours. Now I can even tweak it for my own personal need. Again Thank You 😉😉
Thank you for watching! 😊👩🏻💻✨
I really appreciate this video, it is informative, easy to follow and actually teaches us rather than a magic jump.
I'm so happy you liked it! Thank you for watching! 😊👩🏻💻✨
Thank you so much for such detailed step by step tutorial! Very lucky to discover your RUclips channel here. It made my holiday planning so much easier!
I'm so happy to hear that! Thank you for watching! 😊👩🏻💻✨
My Calendar came out beautiful..... Thank you for such easy & clear instructions..
I'm using windows rn. For the Ctrl key is actually worked! Thank you for ur information! Also for ur tutorial its help me a lot to organized anything! KEEP GOIN BABEEE 💗💗💗💗
I'm so happy you liked it! Thank you so much for watching and commenting! 😊👩💻✨💕
Whoa this was the first video that popped up on my search and is exactly what I needed! I can’t wait to try it tomorrow.
I hope you like it! 😊👩💻✨
Thank you Ma'am...I'm the happiest right now feeling accomplished that I followed along and didn't give up when I thought I messed up. Been wanting to make tasks in calendar style for the longest and you're the only one that I see do it in this style. So thanks again for all the tutorials. I'm a fan!
Hi! I'm so happy you like my videos, I've noticed you commenting on several of them thank you so much!! This motivates me to keep on making them 😊👩🏻💻✨💕
@@thinklikeagirlboss I’m binge watching your whole channel. I love the way you explain your steps short and simple. I’m having so much fun organizing on spreadsheet now. I usually preferred writing things down on printed charts, but not no more! lol
I'm so excited to hear that!! Thank you SO much! 😊👩💻✨💕
For future reference, 99.9999% of what is done with Mac's "Command" button is doable with Windows' "Control" button, even this. You can just say "command on my mac, control for windows" and be sure that you're hardly ever gonna be incorrect, it's literally the same functionality for everything it does, just a slightly different name because Gates and Jobs liked to fight idk
That's great to hear! Thank you so much!! 😊👩💻✨
@@thinklikeagirlbossdo you think making or putting down our task or to do list on paper is better than digital
Jobs is commanding gates is controlling
Love it! I'll never forget now 😂
@@thinklikeagirlboss haha thank you.
Your explanations were so clear and informative (esp. on the commands)! I've never touched or made anything on google sheets but i was able to follow through without a problem.
I'm so happy you were able to follow along!! Thank you so much for watching!! 😊👩💻✨
Thanks so much for this! I'll eventually buy one of the templates, but I also wanted to learn how to do it myself. Now I can!
Thank you so much! I'm so excited you followed the tutorial! 😊👩💻✨
OMG you made this so so so so so simple and easy to understand!! Thank You! I felt like i was in my old computer programming class for a little bit, LOL. GREAT WORK!
Hi! I'm sooo happy you liked it! Thank you so much for watching!! 😊👩🏻💻✨💕
You're a GENIUS!!!! Thank you! This is exactly what I needed!!!!
That's so sweet! Thank you!! 😊👩💻✨
Your video tutorials is always a new and beautiful discovery that I can put into practice the next day to improve my work in the office.
The only change I made is to write the names of the days in Italian, because I'm Italian, but it was already perfect like this.
Thanks again.
Thank you so much!! I'm so happy you find them useful 😊👩🏻💻✨
This video is so underrated. So d*mn good!
I thank you
That's so sweet, thank you so much!! 😊👩💻✨
This tutorial is absolutely flawless!! Thank you for making it!
Thank you so much for watching! 😊👩💻✨💕
Great tutorial. Thank you
You are absolutely genius and the way you explained was super easy to understand‼️‼️‼️ Thank you❤
I'm so happy you liked it!! Thank you for watching! 😊👩💻✨💕
thank you so much for this tutorial .it was easy to apply it now, I manage to create my own calendar.Keep up
Thank you for watching!! 😊👩🏻💻✨
I have added this tutorial to my other calendar tutorials. Thanks for sharing and it was a joy to follow along and create this calendar.
James :)
I'm so happy you enjoyed following along! Thank you so much for watching! 😊👩💻✨
This was sooo helpful, thank you! It was just right, not to easy, not to hard, I just had to slow it down a little!
I'm so glad it was helpful! Thank you so much for following along! 😊👩🏻💻✨
super easy to follow. Thank you!! It came out so nice 👍🏾
Thank you for this! I made one and it's so convenient to use.
I LOVE this. It was easy to follow and easy to apply to other templates. Very informative and very useful. I'm trying to be more organized this semester and I am so grateful that I came across this. Thank you so much for doing what you do.
I'm so happy you found this useful! Thank you so much for watching and I wish you the best in this new semester! 😊👩💻✨
What a great tutorial!!! THANK YOU VERY MUCH! I'm am here for your other videos!
Thank you so much!!! 😊👩🏻💻✨💕
Very helpful and saved me a ton of stress! Thanks
I'm glad it helped! 😊👩💻✨
I thought I'd never be able to learn how to work on a spreadsheet, thanks for proving me wrong
I loved reading this thank you so much for watching!! 😊👩💻✨
hey, thank you so much for this. it was easy to follow and now, I have a calendar in sheet! thank you!
You deserve a whole lot of subscriptions! Lifesaver! Thank you so much!
That's so sweet! Thank you so much!! 😊👩💻✨
Thank you so much! There's not many aesthetically pleasing sheets calendars out there, hopefully this'll help me with my studies! Also learnt a lot of excel!
I'm so happy you liked it!! Thank you so much for watching and commenting! 😊👩🏻💻✨
For anyone with a cromebook, the command button is ctrl. Once you highlight the first column, hold the ctrl button.
Thank you!! 😊👩💻✨
Thanks a lot! Very useful 😍❤
YOU HAVE THE BEST VIDEOS!!!! I CANT THANK YOU ENOUGH
That's so sweet! Thank you so much!! 😊👩🏻💻✨
QUICK QUESTION : I WANT TO ADD A TIME SLOT UNDER EACH DATE, I added =array_constrain(iferror(filter(E$4:E$53,$D$4:$D$53,$C$4:$C$53=G4),),6,1) and the cell doesn’t take the time that says in that cell. I hope this makes sense what am i doing wrong?
This was incredibly helpful and easy to follow. Thank you ❤
I'm glad it was helpful! Thank you for watching! 😊👩🏻💻✨💕
It was control on the Windows thank you for that. And this whole tutorial.
Thank you so much!! 😊👩💻✨
Great!!!! This changes my whole organzing game thankss alottt👍🏽👍🏽
Loved this, very well detailed and very easy to follow, loved how you explained how the formulas worked as well.
I'm so happy you liked it!! Thank you! 😊👩💻✨
really helpful, easy to follow the instructions. thankyou so much
Thank you for watching! 😊👩💻✨
This was amazing. I knew there was a way of doing this, but didn't know how. Thank you!!! :)
thank you this helps a lot
You are by far my favorite google sheet instructor! Your tutorials are organized, clear and informative.
It's so amazing to read this! I'm honored! Thank you so much!! 😊👩🏻💻✨💕
@@thinklikeagirlboss Yay to girlpower! 😘
Thank you for this tutorial this was extremely helpful
yo this tutorial is the best one i watched several of them before this tutorial but it didn't workout well but this one was amazing🤯 that was such a great job🤩🤩🤩
I'm so happy you liked it! Thank you for watching! 😊👩🏻💻✨
Amazingly well explained thanks a lot !!!
Just used it. Thank you so much! This is so useful.
I'm so glad you found it useful, thank you for watching! 😊👩🏻💻✨
Very clear and informative instructional... Thanks! 🔥
Thank you for watching!! 😊👩💻✨
thank you this was the best and it was super fun and easy to understand i cant wait for more of these videos it very fun
I'm so glad you enjoyed it! Thank you!! 😊👩🏻💻✨
Great video! I’m new to all the Google apps but you executed this beautifully. Every action was detailed efficiently without anything extra. Thank you for your time and focused efforts.🙏🏽
Thank you so much!! I'm so happy you liked it! 😊👩💻✨💕
love watching your tutorial videos, Never get bored. Thx so much for sharing
I'm so happy to hear that! Thank you so much for watching them! 😊👩🏻💻✨
Loved this tutorial !!! Thanks so much for sharing.
Thank you for watching and commenting! I'm so happy you liked it! 😊👩🏻💻✨
thank you so much, i really love the way you explain things, its fast, smooth, and clear at the same time. i will learn your others tutorial too❤
Thank you so much! I'm so glad you like it!! 😊👩💻✨💕
easy to follow and excellent tutorial for explaining the functions and reasons for inputs. Thank you so much!
Thank you for watching!! 😊👩💻✨
You explain so well! I'm not savvy with Sheets or formulas, but with your tutorial, everything looks easy. Thank you so much!
Reading this brings me so much joy! I'm so happy you found it useful! Thank you so much for watching and commenting!! 😊👩💻✨
I love all your tutorials, Thank you for sharing ❤
I'm so excited to hear that! Thank you for commenting!! 😊👩💻✨💕
AMAZING TUTORIAL!!!! I LOVE IT! thank you so so much!!
Thank you!! I'm happy you liked it! 😊👩🏻💻✨
So helpful, just what I am looking for! 🎉
I'm glad you liked it! Thank you for watching! 😊👩💻✨
Your tutorial is helpful. Not so hard or easy. Though I just started watched it a few days ago, I've already learnt a lot. ❤❤❤
I'm so glad it was helpful! Thank you for watching and commenting!! 😊👩💻✨
Thank you so so much. I was able to follow your instructions and I created mine. Thank you so much.
THIS IS GENIUS
Thank you!! 😊👩🏻💻✨
LOVE THIS!! Thank you so much for sharing. I'm going to use this for my monthly budget spread. I'll share this tutorial!!
I'm so happy you found it useful!! Thank you so much for sharing it!! 😊👩💻✨
LOVE IIITT, will make me more organised definitely
Amazing video!! Learnt lots of little tricks, great work!
Thank you for sharing this tutorial! This is amazing. I love it so much!!!
I loooove this so much. Thank you for making tutorials!
Thank you so much for watching!! 😊👩💻✨
This was awesome!! It looks great and was so easy to follow. Thank you so much!!
Thank you for watching!! 😊👩💻✨
Thank you so much!! Your tutorial helps a lot!!
Thank you so much! I do love it and how you explained throughout the process perfectly!. thank you!
😍
I'm so happy you liked it! Thank you for watching!! 😊👩💻✨
Awesome tutorial and explanations. I was able to create the spreadsheet while watching the video, copying you exactly. Now I have a working calendar & I'm so happy with it! Thanks so much!!
I'm so excited to read this! Thank you so much for watching and following along! 😊👩💻✨
Thank you so much😍. Your tutorial is very clearly, I will support you.
Hi! I'm so glad you liked it! Thank you so much for watching! 😊👩💻✨
Your video is very helpful & it's created a very easy way to maintain the calendar. Super good way to understand things. Good teaching way 👍🤗
Thank you so much for taking the time to comment!! I'm happy you found it useful 😊👩💻✨
Amazing tutorial. Thank you so much for sharing. Easy to follow and will be using it in my daily organization.
So useful Love it, I can do it from ur VDO ,Thx so much
I'm so happy to hear that!! Thank you so much for watching!! 😊👩💻✨
I can't thank you enough, these are very useful for my business
I'm so happy you like them! 😊👩🏻💻✨
Loved this video SO MUCH!! As a non-Excel or Google Sheets person, this made creating a dynamic calendar an absolute breeze. You've got a new subscriber here 😊❤️
I'm so happy you liked it!! Thank you SO much for subscribing! 😊👩💻✨💕
Yeah, it's ctrl on windows. btw, thank you so much for all your tutorial videos. it really helps a lot. Love you.
Thank you for confirming that! And thank you so much for watching! 😊👩🏻💻✨
You did a great explanation! It was kind of complicated but it was super easy to follow you step by step. Thank you so much!!! ❤
I'm so happy you were able to follow! Thank you so much for commenting! 😊👩🏻💻✨💕
Great tutorial. I just came and really love your spreadsheet templates. Please make more tutorial of how to create interactive dashboard, im sure there are many out there needed that ❤
As someone who struggles with following tutorials this was the easiest tutorial to ever follow! New Subscriber Here
I'm so happy to hear that!! Thank you so much for commenting! 😊👩🏻💻✨
Thank you love this video
It was perfect for a complete novice like me. Thanks!
I'm so glad to hear that! Thank you so much for watching! 😊👩💻✨
This is so awesome! I was able to follow along and even customize/add onto it for my own preferences. I do have a question though. In this video, you write the items in the list and they populate to the corresponding day in the calendar. If I wanted to do the reverse, write the item in the calendar and have it populate to a list, is that possible?
Thank you so much for this video. I'm not even sure how I came across it except that I'm subscribed. The steps were easy to follow and formulas well explained. As a self-proclaimed intermediate level Excel/Sheets user, I learned a few things. You produce wonderful content over and over again.
Hi! Thank you so much!! I'm so happy you found it useful!! 😊👩🏻💻✨
this is what we actually needed, i've been looking for a tutorial how to make a planner, but i ended up on website where they sell the template, that's sad😔😔
Really Enjoyed that and very useful. Thank you.🙂🙂
Thank you for watching!! 😊👩💻✨
Thank you for sharing. It is easy to understand and can execute immediately. ^^
I'm so glad it was helpful!! Thank you for watching!! 😊👩💻✨
Life saver! Thank you.
I'm glad it helped! 😊👩🏻💻✨
Wow very helpful, thank you so much !!
Genius!!! Thank you so much for simply everything ❤
Hi!! Aww thank you!! I'm so glad you found it useful!! 😊👩💻✨💕
Amazing tutorial!!! I am watching this after your video on making your own Habit tracker, and the previous one also helped me a lot! I am trying to be more organized this year and hope this will help! Thank you so much girly, keep doing what you do.
Thank you for the tutorial and the extra formatting tips.
Thank you for watching! 😊👩🏻💻✨
Thank you so much for this video!
Thank you for watching!! 😊👩🏻💻✨