Cleaning Schedule, Weekly & Daily Routine, Cleaning Checklist, Chore Planner, Google Sheets Template

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

ОСКАР и КВИНКА СВИДАНИЕ! БАДАБУМЧИК ПОДСТАВИЛ ОСКАРА?!

ПОЕЛ АРБУЗ - ПОМЫЛ УНИТАЗ ► SCHOOLBOY RUNAWAY #2

Телеграмм-Колян Карелия #юмор #дпс

Склеил девушку-курьера ❤️

Task Planner Spreadsheet - Digital TO-DO LIST TUTORIAL - Google Sheets Template - (+FREE template)

thinklikeagirlboss

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

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

50% 1

Видео Поделиться Скачать Добавить в

In this tutorial I'm going to walk you through creating your very own Dynamic To-Do List in Google Sheets. I will show you how to create the scratching effect whenever you mark a task as done, how to highlight overdue tasks, how to add a progress bar and more!
I try to use as many formulas as I can so you can get the most out of this tutorial. I hope you like it! 😊👩🏻‍💻✨
If you are already familiar with Google Sheets and don't want all the details you can change the video settings and make it play faster (2x).
I would love for you to create your version from scratch, following the video, and only look at the original file if you run into any trouble 😊
📌 Link to FREE file: tinyurl.com/5yu96myf
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
📌 If you would like to SHOP a more advanced version, you can use this link:
thinklikeagirlboss.com/produc...
📌 Other FREE Tutorials:
thinklikeagirlboss.com/pages/...
#todolist #googlesheets #tutorial #tasks

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

11 окт 2022

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@erosennin650 Год назад

Hey, I don't know your name or where you're from. But I must say that you're making some really very helpful content around spreadsheets. There are so many technologies out there, but the spreadsheet is still underrated. I love using spreadsheets in different purposes. The way you're helping people is really appreciable and your voice is also so sweet.

@thinklikeagirlboss Год назад

Hi! Thank you SO much!! I really appreciate you taking the time to comment such a nice message! And I totally agree, spreadsheets are amazing! They are so flexible and you can do so much with them. I am so happy you found my content useful! 😊👩‍💻✨

@katherinetroche8812 Год назад

I do agree not only I have I bought almost all her stuff but I love her teachings as I understand my sheets better as I use them 😂😊

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

Very informative. I have created exactly the same format for my COO'S to-do-list and according to him his lists are no longer boring as he can play along haha.He was amazed . Thanks a lot and u deserve my subscription.

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

Well, for today's task, I learned how to format date. Since in my country we are used to day/month/year, I changed the format of the dates to all my workplace google sheets. It was on month/day/year. NEVER FELT SO GOOD TO SEE A CHANGE!😂

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

This was awesome. I love how quickly you go through it and I could follow so easily. My spreadsheet looks amazing and I was able to follow. Thank you so much. The formulas was WOW! Great video. Thank you so much

@oluwabunmiayodeji4535 Год назад

It's the way I've been following your tutorials back to back. Thank you very much for these videos.

@thinklikeagirlboss Год назад

I'm so excited to hear that! It makes me want to create more, thank you!! 😊👩‍💻✨

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

WOW WOW WOW I LEARNED SO MUCH TODAY, YOU ARE AMAZING! I LOVE HOW YOU EXPLAINED EVERYTHING DETAILED AND CLEAR! AMAZING AND IMPORTANT TOOLS TO KNOW!

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

I loved this video. Thank you for making it so easy to follow!

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

alright so from where do i start.. these kinds of things always fascinated me but i knew i could never make it on my own. 22 years on the planet and i planted the idea that these complex computer things is something i will never be able to do in the roots of my mind. BUT TODAY- YOU MY GIRLIE changed everything for me. i am so happy with this. i cannot believe i made this, you explained it so nicely i'll cry. you got yourself a subscriber for sure but more than that- you erased the belief that i can't do xyz. Now, because of you, i am rethinking every other thing i told myself i can't do. you have made me feel so powerful, i am so grateful

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

