Calendar Checklist Tutorial - How to make a Calendar To-Do List FREE Google Sheets Template

In today's tutorial I'm going to show you how to create a Calendar Checklist in Google Sheets from scratch. I hope you like it and find it useful! 😊👩🏻‍💻✨
📌 Get the FREE Template:
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 [e-mail]
📌 Need a more advanced version? Check out the 12 Month Calendar To-Do List:
Watch the Video Tour: • Calendar Checklist Tem...
Shop the Spreadsheet: thinklikeagirl...
📌 Other FREE Tutorials: thinklikeagirl...
📌 Shop Templates: thinklikeagirl...
#calendar #spreadsheet #tutorial #googlesheets #googlesheetstutorial #spreadsheetskills #checklist #todolist #template #tutorial #howto

[@suaverealmproductions]

YOUR TUTORIAL IS ABOUT TO ENHANCE MY LIFE! TYSM! :)

[@nwinburn]

Your tutorials are just amazing!! I'm from Mexico, but I went to college in the US and lived there for 12 years. You sound like my female friends from LatAm! I've seen many of your videos, and I don't think you've ever said your name! Thank you so much for making our lives easier with spreadsheets!!

[@thinklikeagirlboss]

Hi! Thank you so much for watching them!! My name is Pao 😊 there's a tiny section on my website where I mention it ... I'm a bit of an introvert and 100% latina, you nailed it 😊👩‍💻✨

[@QuỳnhTrịnhNhư-i2e]

Thank you a lot. I have a lot of ideas, but I don't know how to create them. I saw many KZbin channels selling templates, but I don't have enough money. This video truly helped me a lot.

[@thinklikeagirlboss]

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

[@Lakshmi-q9p3h]

Got it till the end,,,😊 What i liked the most is you're explaining the meaning of the every formula instead of just showing it & make it copy paste..

[@thinklikeagirlboss]

Hi! I'm so happy you find that helpful!! Thank you so much for watching and commenting! 😊👩🏻‍💻✨

[@ivysagrado9973]

So helpful. Thank you for taking the time to explain every step.

[@mommypre]

woww! Can’t believe I was able to form a calendar planner ❤ Thank you so much!!

[@thinklikeagirlboss]

I'm so happy you followed the tutorial! Thank you for watching!! 😊👩🏻‍💻✨

[@AravindAji-q7i]

Awesome Tutorial and i really liked the way you explained everything so slow. Thankyou.

[@thinklikeagirlboss]

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

[@myhriahyoung6235]

Thank you, this was very helpful! I learned a tone.

[@peace.n.blessings5579]

Just what I was searching for! Thank you

[@thinklikeagirlboss]

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

[@lunatuna375]

This is so helpful! Thank you for sharing your knowledge bestie!

[@thinklikeagirlboss]

Thank you for watching!! 😊👩‍💻✨

[@LeoochEnzo]

I love your tutorials. I'm learning so much! ❤

[@thinklikeagirlboss]

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

[@Lets_care]

Thank you so much for making this, really appreciate it🍀. But I faced a problem, the completed task is not showing in %. Its taking 1 as 100% and 50 as 0.5 and so on and I don't think I made a mistake in following as I have checked multiple times, though I can be wrong.

[@matea3690]

Yeah I've got the same problem, i found a solution just a minute ago. So here are the steps: 1. Click on the box (D7 in video) and go to format in Home tab 2. You should see the tab "Number" 3. Click on arrow next to it and click on percent. Maybe you got it right after 3rd step, but i got a problem with decimals. So incase you would have same problem here: 4. Again click on the box and go to the tab below the Home tab(idk the name of it.) 5. There should be a button that shows like .0 and arrow, so click on it till you get a clear percentage. Hope this helps! Have a nice day/night!❤

[@Lets_care]

@@matea3690 Thanks for informing. I will check it. 🏵️

[@kobipeeri1788]

You're great. teaching very well. Thank you.

[@thinklikeagirlboss]

Thank you so much!! 😊👩‍💻✨

[@greenlibertea5394]

You are actually the absolute best!!!

[@thinklikeagirlboss]

Thank you!! 😊👩‍💻✨

[@TusharPrajapati-e6z]

