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.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!