This was amazing to read! Thank you so much for taking the time to write it! I never in a million years imagined I would get messages like this, I'm so happy it helped you! I'm always working through my own personal limiting beliefs and I know it can sometimes be a struggle, it means a lot to me to know that my work did this for someone, thank you!! 😊👩🏻‍💻✨💕

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

HUHUH GLAD I FOUND YOUR VIDEOS, YOUR YT CHANNEL!!! IM VVV GREATFUL FOR THIS, ITS REALLY HELPFUL AND DETAILED THAT'S WHY I DONT HAVE PROBLEM IN DOING MINE. GOD BLESS U

@keylimegween Год назад

I hope your channel grows! Your videos are really helpful and you are very generous with your knowledge in spreadsheets :))

@thinklikeagirlboss Год назад

Thank you so much for your kind words!! 😊👩‍💻✨💕

@CK-jk9mx Год назад

This was an EXCELLENT tutorial! Thank you. I've not had much experience with Google Sheets, and found this super helpful and easy to follow. I have subscribed and am now going through your other videos. Once again, thank you!❤

@thinklikeagirlboss Год назад

I'm so happy you found it helpful! Thank you so much for subscribing!! I hope you like the other ones as well 😊👩🏻‍💻✨

@user-ej8st5fl9p 23 дня назад

Love it girl.. i will definitely try this for our group progress tracker. Thank you so much. This is really helpful.

@iamazalea9888 Год назад

I finished mine while following you, omg you're so great at explaining. Thought I'm already knowledgeable at google sheets but u prove me wrong. Please make more follow along tutorial, u help us big time!! Thank you thank you your dabest!!

@thinklikeagirlboss Год назад

Thank you so much for watching and commenting! I will definitely make more 😊👩‍💻✨

@micaellaraignfetizanan1387 Год назад

Omg!! I learned here more than my professors. Thank you so much for the awesome tutorial. You are very good in teaching. Your explanations are simple and easy to understand. I hope you make more tutorials in the future. You deserve lots of subscribers! ^^

@thinklikeagirlboss Год назад

That's so nice of you to say!! Thank you SO much!! I really appreciate you taking the time to comment 😊👩‍💻✨

@lalalalalalalalalalalalalalaIa Год назад

thank you so much!!!! i just made my own to-do list because of this. it’s very easy to follow and it’s very fun. i also added my own touch by putting subjects along with the tasks by a drop down list… and then i made a progress bar for each subject!! i like the progress bar a lot, it will motivate me to do my tasks more, thank you again ❤️😊❤️

@thinklikeagirlboss Год назад

That's awesome!! Thank you so much for sharing this!! I love knowing that people find it useful 😊👩‍💻✨💕

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

Thank you so much for doing this. I really enjoyed following along. I did a few things differently that might be great for future additions. In the Status counts I did =Countifs($F$4:$F$20,J4,$C$4:$C$20,"FALSE") This only counts the tasks that aren't completed. So I know what's left to do. I also created a row for "assigned to" since we are sharing it with 3 people. Then below the Status counts I added a count of assigned to with the same formula above On the #'s 1-15 I did 1 in B4, then =IF(D5"",B4+1,"") That adds the next number when I type a task in the D Column. I would have never done any of this if it wasn't for this tutorial, my idea's just made it more fun for me to build off what you taught. Thank you for doing this!

@ProGamer-up9cn Год назад

This is an amazing tutorial. Please do create more tutorials. well explained and on point. (I rarely comment on YT videos.Only on extremely good videos )

@thinklikeagirlboss Год назад

Hi! Wow thank you SO much!! I really wanted to do a good job on these videos. I truly appreciate your comment!! Thank you!!! 😊👩‍💻

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

Your videos are amazing. Thank you for sharing your knowledge with the world! I'm just learning Google Sheets and I'm amazed at all the functionality.

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

Hi! I'm so happy you like them!! Thank you so much for watching! 😊👩‍💻✨💕

@msvandaful Год назад

