Preventing actions on certain days
I am creating a project plan that will be used as a template for several similar projects. The project has several shipments dates for "in process materials" to client for testing, but such shipping cannot occur on a Thursday or Friday. How can I set a rule that if the project automatically says something show ship on a Thursday or Friday that the day is moved to the following Monday?
Thanks for any advice
david
Answers
-
You could do 2 separate columns where one is the attempted ship date and the other is the actual ship date where the second column contains a formula dependent on the attempted ship date.
Using the formula below in the "Actual Date" column, you could achieve your desired display
=IF(WEEKDAY([Attempted Date]@row) = 5, [Attempted Date]@row + 4, IF(WEEKDAY([Attempted Date]@row) = 6, [Attempted Date]@row + 3, [Attempted Date]@row + 0))
-
Thank you Parker. I will try that later today and let you know if it works
Thanks for your assistance
David
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!