Goal Tracker Google Sheets Tutorial + FREE TEMPLATE

[@Am-kt9ml]

Please continue doing tutorials! You’re an amazing teacher and I’ve learned so much and you’ve given me confidence to build my own spreadsheets!

[@thinklikeagirlboss]

I'm so happy to hear that! Thank you so much for watching and commenting! I will absolutely keep on making them 😊👩🏻‍💻✨

[@CassiaLopes-b5q]

for me, as Brazilian, I used the formula as: =SPARKLINE(TODAY()-E2;{"charttype"\"bar";"max"\F2-E2;"COLOR1"\"GREEN"}) or =SPARKLINE(COUNTIFS(C7:C21;"";B7:B21;TRUE);{"charttype"\"bar";"max"\COUNTIF(C7:C21;"");"COLOR1"\"GREEN"}) On the " , " we use " \ " or " ; " it depends of the situation. THANKS SO MUCH for this tutorial, its going to help me a lot this year!!!

[@LeoochEnzo]

Thank you for this comment!! I had problems with the beginning =if formula but when I changed the "," to ";" the formula worked. (Sweden)

[@GoingGreenMom]

Thank you! I'm in the US, but I've been fighting with this for over an hour and I was missing a comma that I apparently couldn't see!

[@ariellefournier-blais1596]

I love you

[@wisdomebisingha1419]

I really appreciate your teachings. Your explanations are clear and easy to follow. Thank you very much.

[@mylaagroupofcompanies]

I'm here a year later, trying to get out of debt by selling digital products, let me just say, your channel is a gold mine. I followed this to create a general to-do list. Thank you so much

[@thinklikeagirlboss]

Hi! I loved reading this, thank you so much for watching! 😊👩‍💻✨

[@manishtekam7929]

Your spreadsheets and follow-along tutorials are amazing! Thank you for sharing your knowledge. Looking forward to upcoming tutorials.

[@thinklikeagirlboss]

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

[@joelopara2277]

Thank you so much for this tutorial. I just finished creating my own and I learned how to use sheets along the way. I am grateful

[@thinklikeagirlboss]

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

[@iamdgulley]

Hello, I am at the 25:02 mark in the video. I am creating a spreadsheet for the month of August which is a few days away. Today is 7/27/204. I am getting -5/30. Can you tell me why I am getting a negative number and how to fix it. Thank you

[@CynyZiha]

I'm also getting this issue.

[@RebeccaBancarz]

I already know based on other videos that I’ve seen from you, that this one is going to be amazing! I can’t wait to finish work and create this spreadsheet!

[@thinklikeagirlboss]

That's so sweet thank you so much!! I hope I did a good job with it 😊👩🏻‍💻✨💕

[@RebeccaBancarz]

@@thinklikeagirlboss so far im loving it! I got stuck though on part 10:09 where I do " = click on the date - TODAY () " instead of getting 6 I get 0, not sure what I am doing wrong

[@RebeccaBancarz]

ohhhhh nvm!! it was saying zero because I put todays date and then I chose the future date you did, which was today haha therefore I would have zero days left! 🤣

[@RebeccaBancarz]

@@thinklikeagirlboss nvm its a struggle...lol i'm wondering if the reason why i'm struggling so much is because my "today" date if different then yours, or im in another country maybe ?

[@thinklikeagirlboss]

What you can do is: Instead of using TODAY(), you add a random cell with a fixed date (fixing it to what was my "today" in the video) and reference that cell instead every time I use TODAY() in the tutorial (just to follow along). Then you can replace that fixed date with the =TODAY() formula and everything will be dynamic again 😊👩🏻‍💻✨ Please let me know if this helps! ✨

[@millionairegym]

Nevermind! I figured it out! I got ahead of myself and had copied the formula before adding the ARRAY and I hadn't deleted everything. I deleted it all and it's working now!

[@thinklikeagirlboss]

I'm glad you figured it out!! Thank you for letting me know!! 😊👩‍💻✨

[@golam_morshed_prince]

Great Tutorial❤️

[@thinklikeagirlboss]

Thank you! 😊👩🏻‍💻✨💕

[@kobipeeri1788]

Great. Love it. You explain clear and convenient.

[@thinklikeagirlboss]

Thank you so much! 😊👩‍💻✨

[@sitindaonriston3799]

Thank you for this video, this tutorial very helpfull and detailed. i have learned a lot.

[@stylznailsandmore2025]

Thank you for sharing ❤❤❤❤

[@TechyFriends]

I love EVERYTHING YOU MAKE! Go girl!

[@thinklikeagirlboss]

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

[@nourhenemhimdi6916]

thank you sooooo much it really helped me i learnt a lot from ur tutorial keep going

[@thinklikeagirlboss]

I'm so happy it helped you! Thank you so much for watching!! I have a couple new ones in the works 😊👩🏻‍💻✨

[@eyza5927]

Thanks so much, that was very helpful!

[@jenniferlugo6580]