Wow, what an awesome tutorial. I have never been able to follow anything before. This was so so good. Thank you so much for showing us this. Super helpful. :)

@thinklikeagirlboss Год назад

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

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

All I have to say after watching this video is that you ROCK! Thanks for the tips, using some of these in my own to-do :)

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

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

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

This was so amazing! Very intuitive and precise, thank you!!

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

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

@bimalabasnet2476 Год назад

Thank you for this video. Very useful. I followed along and made a very pretty to-do list.

@thinklikeagirlboss Год назад

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

@yazinthaastin4921 Год назад

You have a detail explanation indeed. Thank you so much. I am learning a lot from your video.

@thinklikeagirlboss Год назад

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

@kamruzzamanmilton Год назад

Owao!! Just amazing... just today I started to use sheets and your video is crystal clear from start to end.. it helps me much..

@thinklikeagirlboss Год назад

Hi! Thank you so much! I'm so happy you liked it! If you're looking for a more advanced one, you can check out my Income and Expenses tracker tutorial 😊👩‍💻✨ ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-He5cJ33CRu4.html

@tisyupaperpoet 12 дней назад

Thank you so much for this. You've put a lot of work in creating content like this and you're very generous for sharing this :) May the Universe bless you!

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

Hi! Thank you so much for watching and taking the time to leave a comment 😊👩‍💻✨💕

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

My to go person for google sheets..thanks. What you are doing is so helpful. ❤

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

I'm honored! Thank you!! 😊👩🏻‍💻✨💕

@AlejandraGomezCastro Год назад

This tutorial became my bible. I can't thank you enough.💜

@thinklikeagirlboss Год назад

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

@carolchavey4993 Год назад

This was an awesome video! I have been searching for a way to do very similar things but was unable to find what I was looking for and this video has given me something to go on with some customizing needs and the formulas I have been missing. Keep up the good work as you are amazing! I did not have any trouble following your instructions and was able to create my own To Do List and customize it the way I like it. I am looking forward to watching more videos from you. Thank you! You are an awesome teacher.

@thinklikeagirlboss Год назад

Hi! I'm so excited you found it helpful!! I loved your comment! Thank you so much for taking the time to write it!! 💕 I have a tutorial that's a bit more advanced in case you would like to check it out. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-He5cJ33CRu4.html I would love to know your thoughts! 😊👩🏻‍💻✨

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

I paused the vid, then I subs and like. the video is easy to understand and easy to follow. thank you so much ! highly recommended!

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

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

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

That's awesome content on Google sheets. Thankyou

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

This was so good- thank you!

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

Very useful! Thank you

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

hi, love the in depth knowledge of yours. This tutorial helps me a lot in organizing my task

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

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

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

Excellent video. Great explanation. I had to go back a few times (newer excel user) but I did it. Thank you so much

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

Thank you for watching! 😊👩‍💻✨

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

Thank you so much 🌸❤!

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

Much appreciated!

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

heyy thank you so much for this tutorial!! it really helped me

@henrietta06 Год назад

This came out perfectly, thank you!

@thinklikeagirlboss Год назад

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

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

Love it❤

@sivagupta9091 8 дней назад

Great work mam. Thanks for your efforts

@mohamedhamdy3995 Год назад

Thank you so much my dear! Really appreciate it! Fantastic trainer 😍😍😍😍😍

@thinklikeagirlboss Год назад

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

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

Thank you for this. I learned a lot. ❤

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

Thank you for watching!! 😊👩‍💻✨

@geethanjaliningraju3659 Год назад

Great Tutorials, Extremely helpful, Do more of it. Advanced levels also

@thinklikeagirlboss Год назад

Thank you so much!! 😊👩‍💻 I definitely will! ✨

@BhaviSolanki-td8sl 24 дня назад

All the videos are just superb ✨🔥💯 God bless you ! ❤

@thinklikeagirlboss 23 дня назад

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

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

Love it!

@thinklikeagirlboss Год назад

Thank you!! 😊👩🏻‍💻✨💕

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

