How To Create Habit Tracker with Google Sheets (+ FREE TEMPLATE)

Рет қаралды 184,619

Күн бұрын

This tutorial will show you how to create a simple yet effective habit tracker in Google Sheets to become more productive and track your progress. You can do the same using Excel also and it is beginner-friendly. The habit tracker includes setting rewards for when you reach your habit goal. I have also linked the template down below! Happy habit tracking :)
🌠𝗚𝗘𝗧 𝗠𝗬 𝗙𝗥𝗘𝗘 𝟱 𝗦𝗧𝗘𝗣 𝗚𝗨𝗜𝗗𝗘 𝗧𝗢 𝗔𝗖𝗖𝗢𝗠𝗣𝗟𝗜𝗦𝗛𝗜𝗡𝗚 𝗬𝗢𝗨𝗥 𝗚𝗢𝗔𝗟𝗦 👉🏼 www.subscribepage.com/v2s9h8
-------------------------------------------------------------------------------------------------------------
➡️MY GOOGLE SHEETS HABIT TRACKER TEMPLATE: www.subscribepage.com/sheetsh...
💼 Tools I use & love!
*Camera: amzn.to/3FpPsDr
*ClickUp (link includes 20% off paid plans⭐): clickup.com/?fp_ref=anyusha31...
*Headphones: amzn.to/3uW6Bjh
*Tripod ring light: amzn.to/3lkqj4W
*Softbox lighting kit: amzn.to/3FEVaS3
*Camera microphone: amzn.to/3aA8IQt
*Clip-on microphone: amzn.to/3uTdu4J
*Laptop: amzn.to/3iJyV38
📚 Books I recommend reading!
*The Miracle Morning by Hal Elrod: amzn.to/3BrAsCi
*Atomic Habits by James Clear: amzn.to/3mAOWtt
*The Power of Habit by Charles Duhigg: amzn.to/3oID4Z6
*Deep Work by Cal Newport amzn.to/3iIvE4u
*Getting Things Done by David Allen: amzn.to/3BoCT8T
➡ SUBSCRIBE: / anyusha
Note this description contains affiliate links: I may earn minimal sums for every purchase at no additional cost to you. You are in no way obligated to use these links, however, it does support this channel 🙂 Thank you!
CREATE HABIT TRACKER IN TRELLO: • HABIT TRACKING IN TREL...
CREATE HABIT TRACKER IN ONENOTE: • Habit Tracking In OneN...
Instagram: an.yusha?h... 💌
------------------------------
Free Range by Mona Wonderlick / monawonderlick
Creative Commons - Attribution 3.0 Unported - CC BY 3.0
Free Download / Stream: bit.ly/-free-range
Music promoted by Audio Library • Free Range - Mona Wond...
------------------------------
#HabitTracking #GoogleSheets #Anyusha
• How To Create Habit Tr...

Пікірлер: 209

@Anyusha 3 жыл бұрын

What habit are you trying to master? Share yours in the comments so others could find some ideas for their habit trackers 🌻🌻

@TheBrittwindham 2 жыл бұрын

Hey there! Do you track any of your habits in Trello? I see where you included it in your "others" list, but I think I'm overlooking what you use for actual tracking... NEVERMIND.... just found the answer by searching. Your video showed up. :) Thanks!

@artareon 2 жыл бұрын

The habits im trying to master is drinking more water, sleeping earlier, and being more active

@Grace-td4kl 3 жыл бұрын

I just used this to make a habit tracker and instead of grouping by time of day i grouped it by energy required - since i struggle with depression it helps me prioritize the easy habit wins without totally giving up :) THANK YOU for the inspiration!!!

@Anyusha 3 жыл бұрын

Omg Grace that is an absolutely genius idea!!! I love that, kudos to you!! Wishing you the health and happiness that you deserve :) ❤❤❤❤

@stephanietravis4215 2 жыл бұрын

This is genius I would have never thought of this thank you!!

@sifathazizmithi4737 2 жыл бұрын

hey would you like to share how you created it? It'd be really useful because I'm also struggling with depression.

@plannersandjournals872 Жыл бұрын

True. I too sufferring from dep and also this method find helpful to me

@mrwaiyantunmrwaiyantun1999 Жыл бұрын

@@Anyusha ❤❤❤

@marjoriejordan6594 Жыл бұрын

You really helped me get organized!

@Anyusha Жыл бұрын

You are so welcome Marjorie! I'm happy to hear you find them easy to use 🙈 wishing you the best!

@Grunfeld 3 ай бұрын

