Employee Project Task Planner for Google Sheets

Configure the Settings sheet

You can change the categories, statuses or priorities that are displayed in your planner. You may use the defaults provided, or use your own.

  • People: List the names of all the people involved in your project.
  • Status: You may rename one or more of the default statuses.
  • Priority: You may rename one or more of the default priorities.

🟢 Tip: To remove an entry in the ‘People’ list, right click on the entry and select ‘Delete Cells -> Delete Cells and Shift Up’.

Start creating tasks

The ‘Tasks’ sheet allows you to manage all your tasks. Each task contains the following columns:

  • Task: Enter the name of your task.
  • Status: Select a status from the dropdown menu.
  • Priority: Select a priority from the dropdown menu. (P1 = Most urgent, P4 = Least urgent)
  • Start Date: Enter the start date for this task.
  • End Date: Enter the date which this task should be completed by.
  • Assigned To: Select someone from your team from the drop-down list.
  • Progress: Enter a value between 0 and 100, which represents completion progress.
  • Notes: Feel free to leave a note or comment for this task (optional).

🟢 Tip: All dates must be entered in the following format: Jan 1, 2022

🟢 Tip: Progress percentage is automatically color coded.