How to Make an Assignment Tracker | Google Sheets Tutorial

[astrielle]

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

[bendahara]

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.

[jynxiepoo]

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!

[Shoppingcat]

Can you tell us how to do the pie chart

[PremaratneMandeera]

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

[kathleengail]

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

[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')?

[bautistaastudillon.]

You're a lifesaver, thanks so much!

[EdenHufford]

OMG THANK YOU SO MUCH
i showed this to my friend and she immidiately made one of her own

[emilywoodard]

How did you get those charts at the top to look nice?

[jacquelineg]

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

[JapaneseBreakfast]

This was very helpful, thank you! <3

[RHernandez]

If i decide to keep the bubbles how can i make them go gray when the checkbox is marked? I used data validation rather than conditional formatting to keep the bubbles but now the colors remain the same after checking boxes

[juneevergara]

Thanks for this it will help me a lot.

[DanielTeshome-qt]

This is a gamechanger. Thank you for the help

[lucindacypress]

This is soo helpful! I appreciate you. Can you tell me how to add the date at the top and the pie chart? pretty please

[sarahfaisal]

hi could you please show me how did you make the pie chart above ? I have paid for the template .

[amalishanika]

Thank you.. its very help full for me to my study
.❤😊

[diluxn]

The custom formula isn't working for me... I tried redoing it multiple times but the tick box isn't making the row cross out after ticked... what do I do?

Edit: Turns out I made the table on the second column instead of the third, it's all good now!!

[Choolalala]

What that task has an specific due dates, how can i do it? Sample; missing info should be done in 2 days, call client in 1 day - without adding the dd manually?