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


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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!