In this article:

Free Assignment Tracker Template for Google Sheets (2024 Update)

May 8, 2024

Free Assignment Tracker Template in Google Sheets

You can make a copy of this simple assignment tracker template in Google Sheets for free. Don't request for permission to edit, simply go to File > Make a copy.

assignment tracker google sheets template

How to Use the Assignment Tracker Template in Google Sheets

Below we explain how to use our assignment tracker template in Google Sheets:

1. Assignment Name

Enter the name or title of the assignment in Column A.

google sheets assignment tracker template

2. Course

Write the course or subject name in Column B.

assignment tracker template google sheets

3. Due Date

Input the assignment's due date in Column C, using your preferred date format.

google sheets assignment tracker template free

4. Assigned Date

Mark the date the assignment was given to you in Column D.

5. Status

Update the current progress status of the assignment in Column E. Choose from statuses like "Not Started", "In Progress", "Completed", or "In Review".

6. Priority

Assign a priority level to the assignment in Column F, such as "High", "Medium", or "Low".

7. Notes

Add any relevant notes, reminders, or additional information about the assignment in Column G.

free assignment tracker template google sheets

Keep the tracker updated regularly to reflect any changes or progress in your assignments.

We hope that this article has helped you and given you a better understanding of how to use our assignment tracker template in Google Sheets. If you enjoyed this article, you might also want to check out our free OKR template and shot list template in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->