Start & Finish dates based on separate predecessors / or formula in duration

JamieRH
JamieRH
edited 12/09/19 in Formulas and Functions

I am trying to automate my schedule for a project as much as possible. I have a line for production start that is based on my current ship date but I have 9 shipments after that and would like to have the actual production line have a start day based on the production start line and the finish date be the last ship date. Attached is my basic example. 

 

Is there someway to have the duration be a formula or to use different predecessors? 

I know it can be done using parent/child but then when I view multiple projects in a calendar it doesn't allow me to use different colors to differentiate. 

 

Capture.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!