I have just created my own version by watching this vid and following the instructions. I've made a little bit of changes to suit my needs. Thanks for this!
Thank you a lot. I have a lot of ideas, but I don't know how to create them. I saw many TH-cam channels selling templates, but I don't have enough money. This video truly helped me a lot.
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 😊👩💻✨
@@thinklikeagirlboss i tried it but i found problem when i select date on top left the tasks didn't move along with the date so it's very confusing to view task back to old day. Do you have a fix on this issue?
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. My suggestion to view old tasks is to always keep a blank version of the checklist tab and duplicate that blank tab every month to start over (you'll end up with one tab for each month). If you're looking for something more dynamic you might find this video useful: th-cam.com/video/8a1g4w8MbcE/w-d-xo.html I hope this helps! 😊👩🏻💻✨
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!❤
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?
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! 😊👩🏻💻✨
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 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
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!❤
@@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
Hello Pao, Thank you for this wonderful video.. I have a question, when we change the start date the task remains in the same cell and it is not changing according to the date. is that's the way it works.?? am I missing anything here. please help me
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?
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
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! 😅
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?
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?
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.
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
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
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!!
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 😢
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
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: th-cam.com/video/8a1g4w8MbcE/w-d-xo.html
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! 👩💻✨
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 😊👩🏻💻✨
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: th-cam.com/video/8a1g4w8MbcE/w-d-xo.html
YOUR TUTORIAL IS ABOUT TO ENHANCE MY LIFE! TYSM! :)
I have just created my own version by watching this vid and following the instructions. I've made a little bit of changes to suit my needs. Thanks for this!
You are so kind to share your process. I'll have to watch it again to follow through. Thank you for making this tutorial very concise and effective.
Thank you so much for watching! I'm glad you found it useful. 😊👩🏻💻✨
Thank you a lot. I have a lot of ideas, but I don't know how to create them. I saw many TH-cam 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! 😊👩🏻💻✨
So helpful. Thank you for taking the time to explain every step.
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 so much. I was very helpful
Thank you so much! you are an angel
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! 😊👩🏻💻✨
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!! 😊👩🏻💻✨
Thank you very much for your tutorial... finally i understood everything !!!!!!
I'm so happy to hear it was helpful! Thank you for watching! 😊👩🏻💻✨
Awesome Tutorial and i really liked the way you explained everything so slow. Thankyou.
I'm so happy you liked it! Thank you for watching! 😊👩🏻💻✨
Thank you, this was very helpful! I learned a tone.
You're great. teaching very well. Thank you.
Thank you so much!! 😊👩💻✨
your video is so amazing I love it thank you for making this video which help in my work easy and understand
Just what I was searching for! Thank you
I'm so happy you found it useful! Thank you for watching! 😊👩💻✨
This is so helpful! Thank you for sharing your knowledge bestie!
Thank you for watching!! 😊👩💻✨
i love your channel so much, very easy for me to follow thank you so much.
I’m so happy you like it! Thank you so much for watching! 😊👩🏻💻✨💕
@@thinklikeagirlboss i tried it but i found problem when i select date on top left the tasks didn't move along with the date so it's very confusing to view task back to old day. Do you have a fix on this issue?
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.
My suggestion to view old tasks is to always keep a blank version of the checklist tab and duplicate that blank tab every month to start over (you'll end up with one tab for each month).
If you're looking for something more dynamic you might find this video useful: th-cam.com/video/8a1g4w8MbcE/w-d-xo.html
I hope this helps! 😊👩🏻💻✨
@@thinklikeagirlboss thank you very much will check it out :)
I love your tutorials. I'm learning so much! ❤
I'm so happy to hear that! 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! 😊👩💻✨
such a helpful file. thank youuu
You are actually the absolute best!!!
Thank you!! 😊👩💻✨
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. 🏵️
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?
and possibly how to color out the days that are not in that month?
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?
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! 😊👩🏻💻✨
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 😊👩💻✨ th-cam.com/video/Y_WRF1uswfE/w-d-xo.html
@@thinklikeagirlboss thank you!
Thank you very much! This is a great work!🙏
Thank you for watching! 😊👩💻✨
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
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 🙏🏻🥹
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
thank u so muchhhh for making this tutoriallll❤
Hello Pao, Thank you for this wonderful video.. I have a question, when we change the start date the task remains in the same cell and it is not changing according to the date. is that's the way it works.?? am I missing anything here. please help me
Is there a way to connect this with your dynamic calendar, Using both together would be great
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?
Love it. Very good indeed. Can you do google lessons on formulas soon please?
I would love to! Any particular one in mind? 😊👩🏻💻✨
You are simply awesome 🤩
Thank you!!! 😊👩💻✨
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
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! 😅
Why well she explained. Thank you
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?
iloved the way you ... thanks you much
Thank you very much!!!!
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 👩💻✨
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.
i am trying to overcome the same issue too, have you tried conditional formatting?
Thankyou so much
Thank you !
Thank you
Saya suka ini terimakasih telah membantu
Is it possible if I change the start date the tasks will also update?
Hi ! how can i sync the task to the google calendar?
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
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
thanks for that
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!!
Hello, I was wondering if there is a way to make the tasks remain with the dates once I changed the start date?
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! 😊👩🏻💻✨
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 👩🏻💻✨
You are so amazing!!
Thank you so much!!! 😊👩💻✨
How can I copy the task from one date to another when changing dates? Thanks
I'm wondering what to do if the date changes and the content of the text changes accordingly.
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 😢
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
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.
if i click on the start date the calender date is starting but the task was not updating it is fixed what to do
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: th-cam.com/video/8a1g4w8MbcE/w-d-xo.html
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?
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!! 🤩
Can you teach more? Please 🙏
I definitely will! Thank you for watching my videos! 😊👩🏻💻✨
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 😊👩💻✨
at minute 17:26 why i cant do that?
i have a problem the list dont move when i swicth the day
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: th-cam.com/video/8a1g4w8MbcE/w-d-xo.html
Please marry me❤💍, This is absolutely amazing, its aesthetic, its everything. Thank you very much
Hi! That's so sweet! I'm so happy you like it! Thank you so much for watching 😊👩🏻💻✨
❤❤❤❤❤❤
Pls help me in this
You are a Queen!🫵🏽👸
That's so sweet, thank you!! 😊👩💻✨
thank you so much
thank you thinkergilmore