How to match and automate dates?

If I have two tasks and want the due date from one to trigger and match a start date from the next what do I do?

For example: Task 1 has a start date of 8/20/23 and a due date of 8/29/23, when the due date is put in or changed I want the start date of Task 2 to match (also be 8/29/23).

I have tried some =IF functions and watched some videos but am still struggling. Any suggestions?

Thank you!!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!