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

edited 12/09/19 in Formulas and Functions
12/31/18 Edited 12/09/19

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. 




  • This is what I would like the dates to be, done automatically for me.



  • Mike WildayMike Wilday ✭✭✭✭✭

    Yeah, that would be extremely helpful, but alas there is no way to make a start dependent on one date and the finish dependent on another. We opted to color those rows in our template to make sure they all aligned and adjusted when necessary. Not sure if there is another solution. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Jamie,

    Unfortunately, it's not possible at the moment, but it's a great idea!

    Please submit an Enhancement Request when you have a moment.

    A possible workaround that could work would be to use a third party tool like Zapier or similar.

    Would that work?

    Happy New Year!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.