How to Create a To-Do List With Backlog Tracking in Google Sheets

How to Create a To-do List with Backlog Tracking
How to Create a To-do List with Backlog Tracking – Sheetaki

This guide will explain how to create a to-do list with backlog tracking in Google Sheets.

You can use Google Sheets to create a to-do list with backlog tracking.

When you’re overwhelmed with a lot of tasks or projects, it’s always a good idea to create a to-do list. This can help you stay on track and make your priorities in order. However, if you tend to forget your tasks over time, even after writing them down, a simple to-do list may not be enough. This is why you should create a to-do list with a backlog tracking. Fortunately, you can make one using Google Sheets!

 

Why Should You Create a To-do List with a Backlog Tracking Feature?

A to-do list with a backlog tracking feature helps you to be more focused and organized with your tasks. By using a backlog, you can place all your pending tasks elsewhere, so that you can focus on your current priorities. You can think of a backlog as a repository of your tasks that are not a priority at the moment. And by the time you’re ready to take on these tasks, you can just get back on them in your backlog and move them to your priority list.

For instance, you’re keeping a list of all the activities you need to accomplish for the day, and then suddenly, you are given a secondary task. To avoid getting sidetracked, you would keep this extra task in your backlog and get back to it once you’re done with your primary tasks.

 

An Example of a To-do List With a Backlog Tracking in Google Sheets

Here is an example of a simple to-do list created in Google Sheets.

A simple to-do list in Google Sheets

A to-do list like the one above can already help you set your priorities straight. It can help you define which tasks you should attend to next. But as more tasks are added, the list becomes more chaotic, and you’ll just get more startled.

That’s why it’s always a good idea to include a backlog tracking. When added, you can further streamline your to-do list:

An Example of a To-do List With a Backlog Tracking in Google Sheets

A to-do list with backlog tracking

Having a backlog tracking allows you to easily reorganize your tasks and emphasize those that really need immediate action. In this way, you won’t be overwhelmed, and you can stay on top of your projects.

You can make a copy of the example spreadsheet by clicking the link below.

You see how a backlog tracking makes a difference? Now, let’s learn how to create a to-do list with backlog tracking in Google Sheets.

 

How to Create a To-do List with Backlog Tracking

Unfortunately, there’s no built-in template in Google Sheets for a to-do list with backlog tracking. However, we can make one from scratch just by using its set of tools. Here’s what you need to do to create a to-do list with backlog tracking in Google Sheets.

 

Create a To-do List Sheet

  1. Start by opening a new, blank Google Sheets spreadsheet. Type in ‘sheets.new’ on your browser and press the Enter key. A new spreadsheet will automatically be created and saved on your Google Drive.
    Create a new spreadsheet
  2. Next, give your spreadsheet a descriptive name.
    Set a name for your to-do list with backlog tracking spreadsheet
  3. At this point, we can now create the first sheet of our to-do list. Let’s start by renaming the default sheet. Right-click on the sheet’s name and then choose Rename. Afterward, rename the sheet to ‘To-do List’.
    Rename the default sheet to To-do List
  4. With the first sheet now ready, let us now create its columns. Type in the column labels of your To-do List sheet. On cell range A1:D1, type in these labels respectively: ‘Tasks’, ‘Priority Level’, ‘Status’, ‘Remarks’. Fill their cells with green color, and set their font color to white. Afterward, center align the labels and apply a bold emphasis.
    Create the columns for the To-do List sheet
  5. Great! We now have the columns of our To-do list. The next thing we need to do is to create the drop-down controls for the Priority Level column. This column will define the level of importance of a particular task. For this version of the To-do List, we’ll use two values, either ‘High’ or ‘Low’.
    To create a drop-down control for the Priority Level column, we must select the entire B column first, except its label. You can do it by clicking column header B, afterward, hold the Ctrl key on your keyboard and click the column label to exclude it from the selection.
    Select the entire B column
  6. At this stage, click the Data menu, then select Data validation.
    Open the Data validation form
  7. From the Data validation form, set the criteria as List of items. Then, enter the required values of our Priority Level column: ‘High and ‘Low’.
    Set the criteria of the data validation form

    Once you’re done with the criteria, click the Save button to apply the changes. Your spreadsheet should now look like this:
    The Priority Level column of the To-do list with backlog tracking
  8. Let us also create the drop-down controls for the Status column. This column will define the current status of your tasks. It will contain either of the following values: ‘Pending’, On Going’, ‘Completed’.Following the previous steps in creating a drop-down control, create a data validation for the entire Status column. Set the criteria as List of items, then enter each of the values above, separated by a comma.
    Create a data validation for the Status column of the To-do list
  9. Once you’re done with the Status column, your spreadsheet should update into this:
    The status column of the to-do list

Great job! Now you have a simple To-do list. All that’s left to do is to create the backlog tracking sheet.

Create a Backlog Sheet

  1. This time, click the plus button beside the To-do List sheet’s name to create an additional sheet.
    Add another sheet for the backlog tracking feature
  2. Once created, rename the new sheet as ‘Backlog’. This sheet will contain all your backlogs.
    Rename the second sheet as Backlog
  3. For this sheet, you can get creative, and you can customize the columns depending on your needs. You can also assign priority levels for your backlogs. For instance, you can use a ranking system to define which should be prioritized first and last.
  4. For this version of backlog tracking, let’s create two columns: Backlog and Priority. Type in these labels respectively in cells A1 and B1. After that, format them according to your preference.
    A to-do list with backlog tracking in Google Sheets

That’s it! Now you have a functional to-do list with backlog tracking created in Google Sheets.

 

Using the To-do List with Backlog Tracking

Just like in other to-do list apps, you can start by writing all your primary tasks on the To-do List sheet.
Using the To-do List with Backlog Tracking

If there are secondary tasks or backlogs that you need to take care of later, write them down on the Backlog sheet.

Using the backlog tracking

To move a task from your Backlog to your To-do list, simply cut and paste it to the To-do list sheet.

 

Perfect! You can now use your newly-created to-do list with backlog tracking in Google Sheets.

If you want to learn more amazing tips and features about Google Sheets, check out our other Google Sheets articles.

Sign up for our newsletter to receive more useful articles like this one.

Get emails from us about Google Sheets.

Our goal this year is to create lots of rich, bite-sized tutorials for Google Sheets users like you. If you liked this one, you'd love what we are working on! Readers receive ✨ early access ✨ to new content.

0 Shares:
Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like