Thank you so much! Clearly explained and demonstrated 🙂

@daisykuchinashi9893 Жыл бұрын

Thank you for this, ive been looking for a how to vid that actually teaches me and I love how cute you made the format 😊 BIG THANK

@Anyusha 7 ай бұрын

I'm glad you found what you were looking for! :) Thanks for watching!

@ilovelanadelrey449 6 ай бұрын

Im so glad I could find a template that is actually free lol. Ill be using this so much!

@chinmayjoshi977 Жыл бұрын

Thanks a million Anyusha, was looking for such a tool, you've built it spot on!

@Anyusha Жыл бұрын

Thanks so much!!

@christysaves4909 2 жыл бұрын

Thank you for sharing this. It's exactly what I was looking for.

@Anyusha 2 жыл бұрын

I'm glad I could deliver Christy! 😁

@dayrabarona 5 ай бұрын

@Anyusha, thank you so much, I made the habit tracker, and I love it. Useful and pretty!

@user-zy7du2sc3j 6 күн бұрын

THANK YOU!!! YOU ARE THE BEST

@prattgrand 11 ай бұрын

This is lovely and will be very helpful for me. Thank you for your generosity!

@Anyusha 7 ай бұрын

No problem at all! I'm glad it helped :)

@macforless 2 жыл бұрын

So awesome! Also your voice is so sweet and you make it very easy to understand. Thank you!

@Anyusha 2 жыл бұрын

aww thanks so much! You're too kind 🙈❤️

@Cora_la_flor 6 ай бұрын

This is great!

@AmberleighOrgill Жыл бұрын

thank you for free trial!

@ikanaide3885 11 ай бұрын

i almost spent money on this until i found your video! thank you so much for the template and all the help

@Anyusha 7 ай бұрын

Happy to hear that the templates helped you! 🧡

@OmniKoneko 8 ай бұрын

Thank you so much, you're an amazing person!

@Anyusha 7 ай бұрын

Aww thanks so much! :)

@miltonoliveira8507 6 ай бұрын

Thank you!!

@chirpm7462 2 жыл бұрын

Very helpful. Thanks a bunch. 🥰

@Anyusha 2 жыл бұрын

Glad it was helpful for you! :)

@spadesaavedra8137 2 жыл бұрын

FInally! Someone made it! Thank you 💕

@Anyusha 2 жыл бұрын

Glad to hear you got what you were looking for ❤️❤️

@angelesprz Жыл бұрын

Thank you for the free template! But also for explaining how to do our own version! I love it 🥰

@Anyusha Жыл бұрын

You're very welcome! :)

@aracelivelazquez1985 Жыл бұрын

can someone help because i did not get the template

@bodyadubatovka9758 Жыл бұрын

@Anyusha may I kindly ask you please to share with an template you did, as I found it tricky to download for some reason? Thank you in advance and highly appreciate your time, forces and support with this.

@relaxedbrain4237 8 ай бұрын

Thank you so much! I wish you all the best!

@Anyusha 7 ай бұрын

Thanks so much!!

@hameley12 Жыл бұрын

The habit tracker is beautifully done. I was trying to edit in more tasks but the spreadsheet undoes or deletes the rows that you created. I've tried various times to add the horizontal rows for tasks. Maybe Anyusha or someone else in the comments please help me out. How do I edit the rows? Many thanks ahead of time!

@user-tb8ro5ik7w 8 ай бұрын

These are awesome. Thank you so much.

@Anyusha 7 ай бұрын

Glad you like them!

@silviaguevara1921 Жыл бұрын

I loved it

@gboluda Жыл бұрын

Thank you!! This video is very useful!!

@Anyusha 7 ай бұрын

No problem!!

@lunangellus Жыл бұрын

As someone who does not have any experience in Google Sheets, this is a blessing from the sky. Thank you so much

@Anyusha Жыл бұрын

I'm super glad to hear it helped you! 💗💗

@ashikvega 2 жыл бұрын

I was going to make one, but you've saved my time! People are selling things like the ones where you made and gave us for free!! Many thanks! ❤

@Anyusha 2 жыл бұрын

Glad to hear that I could help you out! 🌺🙂

@laureverie8675 3 жыл бұрын

I have ADHD and struggle with executive dysfunction but your videos help me a lot!

@Anyusha 3 жыл бұрын

Aw you're too sweet, thank you so much, I wish you well 💕❤🌷

@kxrivera 8 ай бұрын

so easy! love it

@Anyusha 7 ай бұрын

Glad to hear! :)

