How can I alter multiple date cells by changing one date?

Options

I'm trying to create a project management sheet for a recurring project. I want to be able to put in the date the project is due, and have other cells auto-populate to a date 1 week prior, 2 weeks prior, etc. I can't figure out how to do it. I'm a fairly new user, so it may be something simple that I cant find. Any help is appreciated. Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!