I’m currently working on building a work-back schedule that will be used as a template for our business group. What I’m looking to do is have a standard set of items that are required for a project (e.g.: user’s guides, communications, videos, etc.) and then determine due dates based on the targeted launch date of the project.
Each item will be dependent upon either the targeted launch date, or the activity that needs to be completed before it. What I want to have happen is when the targeted launch date is set, it sets the date column of each dependency item on the board to a set number of days before the targeted launch date (and then any items dependent upon an item linked to the targeted launch date would follow afterwards based on their dependency item).
As an example, if a project is targeted to launch on November 1, 2021, then the date for “team kick-off meeting” should be set for 84 days prior (if using calendar days) or 60 days prior (if using workdays) which would populate August 9, 2021 in the date column.
I have seen the automations that push dates into the future, but we’re wanting to get our teams working backwards to better plan out projects to ensure all timelines are met along the way. This is essential for our business when working with multiple groups to make sure a certain team knows the risk they might be putting other groups in if they’re not meeting timelines.
Does anyone have any tips or suggestions (that don’t come at an additonal cost for alternative apps, etc.), that would help us build this board/workflow?
Thank you in advance.