This was amazing!! Thank you!

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

Thank you so much! 😊👩‍💻✨

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

This video was super helpful. Thank you! :)

@thinklikeagirlboss Год назад

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

@alphagraphyproductions Год назад

Thank You So Much for helping me out for sorting out my project management chaos..

@thinklikeagirlboss Год назад

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

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

Great job! Successfully made the template.. thanks

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

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

@muragijimanac0 12 дней назад

Very Helpful for a Beginner like me ✨

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

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

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

Excellent tutorial, thank you

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

Thank you so much!! 😊👩‍💻✨

@faithgatome862 Год назад

This is very helpful and practical thankyou very much

@thinklikeagirlboss Год назад

Thank you for watching!! 😊👩‍💻✨

@SnappingPOV Год назад

It was amazing. Thank You.

@thinklikeagirlboss Год назад

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

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

Very helpful. Thank you

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

Thank you for watching! 😊👩🏻‍💻✨

@megapuspitap Год назад

Love it thank you so much~~~~

@thinklikeagirlboss Год назад

Thank you for watching!! 😊👩‍💻✨

@nastyahumenschuk5895 Год назад

Привіт) я даже рада що знайшла ваш туторіал, він крутий, я дізналась багато нового, і це саме те, що я шукала. Щоправда в мене не виходило зробити progress bar, не знаю чому, я 1000 разів перевіряла формулу, але мені вдалось це зробити лише скопіювавши формулу з вашої таблиці. Дякую що ви залишили посилання в описі, це справді допомогло

@thinklikeagirlboss Год назад

Hi!! This is such a nice comment, thank you so much!! I loved it!! I'm so glad this helped you 😊👩‍💻✨

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

thanks many help

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

I loved it but could not get the strikethrough feature to work on my check boxes. I think it has something to do with the #9 used. My check boxes are in column B so I knew to change your "c" to a "b" Any suggestions much appreciated because that it the most satisfying feature. Thanks so much!

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

thank you so much, I will apply this to my team

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

That's great to hear! Thank you for watching! 😊👩‍💻✨

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

Brilliant! Great video Pilipino! 😄

@globtex Год назад

Your Voice is just adorable! so is the DTDL!!

@thinklikeagirlboss Год назад

That's so sweet of you to say ✨ Thank you so much!!! 😊👩🏻‍💻✨💕

@DrAishaCh Год назад

You did such a great job!! I was looking for the average thing so it doesn't show the error due to being divided by zero ❤. Also I need to know how to take that average and make the values appear as a chart to track trends. But I need that chart to be on a separate sheet kind of like a dashboard sheet to present.

@thinklikeagirlboss Год назад

Hi! Thank you so much! You can select the range you need for your chart and then click on INSERT -> CHART. You'll see a bunch of options for the formatting in a sidebar to the right and when you're happy with it you can copy the chart and paste it into a different tab. I hope this helps! 😊👩🏻‍💻✨

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

Hy Friend Thankx I was need it but you Are So, good

@beatrizpatalotart Год назад

I've watched a lot of other excel tutorials, and this by far has been my favorite....and I've only watched 2! For context, I'm in my early 30's so I'm wondering if it's a generational thing

@thinklikeagirlboss Год назад

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

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

thank you so much for this tutorial! so well done. absolutely love your tutorials. I purchased your dynamic to do list template and love it as well. Do you have a tutorial that explains the formula/function you use to create the 'done' and 'pending' task lists from the main task list? If I can understand that portion, I would have all the information I need to customize for my current need. thank you so much!

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

Hi! Thank you! I used the QUERY formula, I don't have tutorials for that one yet but I will make them in the future 😊👩🏻‍💻✨

@havenlahoz4078 Год назад

so helpful!!

@thinklikeagirlboss Год назад

I'm so glad you found it helpful!! Thank you for letting me know! 😊👩‍💻

@KaewtaSricha Год назад

Thank you so much, it was really really helpful ( I am really bad with those kind of thing)

@thinklikeagirlboss Год назад

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

