Start Date / End Date and Dependencies

Devang DJ Jhaveri

Is it possible to use a calculated date from Colmun 1 and copy that into the Start Date and End Date with dependencies on? Since I cant use formulas in those Start and end dates I am using two additional columns (column 1 and Column 2) and want to copy that into the start and end dates

Paul Newcome

You can copy the data and use the "paste special" function to do a one-time transfer of the data, but you would need to do that every time a date was changed.

Devang DJ Jhaveri

Thank you @Paul Newcome . Is there a way to make it dynamic? using an = sign

Paul Newcome

Unfortunately that = is what starts the formula. Even just a straight cell reference cannot be used in a dependency column.

Feel free to Submit a Product Enhancement Request.

In the mean time, depending on the complexity of your durations and predecessors, sometimes formulas can be used to replace dependencies all together which would allow for your dynamic dates.