Date Dependency

mscoffin

Hi,

Our ERP system exports tasks and the materials needed for those tasks with the same task ID number.  We schedule based on the actual task and predicted duration.  Is there a way to automatically assign the same start date to the materials needed for the tasks based on the scheduling of the actual task?  Screenshot attached.  

 

Thanks!

Andrée Starå

Hi Mike,

Yes, it's possible!

It's what we have been talking about, but a more advanced version and from multiple masters list instead. It's possible to set it up with the help of VLOOKUP or a combination of INDEX/MATCH in either way.

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting