How to Make an Assignment Tracker | Google Sheets Tutorial

DO YOU WANT TO LEARN GOOGLE SHEETS? Check out my courses here: youarelovedtemplates.com/coll...
ASSIGNMENT TRACKER TEMPLATE: youarelovedtemplates.com/prod...

[@Shoppingcat918]

Can you tell us how to do the pie chart

[@jynxiepoo610]

I used this tutorial for my class assignment, I'll be sure to share this with my professor for her to use for her classes!

[@bautistaastudillon.2453]

You're a lifesaver, thanks so much!

[@astrielle446]

Tysm for this tutorial! It was super helpful ❤✨ this assignment tracker is going to help me a lot!

[@DahliaElizabethRose]

this was super helpful! thank you!!

[@elmarg]

This was so helpful, thank you so much for sharing this

[@pianoguy8927]

Thank you!

[@Dancethroughlife18]

Thank you so much for this ❤🎉

[@CMCStransport]

Thanks for the tutorial, a couple questions. To start, if you had a "completed date" column, is it possible to autofill that assignment's "completed date" cell with the date the left-hand checkbox was filled (or made 'True')?

[@kathleengail6396]

Hi! Can you teach us how to put the automatic date and the pie chart above? TIA

[@user-bt2sy5id1z]

And the beautification part, if u can pls upload a video
Thanks

[@merrutegutseb9188]

This was very helpful, thank you!

[@youarelovedtemplates]

Glad it was helpful!

[@jacquelineg591]

Nice tutorial ❤ question; can you make a tutorial or a short on importing lots of assignments at once like from a school rubric? That would be really helpful thanks

[@user-bt2sy5id1z]

Thank you so much
This really helped me out

[@youarelovedtemplates]

Glad it helped!

[@bendahara8284]

how can I make the "Days Left" column to turn red? for example, I have 5 days left so that particular column will turn red signifying that it is urgent.

[@DahliaElizabethRose]

what i did for mine was highlight the entire "days left" column, clicked "conditional formatting", add a new rule, format cells if "is between", input 0 then 5, then change the "fill box" color to red (or whatever color you wish). for mine I did two rules: red for days 0-1 and another one yellow for days 2-3. also if you are doing the "checkbox gray out" rule make sure to put your new rules underneath the "gray out" rule. hope this helps!

[@KingSargonTheGreat]

@@DahliaElizabethRose THANK YOU SO MUCH!! GODBLESS YOU! CUZ YOU ARE SUCH A LIFESAVER *^-^*

[@artichoke3032]

I can’t repeat my days left column, how do I make it repeat it?

[@victoriahill3804]

Due date box, followed your steps and the calender didnt pop up any other suggestions

[@KierstenBloomingdale]

It keeps giving me a time (12:00 AM) but no date. can someone help?