Dynamic Calendar Google Sheets Tutorial + FREE template

Подписаться 28 тыс.

Просмотров 289 тыс.

50% 1

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-apple-336.myflodes...
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:
thinklikeagirlboss.com/
📌 Other Google Sheets Tutorials:
thinklikeagirlboss.com/pages/...
If you followed the tutorial till the end I would love to hear about it in the comments! 😊👩🏻‍💻✨
#googlesheets #tutorial #productivity #calendar

Опубликовано:

22 май 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 527

@chrischoi1648 7 месяцев назад

Amazing tutorial. Thank you so much for sharing. Easy to follow and will be using it in my daily organization.

@thanhhuynhtan7988 7 месяцев назад

Thank you for sharing this tutorial! This is amazing. I love it so much!!!

@Shamekaprophetically Год назад

I’ve been looking for a smart calendar tutorial for monthsss!!! This was sooo helpful, thank you so much ❤😢😊😊😊😊

@thinklikeagirlboss Год назад

I'm so happy you found it useful! Thank you so much for watching!! 😊👩‍💻✨

@jacintagrant2536 11 месяцев назад

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.

@thinklikeagirlboss 11 месяцев назад

I'm so happy you found this useful! Thank you so much for watching and I wish you the best in this new semester! 😊👩‍💻✨

@gracesss1272 Год назад

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!!!

@thinklikeagirlboss Год назад

Wow thank you so much for your comment! I loved reading this! I'm so excited you found them useful 😊👩‍💻✨

@CassyJudith 6 месяцев назад

Thank you for this amazing tutorial. Can not wait. to watch your other tutorials

@TheDesiGurlz 7 месяцев назад

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.

@oluwabunmiayodeji4535 7 месяцев назад

Thank you so so much. I was able to follow your instructions and I created mine. Thank you so much.

@lyra8529 9 месяцев назад

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.

@thinklikeagirlboss 9 месяцев назад

I'm so happy you were able to follow along!! Thank you so much for watching!! 😊👩‍💻✨

@scruzromero 6 месяцев назад

This was amazing. I knew there was a way of doing this, but didn't know how. Thank you!!! :)

@kumartirthankar20 5 месяцев назад

Thank you so much. It helped me a great deal. Really grateful that i checked out your video.

@inthemindsof978 10 месяцев назад

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.🙏🏽

@thinklikeagirlboss 10 месяцев назад

Thank you so much!! I'm so happy you liked it! 😊👩‍💻✨💕

@Yagirlkenzie05 6 месяцев назад

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!

@thinklikeagirlboss 6 месяцев назад

I'm so happy to hear you found it useful! Thank you for commenting 😊👩🏻‍💻✨

@shoto6329 3 месяца назад

hey, thank you so much for this. it was easy to follow and now, I have a calendar in sheet! thank you!

@noinfo7656 Год назад

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!!! ❤

@thinklikeagirlboss Год назад

I'm so happy you were able to follow! Thank you so much for commenting! 😊👩🏻‍💻✨💕

@reenajohn3462 2 месяца назад

My Calendar came out beautiful..... Thank you for such easy & clear instructions..

@user-nt6io8hh3w 10 месяцев назад

Loved this, very well detailed and very easy to follow, loved how you explained how the formulas worked as well.

@thinklikeagirlboss 10 месяцев назад

I'm so happy you liked it!! Thank you! 😊👩‍💻✨

@DebtFreeJessie 10 месяцев назад

LOVE THIS!! Thank you so much for sharing. I'm going to use this for my monthly budget spread. I'll share this tutorial!!

@thinklikeagirlboss 10 месяцев назад

I'm so happy you found it useful!! Thank you so much for sharing it!! 😊👩‍💻✨

@KilaNesti Год назад

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❤

@thinklikeagirlboss Год назад

Thank you so much! I'm so glad you like it!! 😊👩‍💻✨💕

@objeventplanning9900 Год назад

Amazing tutorial! Thank you so much for taking the time to share this with us. I've been stuck in a trance for months trying to figure out to how to do this. Thank you!!

@thinklikeagirlboss Год назад

I'm so glad it was helpful! Thank you so much for watching!! 😊👩‍💻✨

@PalakGarg-yv1qk 4 месяца назад

LOVE IIITT, will make me more organised definitely

@user-nh4rr2yj1n 11 месяцев назад

You are by far my favorite google sheet instructor! Your tutorials are organized, clear and informative.

@thinklikeagirlboss 11 месяцев назад

