IF any dates in a series are within a date range, then value formula
Hi There,
I've been trying to come up with a formula that allows me to check any dates within a series and if ANY of the dates within the series is within a specified date range, then it equal a value. I have listed a brief example below:
IF any of the dates within a row, i.e.:
05/12/22 05/19/22 05/26/22 06/02/22 06/09/22 06/16/22 06/23/22 06/30/22 07/07/22
Fall within a range of days (weeks, to be specific), i.e.:
05/01/22-05/07/22 (May Week 1), 05/08/22-05/14/22 (May Week 2), 05/15/22-05/21/22 (May Week 3)... ETC.
Then, if the result is TRUE, then equal a value.
Not sure if I have been looking at this the wrong way, but I have tried a couple various formulas throughout these forums, but I haven't seen anything along the lines of a series with a range. If anyone has any suggestions, I would really appreciate it!
Answers
-
Are you able to provide some screenshots for reference?
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!