Adding a Master Date in a Board

I am not sure I am even using the correct nomenclature with this question so bear with me. I’ve also searched the database but again, i am not sure I am descring what I want correctly.

Is there a way to create a board template with a master date that guides all of the other due dates on the tasks and to-do lists within the board?

Let me explain:

We organize trips for people. Each trip have the same tasks each time so it makes sense to create a master template and then reuse and rename the template for each new trip we do.

The way I have to do it now is when I create a new trip, I have to go in and manually change the due dates of each task and to-do by selecting a date on the built-in calendar in Trello for each task or to-do.

Is there a way that I can create a task or a to-do item and just have the date automatically set off a master date?

In other words, it’d be nice to have a field for a master date in the template and when I do the various tasks, I can just put something like:

Task 1 Due Date: 2 weeks before Master Date (date of trip)

Task 2 Due Date: 1 month before Master Date

Task 3 Due Date: 2 months before Master Date

…and so on.

Then, when I copy and re-use the template for a new trip, I can set the date of the trip in the master date, and the tasks and to-dos automatically create their own date based on the blanket due dates that feed from a master date.

Does that make sense?

Thank you in advance for any guidance you may able to share…

Hi Russell,

This should be possible using dependencies and automations. Here’s how I’d set it up:

  • Add a Date column to your board and call it “Master Date.”
  • Add another Date column for “Task Due Date.”
  • Add a Dependency column to your template.
  • Link each task to the “Master Date” by setting its dependency in the Dependency column.
  • Create an automation like this: When a date changes in the “Master Date” column, push the date in “Task 1 Due Date” by X days.
  • Repeat the automation for each task, adjusting the offset as needed (e.g., -14 days for 2 weeks before).
  • Save your board as a template.

Now, whenever you set the “Master Date” for a new trip, all task dates should adjust automatically. Hope this helps!