Autofill a date based on the date in another cell


In the grid format I would like to be able to have a field auto-fill with a date that is based on the date in another field. So I'm doing conference tasks - if the conference starts on May 15th I enter that in the start date and have other fields automatically fill in for tasks that need to happen prior to the conference. So in the "Ship booth" field, I want to automatically enter a date of May 15th minus 10 days. Is this possible?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!