It's so amazing to read this! I'm honored! Thank you so much!! 😊👩🏻‍💻✨💕

@user-nh4rr2yj1n 11 месяцев назад

@@thinklikeagirlboss Yay to girlpower! 😘

@mariam-mona 6 месяцев назад

Wow very helpful, thank you so much !!

@febriasarela 10 месяцев назад

Thank you! I found it so useful!

@isabelm3636 6 месяцев назад

Amazing tutorial, thanks so much!

@quietstorm3254 Год назад

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!

@thinklikeagirlboss Год назад

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 😊👩🏻‍💻✨💕

@quietstorm3254 Год назад

@@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

@thinklikeagirlboss Год назад

I'm so excited to hear that!! Thank you SO much! 😊👩‍💻✨💕

@knowfact_noshit1972 3 месяца назад

super easy! loved it.

@DaBoogeyman92 2 месяца назад

Amazingly well explained thanks a lot !!!

@_Simnesia_ 11 месяцев назад

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!!

@thinklikeagirlboss 11 месяцев назад

I'm so excited to read this! Thank you so much for watching and following along! 😊👩‍💻✨

@alphamail8974 Год назад

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!

@thinklikeagirlboss Год назад

Thank you so much! I'm so excited you followed the tutorial! 😊👩‍💻✨

@kensioson1644 Год назад

I loooove this so much. Thank you for making tutorials!

@thinklikeagirlboss Год назад

Thank you so much for watching!! 😊👩‍💻✨

@bootsonthebeachdancing 11 месяцев назад

easy to follow and excellent tutorial for explaining the functions and reasons for inputs. Thank you so much!

@thinklikeagirlboss 11 месяцев назад

Thank you for watching!! 😊👩‍💻✨

@marileecruz 11 месяцев назад

What a great tutorial!!! THANK YOU VERY MUCH! I'm am here for your other videos!

@thinklikeagirlboss 11 месяцев назад

Thank you so much!!! 😊👩🏻‍💻✨💕

@valentinam3224 Год назад

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!

@thinklikeagirlboss Год назад

I'm so happy you liked it!! Thank you so much for watching and commenting! 😊👩🏻‍💻✨

@madelinebancroft5910 4 месяца назад

This tutorial is absolutely flawless!! Thank you for making it!

@thinklikeagirlboss 4 месяца назад

Thank you so much for watching! 😊👩‍💻✨💕

@danielscott1603 5 месяцев назад

Amazing video!! Learnt lots of little tricks, great work!

@conniepatton9394 4 месяца назад

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! 😃

@thinklikeagirlboss 3 месяца назад

I'm so glad it was helpful!! 😊👩🏻‍💻✨

@melanievans Год назад

You explain so well! I'm not savvy with Sheets or formulas, but with your tutorial, everything looks easy. Thank you so much!

@thinklikeagirlboss Год назад

Reading this brings me so much joy! I'm so happy you found it useful! Thank you so much for watching and commenting!! 😊👩‍💻✨

@iLoveGD-ru3xq Год назад

I love all your tutorials, Thank you for sharing ❤

@thinklikeagirlboss Год назад

I'm so excited to hear that! Thank you for commenting!! 😊👩‍💻✨💕

@nkuliscorner_ZA 8 месяцев назад

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 😊❤️

@thinklikeagirlboss 8 месяцев назад

I'm so happy you liked it!! Thank you SO much for subscribing! 😊👩‍💻✨💕

@momlifechronicles.17 6 месяцев назад

Thank you so much for sharing this step by step tutorial.

@everlastingideas8625 3 месяца назад

Thank you for this tutorial this was extremely helpful

@Rascreia 5 месяцев назад

thank you! so helpful!

@u.s.andeeson 15 дней назад

Thank you so much!! Your tutorial helps a lot!!

@ching2830 Год назад

Thank you so much! I do love it and how you explained throughout the process perfectly!. thank you! 😍

@thinklikeagirlboss Год назад

I'm so happy you liked it! Thank you for watching!! 😊👩‍💻✨

@ggbiconstructionandsupply3402 Год назад

You deserve a whole lot of subscriptions! Lifesaver! Thank you so much!

@thinklikeagirlboss Год назад

That's so sweet! Thank you so much!! 😊👩‍💻✨

@hajie9134 10 месяцев назад

Thank you for this! I made it and the tutorial was very easy! I just have to think on how I'll input the time for the events.

@Tamizhamudhini 2 месяца назад

Awesome video. Thank you!

@sonalijain868 4 месяца назад

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!!!❤❤

