Auto Assign a Predecessor in Gantt

grant53396 ✭✭
edited 12/09/19 in Smartsheet Basics


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