Setting a Specific Day of the Week in a Timeline
I am creating a timeline template and need the Mid-Campaign report line to always fall on a Thursday. Is there a way to "round" the date to the next Thursday without manually updating it? For example, if the Mid-campaign is supposed to be delivered on a Monday according to the standard timing, it would be adjusted the Thursday later that week.
An example of this timeline is shown below:
Answers
-
It looks like you are using dependencies, so unfortunately this is going to be a manual process. We can use a sheet summary field with a formula to output the date you need to enter, but I'm not sure that's any easier than just clicking in the cell's calendar.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!