Table of Contents

Overview

I wanted to create a system where tasks could have related due dates that updated (somewhat) automatically. For example, let's say I have one project made up of 3 tasks that each take roughly 1 week. If my deadline changes or I get a late start on a project, I would like to make one change and have all 3 deadlines shift according to this new information.

Known Limitations

  1. This demo only works for projects with 5 or fewer related tasks.
    1. This is easily solved by adding additional columns to the Task table to accommodate more complex projects, but you do need to keep your maximum task # in mind when using this template.
  2. I wish there was a way to automatically populate my Task table when I add new Project rows. For example, it would be amazing if I could have a default set of "conference presentation" tasks that showed up when I added a new "presentation" project, and a separate default set of "report publication" tasks that showed up when I added a new "report" tasks.
    1. My current workaround is included below. I can filter the "Task Defaults" table for the "type" I need, then copy and paste the first three columns from the "Task Defaults" into the new project task table.
  3. I would like to expand on this idea at some point to make the due date of task #2 dependent on the completion date of task #1. I'm not sure if it can be done at the moment as you would need a way to timestamp the state change of the "Done" property, but it could be extremely helpful.

Tables

Projects

Tasks

Task Templates

Thanks To

I definitely did not have the regex chops to make this work! Huge thanks to the RedGregory tutorial on extracting list items.