Video není dostupné.
Omlouváme se.
Calendar Checklist Tutorial - How to make a Calendar To-Do List FREE Google Sheets Template
Vložit
- čas přidán 14. 08. 2024
- 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 hello@thinklikeagirlboss.com
📌 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
So helpful. Thank you for taking the time to explain every step.
This is so helpful! Thank you for sharing your knowledge bestie!
Thank you for watching!! 😊👩💻✨
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..
Hi! I'm so happy you find that helpful!! Thank you so much for watching and commenting! 😊👩🏻💻✨
YOUR TUTORIAL IS ABOUT TO ENHANCE MY LIFE! TYSM! :)
woww! Can’t believe I was able to form a calendar planner ❤ Thank you so much!!
I'm so happy you followed the tutorial! Thank you for watching!! 😊👩🏻💻✨
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!!
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 😊👩💻✨
Thank you a lot. I have a lot of ideas, but I don't know how to create them. I saw many CZcams channels selling templates, but I don't have enough money. This video truly helped me a lot.
I'm so happy you liked it! Thank you so much for watching! 😊👩🏻💻✨
I love your tutorials. I'm learning so much! ❤
I'm so happy to hear that! Thank you for watching! 😊👩💻✨💕
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?
Hi! You would have to use Apps Script and some coding behind the scenes 👩💻✨
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 🙏🏻🥹
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?
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.
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
Thank you
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
Is there a way to connect this with your dynamic calendar, Using both together would be great
thank u so muchhhh for making this tutoriallll❤
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.
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!❤
@@matea3690 Thanks for informing. I will check it. 🏵️
You're great. teaching very well. Thank you.
Thank you so much!! 😊👩💻✨
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?
Just what I was searching for! Thank you
I'm so happy you found it useful! Thank you for watching! 😊👩💻✨
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?
Hi! I'm so happy to hear you liked it! Of course you may feature it! Thank you so much! 😊👩💻✨
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?
Hi! Thank you so much!! Have you had a chance to watch this one? Maybe it will help with what you need 😊👩💻✨ czcams.com/video/Y_WRF1uswfE/video.html
@@thinklikeagirlboss thank you!
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!
I'm so happy to hear that! 😊👩💻✨
@@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
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! 😅
Thank you very much! This is a great work!🙏
Thank you for watching! 😊👩💻✨
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
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!❤
Thank you so much for sharing your solution! 😊👩🏻💻✨
@@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
Why well she explained. Thank you
Hello, I was wondering if there is a way to make the tasks remain with the dates once I changed the start date?
You are a Queen!🫵🏽👸
Thank you very much!!!!
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!!
Thankyou so much
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
I'm wondering what to do if the date changes and the content of the text changes accordingly.
Love it. Very good indeed. Can you do google lessons on formulas soon please?
I would love to! Any particular one in mind? 😊👩🏻💻✨
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 😢
How can I copy the task from one date to another when changing dates? Thanks
iloved the way you ... thanks you much
Thank you !
thanks for that
Saya suka ini terimakasih telah membantu
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?
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! 👩💻✨
@@thinklikeagirlboss If you have time, can you make one in the future?
FUE MUY DIFICIL POR EL POR EL IDIOMA PERO VALIÓ LA PENA MUCHÍSIMAS GRACIAS POR COMPARTIR TU CONOCIMIENTO
Gracias por tomarte el tiempo de ver el video! 😊👩🏻💻✨
You are so amazing!!
Thank you so much!!! 😊👩💻✨
Hii! I really like it but I have a question. How do I change the language of the template to spanish?
Hi! You can click on "File" right below the spreadsheet name, then "Settings" and pick a different country from the window that appears 👩🏻💻✨
❤❤❤❤❤❤
at minute 17:26 why i cant do that?
is it possible from the template given to make the task to be 10 or more? 🥺
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 😊👩🏻💻✨
@@thinklikeagirlboss thank u so muchhh!! 🤩
Hello! I registered to get your free template for this calendar, however I did not get any email 😢
Hi! If it's not in your spam or promotions folder can you send an email to hello@thinklikeagirlboss.com? I'll forward you the file manually 😊👩💻✨
Can you teach more? Please 🙏
I definitely will! Thank you for watching my videos! 😊👩🏻💻✨
thank you so much