your video is so amazing I love it thank you for making this video which help in my work easy and understand

[@nash7092]

Thank so muchhh!! You saved my life, i need this template for my important upcoming exam in a month 😭🤍 i just hope i will pass the exam 🙏🏻🥹

[@jeneteokeke3116]

I really loved this. It was so helpful! I want to create it for the year but am trying to figure out how to differentiate the months by color do you have a tutorial or some pointers on how to make the colors conditional by the month displayed?

[@jeneteokeke3116]

and possibly how to color out the days that are not in that month?

[@PatriciaGaliBlando]

such a helpful file. thank youuu

[@miquaelpolk3062]

Hi! I love this- just what I was looking for and easy to follow! However, is there a code that stops the recurring task when I switch the month or do I have to create a sheet for each month?

[@とむ-d2c2l]

Thanks for the great video! I was able to build my table with the help of your video. May I feature this video on my blog?

[@thinklikeagirlboss]

Hi! I'm so happy to hear you liked it! Of course you may feature it! Thank you so much! 😊👩‍💻✨

[@g.jayavishnuteja7905]

Hello there every thing is fine but I'm facing an issue, once if I'm changing my date accordingly the tasks in that following date should change right but I'm not able to change that, whatever the task I fill they will be like that only in that place and only date is changing, pls let us how to make that one also as a dynamic field

[@Javouqg07gwougaipba]

Omg woww, this is soo amazing! S glad I stumbeled across your humble youtube channel :D, this is exactly what I need as a student in college!

[@thinklikeagirlboss]

I'm so happy to hear that! 😊👩‍💻✨

[@Javouqg07gwougaipba]

@@thinklikeagirlboss Your channel is really helpful! I would also just like to let you know that I emailed you about some problems I am facing on google sheets. More details in the email :) Just thought I should let you know incase the email goes to spam or something. Thank you

[@kashvibansal7952]

Thank you for such a wonderful and descriptive tutorial! You explained everything so well and every step was so easy to understand! I'd like to draw your attention to one thing though... When we fill the dates with our to-do lists, then if we edit the start date, the tasks do not move with the dates. Can you suggest a step so that my tasks get attached to their respective date, and when I move the start date, the tasks move too?

[@soloKnight813]

Is there a way to connect this with your dynamic calendar, Using both together would be great

[@ubbenw7870]

Thank you very much! This is a great work!🙏

[@thinklikeagirlboss]

Thank you for watching! 😊👩‍💻✨

[@arinpngr]

thank u so muchhhh for making this tutoriallll❤

[@AleanaXiong]

This was so great! You are so creative. How did you learn these steps and formulas? Where can we learn and familiarize ourselves with spreadsheet?

[@thinklikeagirlboss]

Hi! Thank you! I didn't learn from a specific resource. I think about what I want to create, and how I want it to behave, and then I Google anything I don't know. I learned by making things 😊👩🏻‍💻✨ If you would like to watch some other free tutorials you can find a list of the ones I have available here: thinklikeagirlboss.com/pages/free-youtube-tutorials And if you're looking for something a bit more advanced, you can take a look at this course: thinklikeagirlboss.thinkific.com/courses/daily-schedule-tutorial-google-sheets I hope this helps! 😊👩🏻‍💻✨

[@mariamfaqihi2506]

i just want to say thank you! its my first time and im able to complete, just the problem with the %. it still shows as decimal on tasks but ill try it again. love this

[@matea3690]

Yeah I've got the same problem, i found a solution just a minute ago. So here are the steps: 1. Click on the box (D7 in video) and go to format in Home tab 2. You should see the tab "Number" 3. Click on arrow next to it and click on percent. Maybe you got it right after 3rd step, but i got a problem with decimals. So incase you would have same problem here: 4. Again click on the box and go to the tab below the Home tab(idk the name of it.) 5. There should be a button that shows like .0 and arrow, so click on it till you get a clear percentage. Hope this helps! Have a nice day/night!❤

[@thinklikeagirlboss]

Thank you so much for sharing your solution! 😊👩🏻‍💻✨

[@mariamfaqihi2506]

