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

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. 




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!