Thank you a lot. I have a lot of ideas, but I don't know how to create them. I saw many UA-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 😊👩💻✨
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?
@@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
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 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?
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?
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.
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!❤
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 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 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 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
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! 😅
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
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 😊👩🏻💻✨
So helpful. Thank you for taking the time to explain every step.
YOUR TUTORIAL IS ABOUT TO ENHANCE MY LIFE! TYSM! :)
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 a lot. I have a lot of ideas, but I don't know how to create them. I saw many UA-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! 😊👩🏻💻✨
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 😊👩💻✨
This is so helpful! Thank you for sharing your knowledge bestie!
Thank you for watching!! 😊👩💻✨
Thank you
your video is so amazing I love it thank you for making this video which help in my work easy and understand
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 love your tutorials. I'm learning so much! ❤
I'm so happy to hear that! Thank you for watching! 😊👩💻✨💕
such a helpful file. thank youuu
Just what I was searching for! Thank you
I'm so happy you found it useful! Thank you for watching! 😊👩💻✨
thank u so muchhhh for making this tutoriallll❤
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?
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?
You're great. teaching very well. Thank you.
Thank you so much!! 😊👩💻✨
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
Thankyou so much
Thank you very much!!!!
Thank you very much! This is a great work!🙏
Thank you for watching! 😊👩💻✨
Why well she explained. Thank you
iloved the way you ... thanks you 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 👩💻✨
Is there a way to connect this with your dynamic calendar, Using both together would be great
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 😊👩💻✨ ua-cam.com/video/Y_WRF1uswfE/v-deo.html
@@thinklikeagirlboss thank you!
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?
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?
You are a Queen!🫵🏽👸
That's so sweet, thank you!! 😊👩💻✨
Love it. Very good indeed. Can you do google lessons on formulas soon please?
I would love to! Any particular one in mind? 😊👩🏻💻✨
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. 🏵️
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?
thanks for that
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!❤
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
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! 😊👩💻✨
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.
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 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
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! 😅
Saya suka ini terimakasih telah membantu
You are so amazing!!
Thank you so much!!! 😊👩💻✨
Hello, I was wondering if there is a way to make the tasks remain with the dates once I changed the start date?
I'm wondering what to do if the date changes and the content of the text changes accordingly.
How can I copy the task from one date to another when changing dates? 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
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! 😊👩🏻💻✨
❤❤❤❤❤❤
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?
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 👩🏻💻✨
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!! 🤩
at minute 17:26 why i cant do that?
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 😊👩💻✨
Please marry me❤💍, This is absolutely amazing, its aesthetic, its everything. Thank you very much
thank you thinkergilmore