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

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.

Find more posts tagged with

Manufacturing

Construction

Calendar View

Formulas

Conditional Formatting

Gantt View

Cell linking

Comments

JamieRH

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

Mike 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å

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!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…