@aaronecelph.d9728 Год назад

Thank you

@davidbuderim2395 Год назад

Excellent - thankyou

@thinklikeagirlboss Год назад

Thank you for watching!! 😊👩‍💻✨

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

You contents are amazing ❤❤

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

Thank you!! 😊👩‍💻✨💕

@MErdogan34 Год назад

Thank you for the video

@thinklikeagirlboss Год назад

Thank you for watching! 😊👩🏻‍💻✨

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

Thank you very much wow nice work am using it on my duties

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

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

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

Very helpful for a newbie like me.

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

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

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

You are the best. Still helpful in 2024!

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

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

@azissyahputracom Год назад

Thank you very much

@thinklikeagirlboss Год назад

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

@digitalmumlife1 Год назад

Great tutorial . Please do more. Can you show us how to make a budget planner ?

@thinklikeagirlboss Год назад

Hi! Thank you so much!! I will add that to the list of tutorials I want to create 😊👩‍💻

@Anilkanta01 Год назад

Thanks a lot as a upsc aspirants I am searching for it😊

@thinklikeagirlboss Год назад

I'm glad you found it useful! 😊👩‍💻✨

@Anilkanta01 Год назад

@@thinklikeagirlboss I want to know how do I make 3 subject progress bar out of 10-15 subject....😅 Please 🥺 help me

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

You are amazing thank you! ❤ can you do more work spreadsheets as well? I am in hr and I’m trying to track my turnover rate

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

Thank you so much!!! I'll add that to my list of ideas 😊👩🏻‍💻✨

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

How can you create a progress bar using the "Status" drop down options? Also, how can you create a scratched out row from the "Status" drop down options. I've no use for the checkbox for my project for either scenarios but can't figure out how to drive those two scenarios from the "Status" drop down option. Please help!

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

Hi! I don't have any tutorials for what you need at the moment but you can look into Conditional Formatting and the IF formula 😊👩‍💻✨

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

This was very helpful and useful! Thanks. How would we add extra rows to the to-do-list ensuring all the formulas still work? Thanks

@thinklikeagirlboss Год назад

Hi! Thank you! If you followed the tutorial exactly the same: You can select rows 21 and 22 (the entire row), then you right click and select "Insert two 2 rows above". The reason I suggest you insert them in the bottom using rows 21 and 22 is so that your stats won't be messed up. Once you have those 2 new rows you can select 4 rows (the 2 you used before and the 2 new ones) and that will allow you to insert another 4 by repeating the process (right click ... insert 4 rows above ...) When you are inserting make sure you never touch the first and last row, always select rows in the middle. After that, you copy the formula from column G of any cell that already has a formula and paste it on column G of your new rows (never copy from the first and last rows, since those have different borders and will mess up the look) Afterwards you edit the sequence formula to end in your final number of rows. Some parts of this video might help you: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5QbU3Csb8e4.html It's for one of my products but the idea behind it is mostly the same. I hope it helps! 😊👩🏻‍💻✨

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

Thanks so much for the amazing tutorial!! i loved learning about this. One thing I did notice is that the progress bar shows and error if there are no tasks listed at all. How would you set it to be blank instead like the percentage number?

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

Hi! You can wrap it in an IFERROR =IFERROR(SPARKLINE(B5,{"charttype","bar";"max",100%;"color1","#93c47d"}),) I hope this helps! 😊👩🏻‍💻✨

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

Nicely done and well organized. Have you thought about the next step. How about a way to archive completed tasks making room for new ones without having to scroll down the page. I know you are not trying to compete with todoist- but yours is a much cleaner interface than commercial offerings; however- to be useful it has to keep up with constant new tasks over a longer period of time. After all- I want to be able to show the boss what I have done for more than15-20 tasks!

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

Hi! Thank you for your comment! I have a paid version with more features 😊👩🏻‍💻✨ This is the video in case you would like to take a look: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pU_X3CRWNdM.html

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

Can we have the spreadsheet organize the tasks by date due? The earliest due automatically goes to the top and so forth?