Hello! I've followed along on many of your tutorials and love your work! The way we can cross off items is one of my favorite features. Could you tell me how to also apply the way tasks get crossed off in the calendar? I tried looking around but can't find a way to do. I also would like to add this feature to the dynamic calendar you've taught us. I know it's a conditional format and get it to work on the first calendar date but can't figure out how to get it to work for every task on the calendar. Thanks for all your help, you are simply amazing ❤

[@thinklikeagirlboss]

Hi! Thank you so much! I want to do more calendar tutorials so this feature will definitely go on the list 😊👩🏻‍💻✨ Have you watched this tutorial by any chance? kzbin.info/www/bejne/q4LPi6Ntd9KWhZY If you managed to get it working on one day maybe some the things I teach about conditional formatting might help you understand how to replicate it on the rest of the days 😊👩🏻‍💻✨

[@TheBandNerd129]

I’m wondering this as well!!

[@clarissa2316]

Absolutely awesome! Thank you so much for the tutorial. 😍

[@thinklikeagirlboss]

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

[@HarishJangir888]

I'm new on your channel. And i see your work and your way to teach, all is better than others. And Thank you for these videos etc.

[@thinklikeagirlboss]

I'm honored you think that! Thank you so much! 😊👩‍💻✨

[@laurinpatton]

LOVE your videos! Thanks so much for sharing

[@thinklikeagirlboss]

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

[@mochannel2482]

Great tutorial. Thank you

[@thinklikeagirlboss]

Thank you so much!! 😊👩‍💻✨

[@digitalmumlife1]

OMG 🎉 thank you 😊

[@thinklikeagirlboss]

Hi! I promised you the next one would be a tutorial! 😊👩🏻‍💻✨ I hope you like it!

[@Xenia_Anna]

Thank you so much !!

[@thinklikeagirlboss]

Thank you for watching! 😊👩🏻‍💻✨

[@TheBandNerd129]

Hi! So when you click on the done check box it crosses out the task in the do to list, is there way to make it also cross off the task in the calendar?

[@thinklikeagirlboss]

I don't have a tutorial for that at the moment but you could use Conditional Formatting and create a custom formula 😊👩‍💻✨

[@billwood3159]

WOW!! That was awesome! - Where have you been all my life? 🙂 You made it so simple even "!" could do it.

[@thinklikeagirlboss]

I'm so excited to hear you were able to follow along! Thank you so much for watching!! 😊👩🏻‍💻✨

[@billwood3159]

@@thinklikeagirlboss - I think I need to start thinking more like a Girl Boss!!

[@thinklikeagirlboss]

That's so sweet! Here's a list of other tutorials if you would like to check them out 😊👩‍💻✨ thinklikeagirlboss.com/en-mx/pages/free-youtube-tutorials

[@anne-sophieurstein7993]

Good morning, Thank you so much for your awesome tutorials, you are an amazing teacher. Thanks to you, I am developing a lot of skills and I am delighted! I have a quick question regarding this tutorial: I would like the task list to be dynamic and only the tasks included in the top dates to be displayed. Because otherwise I have too many successive tasks and I go well beyond the table. What formula should I use so that only tasks between E2 and F2 are displayed?

[@mohanrajsarathi117]

Thank you so much...❤

[@nanachan5896]

Hi! I just discovered your channel just now and I was amazed by it. I'm thinking where did you learn all of this?

[@thinklikeagirlboss]

Hi! Thank you!! I've been learning as I've needed things over the years, mostly by building things I need to make my own life easier. Lot's of research and practice 😊👩🏻‍💻✨

[@roseu539]

Awesome tutorial! Is it possible to add a master 'This week deadlines'? For example, I have one for different goals, is it possible to have the tasks for each week deadline for the different goals show up on just one 'This week deadlines'? Hope that makes sense.

[@misssomod194]

شكرا ❤❤

[@thinklikeagirlboss]

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

[@Inc224]

Hello, amazing video!! Could you make a step-by-step video for your weekly planer please 🙏

[@thinklikeagirlboss]

Hi! Thank you so much! I don't know what my next tutorial will be yet but I can add that to my list of ideas 😊👩🏻‍💻✨

[@gabbierichardson5944]

p;ease help! for g2, im doing the equation exactly how your doing it but I'm getting a 0, if I change the date I get a negative number and the number after the slash changes too. i did this 3 times. idk know what I'm doing wrong. my dates are july 1 2024 - july 31 2024. for example if I change the date to july 11 2024 It says -10/20 in g2

[@arualplay]

Your videos are incredible, thanks for sharing! May I asked what is your background? How do you learn all of this formulas and tricks?.

[@thinklikeagirlboss]

Hi! Thank you so much!! I majored in computer engineering so I sort of bring that way of thinking and solving problems into my spreadsheets. I've also worked building custom software at an accounting firm and as a Brand Manager at an online clothing store. I love problem solving, automation, business and productivity, and this has a bit of all of that so it ended up being perfect for me 😊👩🏻‍💻✨ In terms of features and formulas I've sort of learned as I go, every time I think something would be cool I figure out a way to get it done by literally googling. And when I feel something is too repetitive I also try to find a way to maybe skip some steps again by googling. It's just a matter of asking the right question and you'll find tons of answers and tricks along the way. I think the best way to learn is by building something that actually does something useful. I think it's more exciting and fun. That's why I try to teach through making full templates. That way you end up with something you can feel proud of 😊👩🏻‍💻✨