@TranquilSoulSanctuary 20 күн бұрын

Thank you so much

@felixnyamongo 2 жыл бұрын

Thanks. Very Helpful

@Anyusha 2 жыл бұрын

Glad it was helpful!

@krrrr8870 2 жыл бұрын

Thank you so much for this! Very helpful and I am actually excited to make a tracker 🌸

@Anyusha 2 жыл бұрын

Woohoo!! Let me know how it goes!

@Biotechnologyfriend2649 7 күн бұрын

Thanks a lot

@saraj396 3 жыл бұрын

This is a great idea! Thanks!😊

@Anyusha 3 жыл бұрын

Glad it was helpful Sara! 🥰 What are you trying to get into the habit of doing?

@saraj396 3 жыл бұрын

@@Anyusha In August I want to step up my health game so maybe I will use Google Sheets? I will keep you posted on how it turns out.

@Anyusha 3 жыл бұрын

@@saraj396 Love your plan! Definitely keep me posted!

@BeeSTee 3 жыл бұрын

This couldn't have come at a better time...I have moved from being super complicated and app dependent on my productivity. I've scaled back on all the different types and methods of planning and productivity and have been exclusively using onenote for my task planning since April its been going so great that I felt confident to start habit tracking again. (Habit tracking can be such a productivity killer) I wasn't sure how to do it so I had been watching bujo vids and digital planning vids to try and see how I could incorporate habit tracking and onenote... I even recently rewatched one of your videos but that also seemed a bit too much for how I'm currently tackling my planning methods. This method though 🤯🤯🤯. It would have taken me forever to think of excel and onenote habit tracker even though I use excel and onenote to manage my reading lists and skincare product try lists. Anyway life story aside. THANK YOU SO MUCH!!!! SO HELPFUL I love watching your videos, you make productivity simple but still anesthetically pleasing.

@Anyusha 3 жыл бұрын

You are too kind!! Thank you so much! I have definitely been in the same position before where I make things waaayy to complicated with apps and such! Habit tracking can be a productivity killer sometimes when it's too complicated, I am happy to hear that you're getting back into it. It's great because this habit tracker can be embedded into OneNote which is amazing! I wish you luck on your planning journey ❤❤❤ I really appreciate your support and comments like these give me such inspiration to create content like this!! Sending love!!🌺🌺🌺

@donnadie8281 Жыл бұрын

I love it Thank you

@Anyusha Жыл бұрын

Glad to hear!

@7days280 2 жыл бұрын

Thanks for the guide

@Anyusha 2 жыл бұрын

Happy to help! :)

@ludviglila1407 2 жыл бұрын

Thanks you for the free template! Gonna try to make it my own style but the layout you made is really well done. Ive tried so many different apps for tracking my habits but i feel like most of them cost to much. Thanks again :)

@Anyusha 2 жыл бұрын

No problem at all! I'm happy to hear you like the templates, lots of luck! 🙂

@dorishidalgo2830 Жыл бұрын

I am agre with You. Apps doesn't work foto me. My question is. How can i use this on My iPhone? They only way is downloading Google Drive?🤔

@duythangpham5719 2 жыл бұрын

thank you very much !

@Anyusha 2 жыл бұрын

You are utmost welcome! 💖

@cynthiaacosta353 Жыл бұрын

Is there a way that we can add on to this a graph of some sort to actually see the progress?

@MESSIMAHJJL1233 2 жыл бұрын

People like you make other peoples life better. You really do an impact in somebody else life. I am proud of you and so should you.

@Anyusha 2 жыл бұрын

Aww Emani, you are making my week, thank you for such kind words ❤️❤️❤️

@TheMilliaC 2 жыл бұрын

Thank you for making this video. I'm trying the habit tracker for the first time, in my life, and I believe it will help me tremendously! I'm starting small. Wish me luck!

@Anyusha 2 жыл бұрын

That's awesome! Definitely start small, like 1-2 habits and slowly work your way up as you get into the habit of doing them :) Rooting for you!!! ❤

@gettingphinenow Жыл бұрын

This is awwweeesssoommeeee!!

@Anyusha Жыл бұрын

Thank you so much!! 🌞

@mochi_S93 Жыл бұрын

Can you create a tutorial for a monthly or yearly budget planner?

@gabrielabernal5596 2 жыл бұрын

Thanks. This looks lovely and very simple to track

@Anyusha 2 жыл бұрын

Glad you enjoyed the video Gabriela! :)

@Brenda.Aguilar Жыл бұрын

Thank you!

@Anyusha Жыл бұрын

