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.

  • Category: List all the types of categories a Task can belong to.
  • 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 ‘Category’ 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)
  • Category: Select the category which this task relates to.
  • Due date: Enter the date which this task should be completed by.
  • Days Remaining: Automatically calculates how many days remain until the due date.
  • 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, 2023

🟢 Tip: When the ‘Days Remaining’ value is equal to 3 or less, the number will appear in red.