Free Task Management Sheet Template (Google Sheets)

• Looking for a task management sheet template in Google Sheets.
• Want to create your own task management system.
• Need a simple WBS.

For those people, today we are offering a free task management sheet created with Google Sheets and explaining how to use it.

View the Template
Copy the Template

Features

• Gantt Chart ... When you enter the start and end dates for the main task, a light orange Gantt chart is displayed.
  When you enter the start and end dates for the subtask, a dark orange Gantt chart is displayed.
  When the checkbox is marked, the color of the Gantt chart changes to gray.
  If there is an orange Gantt chart to the left of the current date, it means the task is overdue.
• When a Task is Completed ... Click the checkbox, and the text of the row and the color of the Gantt chart will change to gray.
• Toggle Subtasks Visibility ... Click the "-" button to hide the subtasks. Click the "+" button to show the subtasks.
• Toggle All Subtasks Visibility ... Click the "-" button to hide all subtasks. Click the "+" button to show all subtasks.
  **This feature requires the installation of the Google App Script mentioned later. If not needed, please delete the button.
• When a Task is Overdue ... The text in column G is highlighted in red.
• Attach Files ... Enter the "?" icon in column I and insert the link into the cell.

How to Install Google App Script

STEP 1. Activate GAS

Click the "-" or "+" button

STEP 2. Click "Continue" on the "Authorization Required" screen

STEP 3. Click your account on the "Choose an Account" screen

STEP 4. Click "Advanced" on the "This app isn't verified" screen

STEP 5. Click "Allow"

You might hesitate, but you need to go through this process to use Google App Script.

Now you can use the Google App Script.

Tips for Using

Here are some tips for using a general task management sheet.

1. Separate Projects and BAU

Projects are large tasks that consume around 100 hours of time.

BAU (Business As Usual) refers to routine work or tasks that do not take much time.

The reason for separating these is that projects have higher priority and require proper task management.

2. Put Recurring Tasks in "BAU – Weekly / Monthly"

For example, regular meetings or daily email checks should be placed here.

The purpose is to ensure you are aware of the time spent and to avoid forgetting tasks.

3. Focus on Dark Orange in the Gantt Chart

When checking deadlines, visually confirm them using the Gantt chart.

Focus on the dark orange Gantt chart and prioritize tasks that are to the left of the current date.

4. Others

Refer to the following article for more task management tips.

» Reference Article: How to Implement and Use a Task Management Sheet in Your Team | heysho.com

Usage

This template was developed as a personal project but can also be used commercially.

If you have any inquiries, please contact us through the contact form.