@thinklikeagirlboss 3 месяца назад

I'm so happy you liked it! Thank you so much for watching!! 😊👩‍💻✨

@ColeJohnson-rs6mc 6 месяцев назад

Thanks for this!!

@denineblevins2141 22 дня назад

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.

@thinklikeagirlboss 21 день назад

I hope you like it! 😊👩‍💻✨

@kudasai2642 2 месяца назад

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 ❤

@FacebookAds-sv9lr 4 месяца назад

this is very helpful. thank you

@ItsSimplyPhina 5 месяцев назад

This was incredibly helpful and easy to follow. Thank you ❤

@thinklikeagirlboss 5 месяцев назад

I'm glad it was helpful! Thank you for watching! 😊👩🏻‍💻✨💕

@elizabethrcrandall6877 Год назад

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!

@thinklikeagirlboss Год назад

I'm so glad it was helpful! Thank you so much for following along! 😊👩🏻‍💻✨

@monicahampton5938 11 месяцев назад

Thank you for the tutorial and the extra formatting tips.

@thinklikeagirlboss 11 месяцев назад

Thank you for watching! 😊👩🏻‍💻✨

@laurinpatton Год назад

Loved this tutorial !!! Thanks so much for sharing.

@thinklikeagirlboss Год назад

Thank you for watching and commenting! I'm so happy you liked it! 😊👩🏻‍💻✨

@striplofly 11 месяцев назад

I love your tutorial & explanations! So clear & easy to follow along 💯 I was a computer science student and a programmer before but don't really learn or use spreadsheets properly. After watching this video, I was so surprised that doing spreadsheets is really similar with doing coding 😂 The difference is this time, I'm the one using the build-in function in spreadsheet not coding the function logic. I think my past knowledge will be so useful to learn spreadsheet faster. I believe never too late to learn something new & here I am learn how to use spreadsheet in 2023. Definitely will do all the tutorials that you shared here. Thank you so much for the tutorial, done liked and you just have a new subscriber! 🤩🥳

@thinklikeagirlboss 11 месяцев назад

Hi! I loved your comment! Thank you for taking the time! I was also a programmer which is probably why you connect with the way I explain things 😊👩🏻‍💻✨ Your past knowledge will be perfect for this stuff! I hope you like the other tutorials and thank you so much for subscribing!! 😊👩🏻‍💻💕

@cutiepieee13 Месяц назад

Thank u so much, really helpful!❤

@kriszzzz6155 17 дней назад

love watching your tutorial videos, Never get bored. Thx so much for sharing

@thinklikeagirlboss 17 дней назад

I'm so happy to hear that! Thank you so much for watching them! 😊👩🏻‍💻✨

@germiadougan796 Год назад

Genius!!! Thank you so much for simply everything ❤

@thinklikeagirlboss Год назад

Hi!! Aww thank you!! I'm so glad you found it useful!! 😊👩‍💻✨💕

@TheOriginalOrkdoop Год назад

I just finished following along and this tutorial was perfect! It is not too hard but not too easy. You are so talented! I am looking forward to learning more so that one day I can make a custom bill tracker for myself. I like this format as a base to keep track of monthly bills. I need to find a way to copy it for each month so that I don't have to retype the bills and dates each month. Big Thank YOU!

@thinklikeagirlboss Год назад

Hi! I'm so glad you like it! Thank you so much! You could fill a tab with just the basic information and have that be your blank original from which you create tab duplicates each month 😊👩🏻‍💻✨

@TheOriginalOrkdoop Год назад

@@thinklikeagirlboss Ya I could try that 🤔 Thank you!

@kaylone.7366 11 месяцев назад

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.

@thinklikeagirlboss 10 месяцев назад

Hi! Thank you so much!! I'm so happy you found it useful!! 😊👩🏻‍💻✨

@birasaclarisse4325 8 месяцев назад

thank you so much for this tutorial .it was easy to apply it now, I manage to create my own calendar.Keep up

@thinklikeagirlboss 8 месяцев назад

Thank you for watching!! 😊👩🏻‍💻✨

@vikkiadkinson8241 6 месяцев назад

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!

@thinklikeagirlboss 6 месяцев назад

Hi! I'm sooo happy you liked it! Thank you so much for watching!! 😊👩🏻‍💻✨💕

@dcon1234 9 месяцев назад

So helpful, just what I am looking for! 🎉

@thinklikeagirlboss 8 месяцев назад

I'm glad you liked it! Thank you for watching! 😊👩‍💻✨

@vendea8724 Год назад

