Automate creating tasks, e.g. one every week

  • 1
  • Question
  • Updated 3 years ago
Is there a way to automate creating a bunch of tasks, e.g. due once a week, starting on a specific date? In Excel it is possible to select two cells and then drag, and Excel understand I would like to have a date every 7th day. Something like that would be wonderful.

I imagine a macro can do that, but my macro knowledge is limited (at the time ...).
Photo of Bjorn Eriksson

Bjorn Eriksson

  • 197 Posts
  • 15 Reply Likes

Posted 3 years ago

  • 1
Photo of Alex Gooding

Alex Gooding, Champion

  • 886 Posts
  • 223 Reply Likes

I don't think this is possible but there is a work-around of sorts. This only works however if the tasks themselves have a duration equal to the interval required between them, they are linked by relationships with dependencies and the number of tasks you want to add each time is broadly consistent.

The following example assumes an interval of a week, but would work with any other interval between tasks.

First, create a dummy parent topic to act as the roll-up and then add to it a set of dummy tasks equal to the maximum number of weekly tasks you are likely to need, each with a week's duration and the current date as the start date. The easiest way to do this is to create the first task, format it the way you want and then copy and paste it the appropriate number of times.

Then add a relationship between each task and give them each a finish-to-start dependency. This will automatically change the start date of all but the first task to weekly intervals. Save the group with the parent topic as a map part.

To use the group simply add it to the map where required and change the start date for the first task to the one you need. This will automatically cascade through the set of tasks but the start dates should remain a week apart. If you have too many tasks simply delete one or more from the bottom of the group. You can also remove the dummy roll-up topic if you don't need it. You can then edit the dummy tasks as required.


(Edited)
Photo of Bjorn Eriksson

Bjorn Eriksson

  • 197 Posts
  • 15 Reply Likes
aaahhh, of course! Thanks a lot!
I think the developers at Mindjet could look at Excel, which is loaded with a lot of smart functions for creating repeating cells. Ideas stolen with pride :-)