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

[@mochi_S93]

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

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

[@stefandaniel501]

VERY NICE!

[@Anyusha]

Thanks!

[@missmoon77]

This is beautiful, thank you😍

[@Anyusha]

I'm so glad you like it 🥰

[@sona-bw9fu]

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

[@ahanabanerjee01]

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

[@LorraneDavid]

Didn't get the free template :/

[@auliafristi3286]

Yes, error right?

[@cozyannie]

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

[@gabrielaseminario]

The link to the habit tracker does not work

[@jess-i6k]

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

[@papertangerines7109]

The link I received for the tracker does not work

[@netanelblessing7861]

having trouble with getting the free template, please help

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

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

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

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

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

[@momori5785]

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

[@deryahatice8785]

Am I the only one that find she uses google sheets very very inefficient (adding new columns one by one, changing with of columns one by one..). I wondered if she is trolling but that doesn’t look like the case.

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

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

[@janicefrancesca3386]

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

[@smrutimirani]

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

[@N1ghtfalls]

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

[@enwthtluv]

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

[@krishiajainnea.devera51]

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

[@arya1524]

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

[@maxwellmcp930]

=COUNTIF(B2:AF2;true)

[@indriani946]

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

[@chinmayjoshi977]

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

[@Anyusha]

Thanks so much!!

[@NK-dv6yu]

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

[@Anyusha]

What are you having issues with exactly? :)

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

[@kaybaye7628]

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

[@Anonymous-ro1np]

Unable to download :( Some mailer issue...

[@Mr.RobotYs]

i love you for this video thank you so much

[@Bespokenblog]

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

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

[@TheLostCompany010]

Can u share me the template link is not working

[@wiktoriaz.9082]

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

[@cynthiaacosta353]

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

[@Yohannielove]

the downloading link doesn't work anymore

[@TheLostCompany010]

Link to template is not working please

[@ilovelanadelrey449]

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

[@shruthi10]

Thank you so much for making this

[@MonisKhan-fs1ku]

your form is not working

[@arya1524]

Your free template is not working

[@atanumaji1739]

using this in 2024. Thanks @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! 💗💗

[@lorenagomez7435]

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

[@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 🙈❤️

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

[@cams5580]

Is anyone having trouble with the checkbox formula? It’s not working for me 😢

[@mokhantsoletsela]

Thank you Anyusha❤

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

[@dayrabarona]

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

[@AmberleighOrgill]

thank you for free trial!

[@OmniKoneko]

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

[@Anyusha]

Aww thanks so much! :)

[@nabdallah1791]

i cant download it ):

[@Anhttse02596]

Form SubmittingError

[@czxherrjamias2704]

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

[@janamour_13]

How do I get the emojis?

[@Anyusha]

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

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

[@christysaves4909]

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

[@Anyusha]

I'm glad I could deliver Christy! 😁

[@SimplyKaiiii]

FInally! Someone made it! Thank you 💕

[@Anyusha]

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

[@spicynegra94k]

didn't show step-by-step EXACTLY but still a informative video

[@Anyusha]

Whoops 😅 I hope it helped still :)

[@OliVeeTV]

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

[@Anyusha]

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

[@mrwaiyantunmrwaiyantun1999]

Hi

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

[@chirpm7462]

Very helpful. Thanks a bunch. 🥰

[@Anyusha]

Glad it was helpful for you! :)

[@kristinfraser5948]

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

[@Anyusha]

It's definitely in the description :)

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

[@annabellehe4307]

Why are all the cute tutorials and templates in google sheets xD I dont have constant internet access and when I tried to open in excel it looked off

[@Anyusha]

Cause excel ain't free 🤣🤣 (at least for me hehe) Hmm that's odd, I thought they would be similar enough that it wouldn't look so off 🤔

[@Grunfeld]

Thank you so much! Clearly explained and demonstrated 🙂

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

[@duythangpham5719]

thank you very much !

[@Anyusha]

You are utmost welcome! 💖

[@MariaGianHermonMoran]

THANK YOU!!! YOU ARE THE BEST

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

[@layparisss]

Can I use this in Excel on my MacBook

[@Anyusha]

Yeah, probably :)

[@CelestialSoulMeditations]

Thank you so much

[@Biotechnologyfriend2649]

Thanks a lot

[@relaxedbrain4237]

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

[@Anyusha]

Thanks so much!!

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

[@shahriar6640]

i love your voice

[@gboluda]

Thank you!! This video is very useful!!

[@Anyusha]

No problem!!

[@Cora_la_flor]

This is great!

[@mrwaiyantunmrwaiyantun1999]

Yes❤

[@MrCrabes667]

I never receive the excel file

[@Anyusha]

Thanks for letting me know about this! I fixed the issue so it should work now, try to write your email in the form again and let me know if the email is sent to you this time :)

[@MrCrabes667]

@@Anyusha Thank you i will try again and let you know

[@benthompson6416]

Did it work for you

[@silviaguevara1921]

I loved it

[@miltonoliveira8507]

Thank you!!

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

[@mrartivanov]

Thank u!

[@Anyusha]

no problem! :)

[@ChristianFrankIvezaj]

These are awesome. Thank you so much.

[@Anyusha]

Glad you like them!

[@felixnyamongo]

Thanks. Very Helpful

[@Anyusha]

Glad it was helpful!

[@7days280]

Thanks for the guide

[@Anyusha]

Happy to help! :)

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

[@donnadie8281]

I love it Thank you

[@Anyusha]

Glad to hear!

[@gettingphinenow]

This is awwweeesssoommeeee!!

[@Anyusha]

Thank you so much!! 🌞

[@Rahulkumar-ow1fl]

Thank you show much.

[@Anyusha]

No problem! 😄