Start Date / End Date and Dependencies
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
Answers
-
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.
-
Thank you @Paul Newcome . Is there a way to make it dynamic? using an = sign
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!