[@aellea193]

Your spreadsheets are amazing! Can you also do a client tracker? Looking forward to it

[@thinklikeagirlboss]

Thank you so much!! I have an Invoice Tracker with a section to add your clients but I definitely should have a standalone Client Tracker. Thank you! 😊👩🏻‍💻✨ You can find the Invoice Tracker (with a tab for clients included) in my Etsy Shop and this is the link to the video in case you would like to check it out: kzbin.info/www/bejne/hoe3mH5oeaaZnsk

[@Ayalas295]

Hi, I found your channel to make a goal tracker. The explanation was clear and concise. However, when I got to the part where your progress number for " Days Until End Date" was, I always have a negative number of days. I was wondering what went wrong

[@AnishaShinde833]

Ya that is happening for me too

[@gabbierichardson5944]

same. idk whats going on if you figured it out that would be helpful

[@thinklikeagirlboss]

Hi! Could one of you send me a screenshot on Instagram so I can check it out? 👩‍💻✨

[@HeshamSA]

You amazing 👍👍👍👍

[@thinklikeagirlboss]

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

[@camillecortez9403]

Hi! I was wondering if it is possible to carry the strikethrough over the weekly deadline? For example, I have already the strikethrough for Task 1 from the first table and I would like to see the same thing over my weekly deadline.

[@thinklikeagirlboss]

Hi! Yeah! It could be done with conditional formatting 😊👩‍💻✨ I don't have a tutorial with an example showing something similar at the moment, I'm sorry!

[@TheBandNerd129]

I’m wondering this as well!!

[@joyceanemone4336]

Omg that's so life changing and well explained! You save lifes🎉. Now I have a problem, I don't know how to download it on my computer because it turns out to be on excel and its changes every thing I did 😢

[@thinklikeagirlboss]

Hi! Thank you!! 😊👩🏻‍💻✨ Some Google Sheets features are not compatible with Excel so if you try downloading it and opening it there, it will break. I'm sorry!

[@rakurao8194]

could you please make on tuts on how to days decrease stop when 0 days left while using today formula with deadline - like if deadline meet the date then counting going to minus, could you do that??

[@thinklikeagirlboss]

Hi! You can use the IF formula. I will include it in future videos 😊, I don't think I've used it on tutorials yet 👩🏻‍💻✨

[@rakurao8194]

thank you for so tricky tricks that saving lots of time.

[@thinklikeagirlboss]

I'm so glad this helped you save time! Thank you for watching! 😊👩🏻‍💻✨

[@scalpdeep3624]

Tutorials are amazing and usually very clear except for the section with the counter today confused me. Just as a clarification, on the top counter, it is not counting "Days Until End Date" but rather the number of days that have elapsed between the start and end dates. Otherwise wouldn't the counter have 9/30 days left rather than 23/30?

[@thinklikeagirlboss]

Hi! Yeah! I totally should have named that label "Days Elapsed" or something like that sorry about that!

[@MuhammadZeeshan-cr7ee]

Thank You so much. Learned a lot from this. Btw I'm also an Etsy seller and selling spreadsheets there. Can You please guide me about from where I can get more templated so that I can list more

[@thinklikeagirlboss]

Hi! I'm glad you liked it! I make all of my templates from scratch and I come up with the layouts and functionalities myself. I usually build them based on my own real life problems and the things I find useful in my life and business 😊👩‍💻✨ If you come up with things that are truly useful for you, other people will find them useful too I think 😊

[@MuhammadZeeshan-cr7ee]

@@thinklikeagirlboss Thank you so much for replying to me. I really appreciate your guidance 😊

[@thinklikeagirlboss]

I wish you the best with your shop! 😊👩‍💻✨

[@MuhammadZeeshan-cr7ee]

@@thinklikeagirlboss Thank You! By the way, have you tried to make more than one shop on Etsy on the same details like the same name, bank account and the same address?

[@digitalmumlife1]

The link to the goal template. Can we brand it as our own & sell on our website or it’s for personal use? Wanted to check with you.

[@thinklikeagirlboss]

Hi! All my products and templates are meant for personal use. You can use what you learn in the tutorial to create something of your own, but you can't just sell it as it is 👩‍💻✨ Thank you for asking!

[@tatyanemarina]

❤

[@inspirenity.]

Hopefully there's meal planner for free 🥺🙏🏻

[@thinklikeagirlboss]

Hi! I'm just diving into teaching so I think I'll stick to smaller files for now 😊👩‍💻✨

[@dipurpleberyy]

can you please make a fitness tracker with weight, measurements workout tracker in it? it would help SO MUCH!!!!!!

[@zeegoddess5579]

If we would like this to be a whole month instead of the a week how can we go about that?

[@thinklikeagirlboss]

Hi! While you are following the tutorial you can add as many days as you want to the right 😊👩‍💻✨