No problem gal!

@controllerrr 2 жыл бұрын

Thank you for taking the time to do this! I'm really excited to use this tracker.

@Anyusha 2 жыл бұрын

Hope you enjoy it! :)

@ericjr90 10 ай бұрын

awesome work!

@Anyusha 7 ай бұрын

Thank you!

@kr0k3tt 2 жыл бұрын

Hey thanks for the video. I'm not sure if you know this (or if you did it one line/column to make it easier to follow) but functions like insert row/column or resize a column or row can be done more than one at a time. The resize for instance can be done by selecting all columns you want to resize and then changing the size of one and then they all change at once. Inserting is much the same you select the number of extra columns/rows you want and then insert to and it will insert the selected number of columns/rows.

@Anyusha 2 жыл бұрын

Hahah yes I learned that after I made the video 😄 thanks for the tip :)

@_slqd6180 2 жыл бұрын

Thank you so much for this, it really means a lot to me. Wish you the best of lucks!

@Anyusha 2 жыл бұрын

Ah you're very welcome! Thank you! 🍓❤️

@stefandaniel501 10 ай бұрын

VERY NICE!

@Anyusha 7 ай бұрын

Thanks!

@mrartivanov Жыл бұрын

Thank u!

@Anyusha Жыл бұрын

no problem! :)

@mrwaiyantunmrwaiyantun1999 Жыл бұрын

Yes❤

@aba2916 Жыл бұрын

Thank you so much for this. Saves me like $15 which isn't worth it if you can create your own and this doesn't take that much time either.

@Anyusha Жыл бұрын

Glad it helps! :)

@Rahulkumar-ow1fl 2 жыл бұрын

Thank you show much.

@Anyusha 2 жыл бұрын

No problem! 😄

@sona-bw9fu 4 ай бұрын

Hi after adding mailid I am not receiving habit tracker its not working

@Ddoubleyou24 Ай бұрын

This is great, thank you! The link to your guide and template does not seem to be working, once I input the email and name it says the submission failed. Is the form still active? :) thanks!

@hashknight1 3 жыл бұрын

thank you very much for the template. I am using it to complete my missed prayers. thanks again

@Anyusha 3 жыл бұрын

You are very kind, I'm happy to know that it helped you 💖

@atanumaji1739 6 ай бұрын

using this in 2024. Thanks @anyusha !!

@enwthtluv Жыл бұрын

Hiiii, can you make a tutorial on how to make a habit tracker with growing flower. Tysm❤❤❤

@shahriar6640 2 жыл бұрын

i love your voice

@janamour_13 2 жыл бұрын

So helpful! Thanks.

@Anyusha 2 жыл бұрын

Happy to hear it was helpful for you Jana! ❤

@momori5785 Жыл бұрын

this is so cutee! but instead of it being total count of the checkboxes, how do i make it into percentage?

@discoveracademia6632 2 жыл бұрын

THIIS IS FANTSTIC! THANK YOU!

@Anyusha 2 жыл бұрын

You're welcome!! Thanks so much for watching 😄

@missmoon77 2 жыл бұрын

This is beautiful, thank you😍

@Anyusha 2 жыл бұрын

I'm so glad you like it 🥰

@competitionpreparation5999 2 жыл бұрын

Thank you

@Anyusha Жыл бұрын

Welcome!

@LydiaQ17 Жыл бұрын

All in one place, so simple but so useful. This is what I was searching for. Good bye bu-jos, planners and other similar stuff I waste time on. Thank you 1000x.😀

@Anyusha Жыл бұрын

Hahah I'm happy to see you found the ideal system for yourself! 😄

@papertangerines7109 6 ай бұрын

The link I received for the tracker does not work

@laurenrestrepo9855 Ай бұрын

Hi love I submitted my email to get the tracker but it said error form submission. Is there another way? Thank you for your video

@manasritha4557 4 ай бұрын

Thanks a ton! ❤Could you please see if the link is working? I didn't receive any mail despite trying for a while

@kitty-uc5no 2 жыл бұрын

thank you so kind of you to give us the free template🥰

@Anyusha 2 жыл бұрын

No problem at all, glad I could help a gal out! ❤️

@mackysigg6365 3 жыл бұрын

You have a lovely, sultry voice ... love it!

@Anyusha 3 жыл бұрын

I'm very flattered, thank you 🙂

@krishiajainnea.devera51 Ай бұрын

This is an excellent tutorial! Btw, the link for the template is not working.

@yogurtnanas 2 жыл бұрын

omg this is what I want! thank you so much