Just used it. Thank you so much! This is so useful.

@thinklikeagirlboss Год назад

I'm so glad you found it useful, thank you for watching! 😊👩🏻‍💻✨

@lene_29 10 месяцев назад

Thank you so much!!!

@lauras616 9 месяцев назад

You're a GENIUS!!!! Thank you! This is exactly what I needed!!!!

@thinklikeagirlboss 9 месяцев назад

That's so sweet! Thank you!! 😊👩‍💻✨

@user-ip8hd2eo2d Год назад

AMAZING TUTORIAL!!!! I LOVE IT! thank you so so much!!

@thinklikeagirlboss Год назад

Thank you!! I'm happy you liked it! 😊👩🏻‍💻✨

@nicfergus 9 месяцев назад

Very clear and informative instructional... Thanks! 🔥

@thinklikeagirlboss 9 месяцев назад

Thank you for watching!! 😊👩‍💻✨

@kayssayoanna22 8 месяцев назад

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

@thinklikeagirlboss 8 месяцев назад

I'm so glad you enjoyed it! Thank you!! 😊👩🏻‍💻✨

@06.phamvomybinh44 Год назад

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. ❤❤❤

@thinklikeagirlboss Год назад

I'm so glad it was helpful! Thank you for watching and commenting!! 😊👩‍💻✨

@deepalik927 11 месяцев назад

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 👍🤗

@thinklikeagirlboss 11 месяцев назад

Thank you so much for taking the time to comment!! I'm happy you found it useful 😊👩‍💻✨

@najwarahmatia496 2 месяца назад

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 💗💗💗💗

@thinklikeagirlboss 2 месяца назад

I'm so happy you liked it! Thank you so much for watching and commenting! 😊👩‍💻✨💕

@maryamfama 2 месяца назад

really helpful, easy to follow the instructions. thankyou so much

@thinklikeagirlboss 2 месяца назад

Thank you for watching! 😊👩‍💻✨

@shreyasae 8 месяцев назад

You are a Life Saver

@user-wm1se9sv1t 6 месяцев назад

Thank you soo much❤❤❤

@UltimateVisionFilms 2 месяца назад

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!!!

@thinklikeagirlboss 2 месяца назад

I'm so happy it was useful! Thank you so much for watching!! 😊👩‍💻✨

@user-kp5tc2io9k 11 часов назад

If you don’t mind me asking, how do you get the data from another sheet??

@caseykellum3046 Год назад

This was so easy to follow, thank you!

@thinklikeagirlboss Год назад

I'm so glad you found it easy to follow! Thank you so much for watching! 😊👩🏻‍💻✨

@limpak-id3og 4 месяца назад

great tutorial thank you

@user-nh6yw6uu4j 6 месяцев назад

Life saver! Thank you.

@thinklikeagirlboss 6 месяцев назад

I'm glad it helped! 😊👩🏻‍💻✨

@Kay_McRae 13 дней назад

This was awesome!! It looks great and was so easy to follow. Thank you so much!!

@thinklikeagirlboss 11 дней назад

Thank you for watching!! 😊👩‍💻✨

@RSG1758 10 месяцев назад

Grateful to come across your channel. I have learned so many things in google sheets as I am more used to excel. Just want to ask how can I conditionally format background color in the main calendar in relation to events? I am having a hard time formatting it. I think it needs a formula on the conditional format but can't figure it out. Thanks! Looking forward to more content!

@user-od4pz4he3b 5 месяцев назад

Thank you so much for this video!

@thinklikeagirlboss 5 месяцев назад

Thank you for watching!! 😊👩🏻‍💻✨

@user-io7ux4bi9t 27 дней назад

Thank you so much😍. Your tutorial is very clearly, I will support you.

@thinklikeagirlboss 26 дней назад

Hi! I'm so glad you liked it! Thank you so much for watching! 😊👩‍💻✨

@user-oe5nt6jf9x Год назад

This is super useful! Thank you!

@thinklikeagirlboss Год назад

I'm glad you found useful! Thank you for watching! 😊👩🏻‍💻✨

@angelagreen4091 9 месяцев назад

Thank you so much for taking the time out to post, this is the closest thing I can find to what I need. I have 1 sheet that list all pending court hearings for clients, can I get it to auto populate in chronological order on the list on the left and the planner? Or just auto populate from another sheet, I’ll use the list next to the planner to schedule in person appointments. I should be able to autopopulate the planner from another sheet. Also, adding a time would be helpful, but that’s just adding another column to the list and planner and adjusting the formula. Again, thanks!