@@thinklikeagirlboss thank you,! id like to ask also if there's a way that i can just creat like a (April) calendar and if i switch to (May) it will only show May calendar and a new sheet / page ? because when i try to go to May - my tasks from April is still showing even though the month is changed from april to may .. do you also have a tutorial for that also ? thank you

[@juliettecabrera6532]

Great tutorial! Is there a way to change the date and have the info in the cell go with the date, not disappear but just stay with that particular date. So when I’m moving from day to day it changes? Does that make sense?

[@thinklikeagirlboss]

Hi! You would have to use Apps Script and some coding behind the scenes 👩‍💻✨

[@nirmalachandran2047]

Why well she explained. Thank you

[@giahunghoang6624]

I love your tutorials. It saves me so much. But could you please help me answer something? When I've already ticked the box and then changed the date, the tick is still present, I think it's much better if the tick appears or disappears should based on the date we chose but I don't know how to do that. I hope for your response so much.

[@AMBOKMUHAMMADFIRDAUSBINIMRAN]

i am trying to overcome the same issue too, have you tried conditional formatting?

[@mauriciofrancocarabelos9826]

Hi, greetings from Spain! As I was following your tutorial a question pop up to my mind: what if I don't want the sparkline progress bar to be referred to a cell with a %? what's the range I should take as a data? Check boxes? Tasks? Both? Or maybe the formula is a little bit more complex? Thanks and I hope you understand my question since English is not my first language and sometimes I use broken English! 😅

[@biancapolidario6378]

Is it possible if I change the start date the tasks will also update?

[@youneedjinsus8656]

You are simply awesome 🤩

[@thinklikeagirlboss]

Thank you!!! 😊👩‍💻✨

[@fz6094]

I love the work you do! Your explanations are so good! Thanks so much for this! (My personal favourite is your habit tracker tutorial ❤, i like this one too) If you dont mind me asking (plz feel free to ignore❤) can you share a tutorial on how to make tasks going up to days to deadline? Like a countdown to deadline with tasks completed?

[@thinklikeagirlboss]

Hi! Thank you so much!! Have you had a chance to watch this one? Maybe it will help with what you need 😊👩‍💻✨ kzbin.info/www/bejne/j5C6g3lnqtiqnKc

[@fz6094]

@@thinklikeagirlboss thank you!

[@karmatingz5797]

Love it. Very good indeed. Can you do google lessons on formulas soon please?

[@thinklikeagirlboss]

I would love to! Any particular one in mind? 😊👩🏻‍💻✨

[@sparklingjewelscandles4283]

Thank you !

[@sonalikulkarni3192]

Thankyou so much

[@givensetshedi6239]

Thank you

[@pranoti7]

Thank you very much!!!!

[@bahterarizkyananda]

iloved the way you ... thanks you much

[@royalsmiggy]

Hi, if i put tasks on a specific date, say September 1, 2024, then i change the calendar date, example October 5, the tasks i input on September 1 carry over. If you can help me. Thanks

[@viewvalyn1750]

I'm wondering what to do if the date changes and the content of the text changes accordingly.

[@EsnikBully]

hi your template is great! but the problem I encounter is the task that I input on the target date did not retain on that date. If I will change the date from july to july 15 the task on july 15 will retain on he same cell but change the date. What formula should I use thanks

[@DecimaUmum]

Saya suka ini terimakasih telah membantu

[@eznj-tu7bt]

Hello, I was wondering if there is a way to make the tasks remain with the dates once I changed the start date?

[@zosantaliz1700]

Hello! I wanted to ask if i theres some way to change the date and also the tasks that i had for that day. So for example, if in the To-Do part i have writting "walk the dog" for the 11 of march, and i change the date for the 7 of march, i still want to see "walk the dog" on the 11 not the 7, Thank you very much!!

[@lloydieyanga2328]

How can I copy the task from one date to another when changing dates? Thanks

[@joyannesykay9594]

Do you know how to add a cat icon to the progress bar? i really want to add a cat icon to the progress bar.

[@AmaniEsmail-iz6pc]

thanks for that

[@nguyenthianh4166]

Could u explain for me about this? I researched and watched sevaral times. I dont know which errors when I click 14/2, todo list of 12/2 will present not 14/2 😢

