Auto Assign a Predecessor in Gantt

grant53396
edited 12/09/19 in Smartsheet Basics

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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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.

    thinkspi.com