@DripBunny223 Год назад

Thank you for this video! How would you change the total when the boxes are checked tho if we wanted that option instead of the completed box 😢

@thinklikeagirlboss Год назад

Hi! Would you mind maybe explaining a bit more what you mean? 😊👩🏻‍💻✨

@esbi1124 Год назад

Hi there. Just super. PS In Windows we use "Ctrl" button to select multiple cells / columns / rows / ranges

@thinklikeagirlboss Год назад

Hi! Thank you so much for the tip!! 😊👩🏻‍💻✨

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

Do you have a tutorial for iPads, i keep getting computer videos when it doesn’t apply to me.

@Rulfanani Год назад

PLEASE! make more video like this!

@thinklikeagirlboss Год назад

I definitely will! Thank you so much for commenting!! 😊👩‍💻✨

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

Writer here. I'm finally starting to become comfortable with spreadsheets, but I still struggle with creating pretty and useful tools to use for writing. I am constantly looking for a way to create a spreadsheet (Google sheets preferred) for a database of character names. Because we writers collect names to browse when starting a new story. Mine are all over the place and I would love to create a beyond the basics spreadsheet. If you have any tutorial ideas for writers I would love to watch them.

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

I didn't know writer's did that with character names, that's so cool! I will add a spreadsheet for this to my list of ideas 😊👩🏻‍💻✨

@TechyFriends Год назад

Love your videos. Didn't you have a tutorial for like a Christmas planner with a countdown to Christmas?

@thinklikeagirlboss Год назад

Thank you so much!! Yeah! Here's the link to that one. I unlisted it by accident: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uQlZp7BmcO4.html 😊👩🏻‍💻✨

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

What do I do if I have to keep adding the tasks and I wanna see the latest tasks first?

@marytino9312 Год назад

Awesome tutorial! Question: How do you add task 16+ while still retaining the formulas?

@thinklikeagirlboss Год назад

Hi! Thank you so much!! 😊👩🏻‍💻✨ You would have to first change the SEQUENCE formula to add more numbers, then just copy and paste any row from the to-do list into the 16th+ rows. You will also have to update the ranges in the STATUS and TOTALS formulas so they take those extra rows into consideration as well. I hope this helps! 😊

@peace.n.blessings5579 5 месяцев назад

How do change the percentage to include more task? In your tutvid, when it reaches 5 tasks it goes to 100%

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

HI i am currently following your guidelines using excel 2016 and got stuck in this step 13:36. I think conditional format rules don't recognize checkbox i created. Is there other ways that I just CLICK the 'C9' section ONCE and apply the rows with different affect instead of using checkbox? Oh i just solved the problem. I can just type the number 1 or 0 instead of using checkbox. When I put '1', then it works as I 'check' and the affect comes out. :) thanks heaps

@thinklikeagirlboss Год назад

I'm glad you figured it out!! 😊👩‍💻✨

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