@Anyusha 2 жыл бұрын

Woohoo! Happy to know it helped you! :)

@ritishabhaumik9194 3 жыл бұрын

Pretty genius. Thank you

@Anyusha 3 жыл бұрын

Thanks so much Ritisha ❤

@hulubangaGutenWami 2 жыл бұрын

Thank you soo much! Had been searching google for so long. All that surfaced was how to log time of "your employees" took me half an hour to find this tutorial.

@Anyusha 2 жыл бұрын

Woah, a half an hour? I'm glad you finally found what you were looking for at the end of it!

@Feynman.R Жыл бұрын

I love Google sheets. I create habit tracker, todo list, and a lot of useful boards that boost my effectiveness. It is easy to customize, and very powerful, especially with macro's. All this apps, like Notion, Todoist and others just distract me from what I need to do.

@Iamkarlaramos 2 жыл бұрын

Hello Anna, I watched the habits tracker using google sheets, trello and one note. I don’t have the patience to do the one note one. However, I agree it’s a great one. I have a question for you, Which tracker is more effective trello or google sheets?? And Which do you use on daily basis??

@Anyusha 2 жыл бұрын

I'd say the google sheets one is the easiest to use for a beginner for daily use! :)

@Arghanun.singer Жыл бұрын

Very helpful. Thank you very much

@Anyusha Жыл бұрын

Happy to hear! :)

@TuDiiTN 4 ай бұрын

Hi i love your tracker and tried to use the template and nothing was sent to me. is there an updated link? Thanks for sharing!

@Anyusha 4 ай бұрын

Hey! Seems like there is an issue! Email me directly at hello@imanyusha.com and I will personally send it to you :)

@vliciouss 4 ай бұрын

I had the same issue 😩

@cozyannie 5 ай бұрын

for some reason I'm not reciving the habit tracker when putting my email in when I go to the link in description.

@shelby-alexamyers7021 4 ай бұрын

I have had the same issue, and I put in two different email addresses

@putrialfa8694 Жыл бұрын

THANK YOU SO MUCH!!

@Anyusha Жыл бұрын

Glad it helped! 🙈🙈

@mahmoudshehata9540 Жыл бұрын

Thank you very much ❤🙌

@Anyusha Жыл бұрын

You're welcome 😊

@user-hl6iz6uh8g 4 ай бұрын

i'm not ablle to download the tracker..could somebody plsssss help me out? @anyusha

@cellno.7 2 жыл бұрын

THANK YOU SO MUCH

@Anyusha 2 жыл бұрын

You're so welcome!

@janicefrancesca3386 4 ай бұрын

Guys, the countif formula to count the checkboxes is error. I've tried so many times, what should i do?

@lorenagomez7435 10 ай бұрын

I can't get access to the habit tracker :(

@layparisss Жыл бұрын

Can I use this in Excel on my MacBook

@Anyusha Жыл бұрын

Yeah, probably :)

@shahriar6640 2 жыл бұрын

that was perfect

@Anyusha 2 жыл бұрын

thank you!

@ahanabanerjee01 16 күн бұрын

Unfortunately I did not receive my free template. an error is being shown after filling in the details and submitting the email form

@haifaaziz9533 2 жыл бұрын

Hi the formula didn’t work on excel, the one in cell AG2 can u help with it please, I don’t have access to google sheets

@Anyusha 2 жыл бұрын

I've never used excel before :( Google sheets is all I've used!

@kaybaye7628 Жыл бұрын

Sad i can’t do this on google sheets on my iPad i can’t find the check boxes 😭

@arya1524 18 күн бұрын

Hey my formula is not working. I did exactly what u did.

@wiktoriaz.9082 Ай бұрын

Your site said error form submission, it wont work :(

@NK-dv6yu Жыл бұрын

Hi, I am not able to send the template to myself?

@Anyusha Жыл бұрын

What are you having issues with exactly? :)

@czxherrjamias2704 Жыл бұрын

For some reason the formula isn’t working for 2023 version of google sheets

@Bespokenblog 9 күн бұрын

I went to get the free template but just get an error :(

@OliVeeTV Жыл бұрын

Thanks --Emoji [Windows Key]+ "."

@Anyusha Жыл бұрын

The hotkey combo I use the most, that's for sure 😄

@janamour_13 2 жыл бұрын

How do I get the emojis?

@Anyusha 2 жыл бұрын

Right click on the screen and there should be an ''emoji'' option :) Hope this helps!

@nabdallah1791 Ай бұрын

i cant download it ):