[@bigc716]

I have a question I'm making a monthly income spreadsheet for 2024 and I also want to include the average of my monthly income. Is it possible to make an average function that will include the entire intended range in the function(all 12 cell for monthly income) but will automatically not include the cells that don't have a value yet. So for example I currently only have my monthly income plugged in for Jan and Feb. I would like the result of the function to be (Jan + Feb)/2 and for it to automatically update when I plug in Mar... (Jan + Feb+ Mar)/3. I'm new to spreadsheets so I hope I explained the issue clearly. I appreciate the help. Thanks

[@ShakilAhmed-jb6se]

You are so amazing!!

[@thinklikeagirlboss]

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

[@opelmarketingss]

if i click on the start date the calender date is starting but the task was not updating it is fixed what to do

[@thinklikeagirlboss]

Hi! Since the tasks are just plain text you entered manually they will always remain where you entered them. Dates move around because those are formulas. If you're looking for something more dynamic you can check this one out: kzbin.info/www/bejne/bpKUmGetbbKVmac

[@eluney4585]

Hii! I really like it but I have a question. How do I change the language of the template to spanish?

[@thinklikeagirlboss]

Hi! You can click on "File" right below the spreadsheet name, then "Settings" and pick a different country from the window that appears 👩🏻‍💻✨

[@AleishaCamilleri]

Great tutorial but when I change the date, the tasks don’t move with the date they were assigned under, I noticed it was the same on your tutorial. How do I change this so that that tasks stay with their assigned date?

[@thinklikeagirlboss]

Hi! This is a simple version. Once you set the start date and begin to add tasks you're not supposed to change the date. If you change the date the tasks will remain in the cells in which you added them. If you want tasks to be moved around to different cells you would have to use Apps Script and some coding behind the scenes. I don't have a tutorial for that functionality at the moment I'm sorry! 👩‍💻✨

[@inevitably_snow]

@@thinklikeagirlboss If you have time, can you make one in the future?

[@urmoonlitup]

is it possible from the template given to make the task to be 10 or more? 🥺

[@thinklikeagirlboss]

You can insert rows in the middle of each weekly section 😊 You can also learn how to make it yourself by watching the video and just adding more rows when you reach that step 😊👩🏻‍💻✨

[@urmoonlitup]

@@thinklikeagirlboss thank u so muchhh!! 🤩

[@KarolBrighiteChipanaGutierrez]

FUE MUY DIFICIL POR EL POR EL IDIOMA PERO VALIÓ LA PENA MUCHÍSIMAS GRACIAS POR COMPARTIR TU CONOCIMIENTO

[@thinklikeagirlboss]

Gracias por tomarte el tiempo de ver el video! 😊👩🏻‍💻✨

[@hanunananana]

at minute 17:26 why i cant do that?

[@chayenn607]

i have a problem the list dont move when i swicth the day

[@thinklikeagirlboss]

Hi! Since the tasks are just plain text you entered manually they will always remain where you entered them. Dates move around because those are formulas. If you're looking for something more dynamic you can check this one out: kzbin.info/www/bejne/bpKUmGetbbKVmac

[@dreams2result]

Hello! I registered to get your free template for this calendar, however I did not get any email 😢

[@thinklikeagirlboss]

Hi! If it's not in your spam or promotions folder can you send an email to [e-mail]? I'll forward you the file manually 😊👩‍💻✨

[@victoryvictorious633]

❤❤❤❤❤❤

[@Anousunder9815]

Can you teach more? Please 🙏

[@thinklikeagirlboss]

I definitely will! Thank you for watching my videos! 😊👩🏻‍💻✨

[@KEHLATSWAYOENTERTAINMENT]

Please marry me❤💍, This is absolutely amazing, its aesthetic, its everything. Thank you very much

[@thinklikeagirlboss]

Hi! That's so sweet! I'm so happy you like it! Thank you so much for watching 😊👩🏻‍💻✨

[@020shlokpandey5]

Pls help me in this

[@hoangkha.marketer]

thank you so much

[@givensetshedi6239]

You are a Queen!🫵🏽👸

[@thinklikeagirlboss]

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

[@lanzandreiii]

thank you thinkergilmore