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...



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.