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

[@Anyusha]

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

[@TheBrittwindham]

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]

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

[@Grace-td4kl]

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]

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

[@stephanietravis4215]

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

[@sifathazizmithi4737]

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 ❤❤❤

[@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! 💗💗

[@ikanaide3885]

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

[@Anyusha]

Happy to hear that the templates helped you! 🧡

[@laureverie8675]

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

[@Anyusha]

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

[@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!

[@ilovelanadelrey449]

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

[@sona-bw9fu]

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

[@chinmayjoshi977]

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

[@Anyusha]

Thanks so much!!

[@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]

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

[@ashikvega]

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]

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

[@GURUKUL_THE_LOST_ERA_010]

Can u share me the template link is not working

[@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.

[@syamak4530]

@@Anyushalink it’s not work for templates , so sad 😢

[@macforless]

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

[@Anyusha]

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

[@Grunfeld]

Thank you so much! Clearly explained and demonstrated 🙂

[@julia_aman]

thank you for the great tutorial, but unfortunately registration on your website doesn't work. Just refreshing a blank page after giving en email and name.

[@MESSIMAHJJL1233]

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]

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

[@ludviglila1407]

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]

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?🤔

[@momori5785]

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

[@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

[@ahanabanerjee01]

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

[@christysaves4909]

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

[@Anyusha]

I'm glad I could deliver Christy! 😁

[@cozy_annie]

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]

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

[@kr0k3tt]

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]

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

[@SimplyKaiiii]

FInally! Someone made it! Thank you 💕

[@Anyusha]

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

[@Lalalasky123]

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

[@dayrabarona]

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

[@OmniKoneko]

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

[@Anyusha]

Aww thanks so much! :)

[@mochi_S93]

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

[@SolAscendit]

The link I received for the tracker does not work

[@prattgrand]

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

[@Anyusha]

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

[@nerjemahstreaming8463]

reaally helping, imma subscribe

[@bulelwabooi9579]

hi sister I just discovered your channel and this habit tracker is exactly what I’m looking for so when I try to get it it says “submitting error” what can I do ?

[@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!

[@manasritha4557]

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

[@relaxedbrain4237]

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

[@Anyusha]

Thanks so much!!

[@shruthi10]

Thank you so much for making this

[@enwthtluv]

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

[@gboluda]

Thank you!! This video is very useful!!

[@Anyusha]

No problem!!

[@smrutimirani]

Unable to download the template, but, loved this simple and aesthetic habit tracker!

[@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!

[@chirpm7462]

Very helpful. Thanks a bunch. 🥰

[@Anyusha]

Glad it was helpful for you! :)

[@Anwirri]

I have problems with total. I try to do everything like you, but it shows me ERROR. Can you help me? pls

[@KK-hd4wy]

Same here

[@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! :)

[@AmberleighOrgill]

thank you for free trial!

[@TuDiiTN]

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]

Hey! Seems like there is an issue! Email me directly at [e-mail] and I will personally send it to you :)

[@vliciouss]

I had the same issue 😩

[@gabrielaseminario]

The link to the habit tracker does not work

[@mokhantsoletsela]

Thank you Anyusha❤

[@MariaGianHermonMoran]

THANK YOU!!! YOU ARE THE BEST

[@TheMilliaC]

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]

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!!! ❤

[@BeeSTee]

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]

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!!🌺🌺🌺

[@Mr.RobotYs]

i love you for this video thank you so much

[@saraj396]

This is a great idea! Thanks!😊

[@Anyusha]

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

[@saraj396]

@@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]

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

[@gettingphinenow]

This is awwweeesssoommeeee!!

[@Anyusha]

Thank you so much!! 🌞

[@Cora_la_flor]

This is great!

[@LorraneDavid]

Didn't get the free template :/

[@auliafristi3286]

Yes, error right?

[@N1ghtfalls]

when i do the formula its yellow but as fast as i click , its no more yellow and makes an error, why

[@krishiajainnea.devera51]

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

[@kxrivera]

so easy! love it

[@Anyusha]

Glad to hear! :)

[@netanelblessing7861]

having trouble with getting the free template, please help

[@lyndahmbugua7820]

hi try to get the free template but keep getting an error submitting the form

[@NK-dv6yu]

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

[@Anyusha]

What are you having issues with exactly? :)

[@janicefrancesca3386]

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

[@felixnyamongo]

Thanks. Very Helpful

[@Anyusha]

Glad it was helpful!

[@7days280]

Thanks for the guide

[@Anyusha]

Happy to help! :)

[@jess-i6k]

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

[@duythangpham5719]

thank you very much !

[@Anyusha]

You are utmost welcome! 💖

[@donnadie8281]

I love it Thank you

[@Anyusha]

Glad to hear!

[@silviaguevara1921]

I loved it

[@ericjr90]

awesome work!

[@Anyusha]

Thank you!

[@haifaaziz9533]

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]

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

[@arya1524]

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

[@CelestialSoulMeditations]

Thank you so much

[@janamour_13]

How do I get the emojis?

[@Anyusha]

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

[@krrrr8870]

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

[@Anyusha]

Woohoo!! Let me know how it goes!

[@hashknight1]

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

[@Anyusha]

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

[@layparisss]

Can I use this in Excel on my MacBook

[@Anyusha]

Yeah, probably :)

[@discoveracademia6632]

THIIS IS FANTSTIC! THANK YOU!

[@Anyusha]

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

[@gabrielabernal5596]

Thanks. This looks lovely and very simple to track

[@Anyusha]

Glad you enjoyed the video Gabriela! :)

[@mackysigg6365]

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

[@Anyusha]

I'm very flattered, thank you 🙂

[@_slqd6180]

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

[@Anyusha]

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

[@Brenda.Aguilar]

Thank you!

[@Anyusha]

No problem gal!

[@indriani946]

i can't download the template, cause submitting form error

[@Biotechnologyfriend2649]

Thanks a lot

[@stefandaniel501]

VERY NICE!

[@Anyusha]

Thanks!

[@Iamkarlaramos]

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]

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

[@controllerrr]

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

[@Anyusha]

Hope you enjoy it! :)

[@janamour_13]

So helpful! Thanks.

[@Anyusha]

Happy to hear it was helpful for you Jana! ❤

[@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! 😄

[@user-ss2xt1ew6i]

This looks soo cool, sadly no longer free to download 😅

[@czxherrjamias2704]

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

[@kaybaye7628]

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

[@kristinfraser5948]

Sorry, where is the link to download? I don't see in description or comments.

[@Anyusha]

It's definitely in the description :)

[@shahriar6640]

i love your voice

[@prkhumzicles]

I got lost there by the formula because you mumbled when talking about how to add that true value under the total please help

[@Bespokenblog]

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

[@missmoon77]

This is beautiful, thank you😍

[@Anyusha]

I'm so glad you like it 🥰

[@wiktoriaz.9082]

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

[@shekoofehmomahhed5440]

very very nice, I made it one for myself

[@Anyusha]

Ah that's great to hear 🥰 hope it helps you!

[@atanumaji1739]

using this in 2024. Thanks @anyusha !!

[@Rahulkumar-ow1fl]

Thank you show much.

[@Anyusha]

No problem! 😄