A task tracker template is essential for enhancing productivity and ensuring the timely completion of projects by organizing and prioritizing tasks effectively. Get a copy of our daily task tracker here.
Select File > Make a copy.
Follow the process below to make a daily task tracker.
Click on "Untitled spreadsheet" at the top. Type "Task Tracker" for your new name and press Enter.
In the first row, type in the following headers: Task Name, Description, Due Date, Status, and Notes. This will organize your tasks. Highlight the first row by clicking on the row number. Click the "Bold" button to make your headers bold. Then, use the "Borders" and "Fill color" options to differentiate your headers visually.
Under each header, start entering the details of your tasks. Fill in information relevant to each column for every task you want to track.
Select the cells under the Status column, go to Data > Data Validation.
Select "Add rule".
Under Criteria, choose "Dropdown," and type "Not Started, In Progress, Completed" in the text boxes. Click "Done". This creates a dropdown menu in the Status column.
Highlight the cells containing your tasks, go to Data > Sort range> Advanced range sorting options.
Tick the box next to "Data has header row". Select the Due Date column as your sort criteria. This organizes your tasks by their due dates.
Click on the cells in the Status column, navigate to Format > Conditional formatting, and set up rules to change cell colors based on the task's status.
For example, you might want "Not Started" to be red, "In Progress" to be yellow, and "Completed" to be green.
Free Sports Betting Tracker (2025 Update)
How to Keep a Running Total in Google Sheets (2025 Guide)