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
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives