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!
Answers
-
Hi Jeff_01,
I believe what you're talking about implementing is called a WBS (work breakdown structure).
Here you can learn all about Smartsheet WBS.
Best of luck!
BRgds,
-Ray
-
This is only along with heavy use of predecessors.
-
Thanks Ray! But my question was actually simpler than that. I finally found it, and I could kick myself! I literally just tell Smartsheet to add or subtract a value from the given date cell, and it generates a new date before/after according to the math. If the column is formatted for dates.
In my case, I put the date of the main project in the cell [Due Date]1. To generate a due date 8 days before, I used =[Due Date]1 - 8.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!