Date Dependency

mscoffin ✭✭
edited 12/09/19 in Formulas and Functions


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.  



Screen Shot 2019-07-27 at 4.00.16 PM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!