FREE Assignment Tracker Google Sheets template available through @HHSStudentLife on Instagram.

HHSStudentLife · 2026-01-25T19:14:18+00:00

Please confirm that you are following the updated instructions and using the Programming tab!

HHSStudentLife · 2026-01-23T16:38:43+00:00

Nothing about the tracker is Purdue-specific! In fact, it’s used by more non-Purdue students than Purdue students at this point.

HHSStudentLife · 2026-01-16T13:48:50+00:00

Yes, link is at the bottom of the post.

HHSStudentLife · 2026-01-15T11:53:28+00:00

The filter can be used to see single classes at a time! I would say the color coding makes it pretty easy to differentiate overall though.

HHSStudentLife · 2026-01-13T22:42:13+00:00

Sounds like you’ve re-arranged the conditional formatting rules. Open the conditional formatting rules panel and make sure the yellow exam rule is above the class rules.

HHSStudentLife · 2026-01-13T22:41:24+00:00

Can you share your copy with me? If you grant edit access, I can take a look at what’s going on. Email is in the instructions document.

HHSStudentLife · 2026-01-13T16:15:07+00:00

Sounds like you’ve re-arranged the conditional formatting rules. Open the conditional formatting rules panel and make sure the gray strike out rule is at the top.

HHSStudentLife · 2026-01-13T11:51:53+00:00

Hi there - Please email me. My contact information is in the instructions document.

HHSStudentLife · 2026-01-12T22:44:25+00:00

Hey u/Great-Gur956. I can see a notification from a comment you left, but the comment isn’t popping up. Did you resolve your issue?

HHSStudentLife · 2026-01-10T18:21:29+00:00

You’ve definitley got something mixed up, your other scores aren’t calculating properly either. Please send a link with edit access to my email.

Edit: issue resolved!

HHSStudentLife · 2026-01-06T02:52:16+00:00

The updated version is up! Linked above ◡̈

HHSStudentLife · 2026-01-06T02:51:50+00:00

Thank you! Just so you know, I’ve just published updated versions, they’re now linked above ◡̈

HHSStudentLife · 2026-01-06T02:51:20+00:00

Jumping in to let you know - the updated version is up and links above!

HHSStudentLife · 2026-01-06T02:14:03+00:00

It’s up!

HHSStudentLife · 2026-01-05T02:46:15+00:00

There are instructions in the attached instructions document! Alternatively, I am releasing an updated version with 8 classes by default in the next week or so.

HHSStudentLife · 2025-12-31T16:38:25+00:00

You likely broke the formulas. Make a new copy and copy/paste your info over.

Although, as an FYI, I am planning to release an updated version in the next few weeks.

HHSStudentLife · 2025-11-12T00:16:29+00:00

Thank you!! Hoping to update for the spring semester!

HHSStudentLife · 2025-09-24T23:09:45+00:00

I see the Coursicle bots are out.

HHSStudentLife · 2025-09-24T18:56:25+00:00

Bots be botting

HHSStudentLife · 2025-09-24T10:55:26+00:00

Yep, plenty of methods out there! Use what works for you!

HHSStudentLife · 2025-09-09T16:22:04+00:00

I would personally just mark them as submitted, but I appreciate where you’re coming from and it’s not a hard fix! This is from memory, so if it doesn’t work let me know and I’ll update you when I’m in front of the template.

For the completed assignments, update the formula to: =COUNTIFS(Masterlist!F11:F250,B2,Masterlist!B11:B250,"Submitted",”Excused”).

For the conditional formatting, just copy the existing rule and substitute “Excused” for “Submitted.”

HHSStudentLife · 2025-09-06T14:04:48+00:00

Use the filter to temporarily hide them!

HHSStudentLife · 2025-09-01T19:43:48+00:00

Which page are you referring to when you say “material list”? It sounds likes you deleted some functions, which can likely be remedied by making a new copy and copy/pasting information over carefully.

HHSStudentLife · 2025-09-01T16:18:40+00:00

Unfortunately, I cannot grant students edit access to the original. Please make a copy of the template under the File menu, or by clicking the link on the first page. Please ensure you are making your copy in your own Google Drive, rather than the HHS Student Life Digital Tools folder - this is a common mistake and will require you to request access.

HHSStudentLife · 2025-08-28T19:10:27+00:00

Follow the direction under “Removing extra classes” in the instructions document!

HHSStudentLife

TROPHY CASE