Auto Assign a Predecessor in Gantt
Hi,
I have a series of standard processes that have the same dependency and predecessor data each time.
I have the primary column as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.).
If pre-assembly is selected, for example, I always want it to start 2 days before assembly. Is there a formula that can go in the predecessor column that would automatically fill the cell with "-2" in this column when you select pre-assembly? And then when I put a start date in the assembly section, it will obviously self generate the pre-assembly date...
Does this make any sense? Please let me know if it doesn't...
Comments
-
Unfortunately you can't use formulas in any columns that are used for the dependency settings.
You could however disable dependencies and then use formulas to automate the dates.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives