Employee Project Task Planner

Configure the Settings sheet

Select the ‘Settings’ sheet and enter the following information:

  • 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 -> Table Rows’.

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: January 1, 2023

🟢 Tip: Progress percentage is automatically color coded.