Advancing all or some records in gantt charts

Hey All

I have a template table with sample dates, this is a process our company uses over and over. I am looking for the easiest way, to keep all dates relative to each other the same, but just advance all of them 2 weeks, 3 weeks, 10 weeks, etc. the goal is to take the template created now, and not modify each record by adding the time manually and make mistakes, but to be able to advance all the dates forward at the same time and by the same amount.

Also, is there any way while working with a gantt chart to click and select all records after a certain date and push them back a week or two? the goal of this is to be able to quickly adjust schedules in the event of a delay, ie, leave everything that is in the past as is, and ‘grab’ all future events and bump them back x amount.

thank you

1 Like

Bumping this as I’m having the same problem. The solution I’m considering is adding dependencies to all of my dates. Not an easy task, but a potential fix.

Following up on my previous comment. Adding dependencies and moving around from there doesn’t work. Spent about a half hour going down that rabbit hole before giving up.

So I came up with a work around, although it’s not exactly the smoothest:

Starting off with a table with a Start Date and End Date column. Making 2 new columns which I called New Start and New End. Plugging in a formula equation to each.
New Start: DATEADD({Start Date}, 400, ‘days’)
New End: DATEADD({End Date}, 400, ‘days’)

I used 400 days as a tester, but, of course, use whatever you need. Oh - and when it starts showing times, go back into the function -> formatting -> include a time field.

This will spit out dates 400 days in advance from the date listed in your Start Date or End Date column. Once I’ve got it where I want the start date to be, I copy the entire row and paste it into the Start Date or End Date row. I can then hide the New Start/New End rows in case I ever need to edit a few dates.

Hope this helps!