Task Planner

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 -> 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)
• 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: January 1, 2022

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