hI, THANKS, LOVED IT. But, why the bar chart formula goes to orange instead of green? I typed "Colour" (British Spelling) instead of "color" (American spelling) (my country is selected as UK & India.- It went orange but as soon i typed different spelling it was green. Does the formulas of excel & google sheets comply/ agree with American English spellings only ?

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

Hello thank you so much it was very helpful! Could you tell me how to get the error off of the sparkling range. If there are 0 task it shows as #N/A

@thinklikeagirlboss Год назад

Hi! You can wrap it in an IFERROR =IFERROR(SPARKLINE(B5,{"charttype","bar";"max",100%;"color1","#93c47d"}),) I hope this helps! 😊👩🏻‍💻✨

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

@@thinklikeagirlboss thank you so much your amazing and I love your work! I’ve been practicing in spreadsheets to grow my abilities and become a data analyst

@thinklikeagirlboss Год назад

That's so exciting!! I wish you the best with that!! 😊👩‍💻✨

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

How to make completed to shift to below downside. Pending to be on top

@meijacquet3728 Год назад

Merci beacuoup ^^

@thinklikeagirlboss Год назад

Thank you for watching and commenting!! 😊👩‍💻✨

@planet4214 Год назад

Thank u for video, can u announce how many formulas did you use whike doing this

@thinklikeagirlboss Год назад

Hi! 😊👩‍💻✨ You mean to announce at them beginning of the videos?

@planet4214 Год назад

@@thinklikeagirlboss hello 😊 i have made a team project and ur videos helped me a lot but only thing i couldn’t count the number of formulas bcs it was mandatory to use more than 5 formulas

@zoe_thelegendary9838 10 дней назад

22:19 whenever I did this formula, I always type green, but instead the color of my bar turn into orange, what happened

@officialkkds Год назад

thanks

@thinklikeagirlboss Год назад

Thank you for watching!! 😊👩‍💻✨

Далее

Cleaning Schedule, Weekly & Daily Routine, Cleaning Checklist, Chore Planner, Google Sheets Template

18:05

Cleaning Schedule, Weekly & Daily Routine, Cleaning Checklist, Chore Planner, Google Sheets Template

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

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

33:32

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

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

ОСКАР и КВИНКА СВИДАНИЕ! БАДАБУМЧИК ПОДСТАВИЛ ОСКАРА?!

14:15

ОСКАР и КВИНКА СВИДАНИЕ! БАДАБУМЧИК ПОДСТАВИЛ ОСКАРА?!

Просмотров 1,2 млн

ПОЕЛ АРБУЗ - ПОМЫЛ УНИТАЗ ► SCHOOLBOY RUNAWAY #2

49:28

ПОЕЛ АРБУЗ - ПОМЫЛ УНИТАЗ ► SCHOOLBOY RUNAWAY #2

Просмотров 1 млн

Телеграмм-Колян Карелия #юмор #дпс

00:14

Телеграмм-Колян Карелия #юмор #дпс

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

Склеил девушку-курьера ❤️

01:00

Склеил девушку-курьера ❤️

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

Dynamic Calendar Google Sheets Tutorial + FREE template

28:29

Dynamic Calendar Google Sheets Tutorial + FREE template

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

15 POWERFUL GOOGLE SHEETS TIPS & TRICKS (Insanely Useful Productivity Tips For Beginners)

12:06

15 POWERFUL GOOGLE SHEETS TIPS & TRICKS (Insanely Useful Productivity Tips For Beginners)

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

Task Planner Spreadsheet for Google Sheets With Week Breakdown - Video Tutorial

6:26

Task Planner Spreadsheet for Google Sheets With Week Breakdown - Video Tutorial

Просмотров 698

How to create your own Habit Tracker in Google Sheets - TUTORIAL + FREE TEMPLATE

32:59

How to create your own Habit Tracker in Google Sheets - TUTORIAL + FREE TEMPLATE

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

Build a Notion To-do List with Progress Bar & Stats (+ Template)

23:54

Build a Notion To-do List with Progress Bar & Stats (+ Template)

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

How to Build an Income and Expense Tracker from Scratch - Google Sheets TUTORIAL Budget Spreadsheet

47:43

How to Build an Income and Expense Tracker from Scratch - Google Sheets TUTORIAL Budget Spreadsheet

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

Digital Google Sheets Budget Planner

28:22

Digital Google Sheets Budget Planner

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

Create QR Codes for FREE | Use Anywhere (Excel, Word & PowerPoint)

6:53

Create QR Codes for FREE | Use Anywhere (Excel, Word & PowerPoint)

Просмотров 1 млн

Make a Daily Task Tracker in Google Sheets

12:18

Make a Daily Task Tracker in Google Sheets

Просмотров 3,4 тыс.

ОСКАР и КВИНКА СВИДАНИЕ! БАДАБУМЧИК ПОДСТАВИЛ ОСКАРА?!

14:15

ОСКАР и КВИНКА СВИДАНИЕ! БАДАБУМЧИК ПОДСТАВИЛ ОСКАРА?!

Просмотров 1,2 млн