To Make an Assignment Tracker in Google Sheets
- Create a table of headings that you want to include in your assignment tracker.
- Write the assignment names.
- To display assignment status insert a drop-down menu from the Insert tab.
- Write the due date to find days left in the assignment.
- Add checkboxes in the Done column to indicate finished assignments.
- Apply Conditional formatting.
- Make a separate dialogue box to calculate all assignments by the Countif Function.
Today we will learn how to make an assignment tracker in Google Sheets. In today’s busy life, it has become very difficult to maintain and balance our daily routine tasks and academic assignments.
To prevent this panic of life, keeping track of our assignments and tasks is the right choice. But the problem is how to create an assignment tracker and on which forum. So, Office Demy has brought a tutorial on how to make an assignment tracker in Google Sheets.
Advantages of Making an Assignment Tracker in Google Sheets
The first advantage of making an assignment tracker in Google Sheets is that it is free of cost, you don’t need any subscription or to hire someone to make an assignment tracker for you. Keeping track of your email assignment gives you smooth functioning and the ability to complete every task within time.
When you have an abundance of assignments and you are overwhelmed, where to start? resulting in missed assignments. But an assignment tracker will always give you the ability to organize your assignments in a very good manner, so read the following article and make your assignment tracker template in Google Sheets.
How to Make an Assignment Tracker in Google Sheets
Creating an assignment tracker in Google Sheets is totally up to you because Google Sheets has so many functions and features, it’s up to you which level of assignment tracker you need to make and what you want to include in it. In this tutorial, I will tell you basic things through which you can easily track any assignment. So, let’s get started.
Step 1
Firstly, I have made a table of several columns where at first, I am going to add the assignments or topics’ names.
Step 2
If there are any sub-topics in your assignment then you can also group your topic’s names in the following manner as I have made three sub-topics in Assignment 2.
Step 3
In the second column to specify assignment status, I will add a drop list menu in the column. To insert a drop-listed menu in the column, first, we will have to select the cells then you can insert the drop-listed menu from the “Insert” tab.
Step 4
When you click on the “Insert” tab from the menu bar, a drop-down menu will open where we will see a “Dropdown” option as highlighted below. If you click on this option, a dropdown menu will be inserted into the selected cells.
Step 5
As you can see in the following cells the dropdown menu has been inserted. Now to assign an option in these dropdown menus, hover your mouse on it, and a small edit option will appear as highlighted below. Click on it to edit.
Step 6
When you click on the “Edit” button, a side pane menu will open on the right side of the window, here I need four different statuses to specify an assignment therefore I have added four different items in a dropdown menu with different colors.
Step 7
Once you have customized the dropdown menu, you can give any status to your assignment by selecting the dropdown menu.
Step 8
Here, you can see some examples in the following picture where I have assigned several assignments with different statuses.
Step 9
The next column in our assignment tracker is “Due date” For that we will first format our cells into Date format. To change the cell format, go to the “Format” tab from the menu bar.
Step 10
When you click on the “Format” tab, a drop-down menu will open, click on “Number“, and another menu will open where you will see different kinds of cell formats, and select any suitable date format.
Step 11
Now, you can easily insert dates in the cells, according to the assignment’s due date as I have inserted below.
Step 12
While tracking assignments, you must know how many days are left to complete your assignment. To find days left, I have put a formula that subtracts the due date from today in the following pattern.
Step 13
Here you can see now, how many days are left from today for all assignments, so you may keep alert for the completion of all assignments
Step 14
In the last column in the assignment tracker, I will add a “Done” status column where I will insert checkboxes. So, when we finish an assignment mark it as checked to indicate that it is finished. To insert checkboxes in the column again select the cells and go into the “Insert” tab from the menu bar.
Step 15
When you click on the “Insert” tab from the menu bar, you will find the “Checkbox” option in the drop-down menu through which you can easily insert checkboxes in Google Sheets.
Step 16
As you can see in the following picture, checkboxes have been inserted successfully, now you can check to mark any assignment when it is finished to remember.
Step 17
Let’s apply some conditional formatting in our assignment tracker to make it more attractive and functional as well. Select the cells of days left and click on the “Format” tab.
Step 18
In this format tab, you will see the “Conditional formatting” option, click on it to open it.
Step 19
In the column of days left, I will apply formatting that will highlight the cells that contain minimum days left so that I may put that assignment on my top priority list. To apply this formatting I will use the custom formula “E3=min($E$3:$E11)”
Where E is the column for days left.
Step 20
The result is in front of you, now you will be notified of the assignment that has minimum days left before the due date so that you may put it on top priority to complete it.
Step 21
Here, I will add one more conditional formatting, select all the data first, and open the Conditional formatting pane menu.
Step 22
In this conditional formatting as well I will use a custom formula “$F$3:$F$12” that will Format cells when you mark checked in column F.
Step 23
In this way, you can highlight those assignments that are finished when you mark checked on it as can be seen in the following picture.
Step 24
In the following example, we have very few topics but if you have large numbers of topics then, it becomes difficult to see how many assignments are pending, paused, in process, or complete. So, I have created an individual dialogue box to count these all.
Step 25
To count “In Progress” assignments, I will use the “CountIf” formula in the following pattern first, run the formula give the range then give the criteria for what you are looking for.
Step 26
In the same way, you can count all other assignments as well by just changing the criteria like, “Pending” instead of “In Progress“. To find the total count, you can use the “CountA” formula from the topic names. So, it will count all the topics from the list.
Step 27
Let’s keep an eye on this automated assignment tracker with the help of the following animation. As you can see below, the entire workbook is working through which you can easily track any assignment by assigning its status, monitoring days left, etc.
Here, I am done from my side, if you want to add anything else according to your need, you may add it to keep track of your assignment.
Conclusion
That’s all from how to make an assignment tracker in Google Sheets. Now, you shouldn’t be afraid of any sticking deadlines and organizing your assignments, make an assignment tracker for yourself with the help of the above article on how to make an assignment tracker in Google Sheets.