Gannt Chart Completing tasks, update dependent task dates

I am building out a Gannt chart and would like the functionality that if a task is scheduled to take 10 days, but is completed in 7 days as indicated by the task being marked "complete" (drop down menu), that the subsequent task dates would then push up 3 days. This seems like easy functionality, but I'm not sure the best way to go about it?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!