Task Management

Admin

Updates

Explore

Task Management

Otto Kiefer

A Doc to track your tasks, including recurrences

Published on Sep 5, 2021, updated on Sep 6, 2021

⁠

Note: I use this system for my personal task management. Changes and optimisations that I’ve implemented in my personal doc and have taken over to this doc are specified on the

Updates⁠

page.

⁠

Description

When it comes to managing your tasks, a database can be very helpful.

This doc provides a system that I use myself and that meets some certain requirements I personally consider important:

Tasks should have an automatically assigned time frame status to allow smart chronological grouping

Project/Subtask relationship, whereas Projects should be listed in the main database and timeline and not in an external database. Supports one level of subtasks only, though. Further nesting leads to rather confusing views in

Projects⁠

and the nesting structure is not displayed explicitly

Recurrent tasks should be handled easily without the need to shift dates manually

The doc should work pretty well on mobile, too

⁠

Feedback

⁠

is highly welcome, especially if you detect any errors or inconsistencies.

⁠

Make a copy

⁠

if you find this doc helpful and like to use it.

⁠

Caution:

Currently there’s an automation running in this doc.

Every Monday it shifts all sample data due dates by 7 days to keep the sample data and their due dates authentic for demonstration purposes.

You should delete both this automation and the according column “Shift Due Dates (Demonstration Automation)” in the

Main Database⁠

as soon as you start entering your own data.

⁠

Setup

Areas are defined in table

Areas⁠

Recurrences are defined in table

Recurrences⁠

⁠

Important: Select on page

Database⁠

if you prefer U.S. or ISO week numbering

⁠

Task attributes

Tasks have the following attributes:

Area

Due Date

Time Frame

(calculated automatically based on due date; U.S. or ISO Weekday Numbering selectable)

I am aware that the time frames I’ve chosen may lead to some overlappings and potential misinterpretations, especially towards the end of a year.

There are different philosophies regarding this subject, and I am happy with this one.

Overdue

Today

Tomorrow

This Week

Next Week

Soon (Later than Next Week but within the next 4 weeks)

Later this Year

Next Year

Future

Unscheduled

Recurrence (optional, handled automatically)

Daily

Weekly

2-Weekly

3-Weekly

Monthly

2-Monthly

Quarterly

Semestral

Annually

2-Annually

Next Occurrence (calculated automatically)

Project (optional, to set a parent task)

Subtasks (list of assigned subtasks)

Note

File

⁠

Recurrent Tasks

Recurrent tasks won’t be shifted automatically, but rather their next occurrence is calculated automatically.

Recurrences which have x-monthly intervals and are set for a specific day of a month will always recur on this same day. There are two exceptions/problems which are resolvable but I decided not to include because they require further calculations but may be seldom enough to be treated as insignificant:

If a due date is set to a 28th of a month and a recurrence hits Feb 28th on a year other than a leap year, the date now gets treated as last day of the month and the next recurrence will be set accordingly.

If a due date is set to a 29th and a recurrence hits Feb 29th on a leap year, the date now gets treated as last day of the month and the next recurrence will be set accordingly.

Recurrences which have x-monthly intervals and are set for the last day of a month will always recur on the last day of the next interval’s month.

Recurrent tasks are expected to be closed at the assigned due date, i.e. the next occurrence will always be based on the assigned due date and not on the date the task is closed respectively shifted.

⁠

Close/Recur Button

This Button does one of two things:

If a task has no recurrence, it will simply close the task and filter it out.

If a task has a recurrence defined, the button will not close the task but shift the due date according to the selected interval.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.