Date Formula Question
I have a date request for each month by week assigned to their DCO’s hierarchy.
- 1st week of the month Brenda Van Roosenbeek, Daniel Farmer, Carolyn Monroe
- 2nd week of month Courtney Batey Coates, Sara Speith, and Lisa Funston
- 3rd week Julie Starry, Kerry O’Leary, and Becky Harper
- 4th week Alison Swetter, Scott Withers, new DCO
I created a formula build by DCOs per week. I know one issue is the 21 day shift is creating the date shift first.
However, the weeks/dates are shifting and I need to end the week on Saturdays by DCO. Any suggestions?
=IF(OR(CONTAINS("Julie Starry", DCO@row), CONTAINS("Kerry OLeary", DCO@row), CONTAINS("Rebecka Becky Harper", DCO@row)), IF(DAY(TODAY()) <= 21, DATE(YEAR(TODAY()), MONTH(TODAY()), 21), DATE(YEAR(TODAY()) + IF(MONTH(TODAY()) = 12, 1, 0), IF(MONTH(TODAY()) = 12, 1, MONTH(TODAY()) + 1), 21)), "")
Answers
-
Are you able to provide some screenshots for context?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 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!