Helper column to differentiate current week from following week
Hello,
I have determined a way to identify the day of the week via a helper column formula with additional helper columns for the current week. What I want is a way to differentiate the current week from the following/next week. This is strictly Monday - Friday Business days. I will post below my current situation. Please let me know what I can do to separate these from each other. Thank you all!
Day of the week Formula: =IF(WEEKDAY([Start Date(訪問開始日)]@row) = 2, "Monday", IF(WEEKDAY([Start Date(訪問開始日)]@row) = 3, "Tuesday", IF(WEEKDAY([Start Date(訪問開始日)]@row) = 4, "Wednesday", IF(WEEKDAY([Start Date(訪問開始日)]@row) = 5, "Thursday", IF(WEEKDAY([Start Date(訪問開始日)]@row) = 6, "Friday")))))
Current Week: =IF(WEEKNUMBER([Start Date(訪問開始日)]@row) = WEEKNUMBER(TODAY()), 1)
[FORMULA IN QUESTION]
Following Week: =IF(OR(WEEKNUMBER([Start Date(訪問開始日)]@row) = WEEKNUMBER(TODAY()), WEEKNUMBER([Start Date(訪問開始日)]@row) = WEEKNUMBER(TODAY()) + 1), 1)
Best Answer
-
I think you basically have it. To see if it's next week try:
=IF(WEEKNUMBER([Start Date(訪問開始日)]@row) = WEEKNUMBER(TODAY(7)), true)
Or do a combined formula in one column that indicates "This Week" or "Next Week" or "Other"
=IF(WEEKNUMBER([Start Date(訪問開始日)]@row) = WEEKNUMBER(TODAY(7)), "Next Week", IF (WEEKNUMBER([Start Date(訪問開始日)]@row) = WEEKNUMBER(TODAY()), "This Week", "Other Week"))
Answers
-
I think you basically have it. To see if it's next week try:
=IF(WEEKNUMBER([Start Date(訪問開始日)]@row) = WEEKNUMBER(TODAY(7)), true)
Or do a combined formula in one column that indicates "This Week" or "Next Week" or "Other"
=IF(WEEKNUMBER([Start Date(訪問開始日)]@row) = WEEKNUMBER(TODAY(7)), "Next Week", IF (WEEKNUMBER([Start Date(訪問開始日)]@row) = WEEKNUMBER(TODAY()), "This Week", "Other Week"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!