IF/AND Formula not working for Date falling within a specific Month
Hi, I am struggling to get an IF/AND formula to work correctly, and hope someone can help me.
The formula is in a text/number column labeled "Oct". I need the formula to look at the date column labeled "Proposed Start Date" and the date column labeled "Proposed End Date". The proposed start date and proposed end date represent the duration of a project. I need to have the formula return the value in the text/number column labeled "Total Team" when the project will be active in Oct.
My formula is:
=IF(AND($[Proposed Start Date]@row <= DATE(2023, 10, 1), $[Proposed End Date]@row >= DATE(2023, 10, 31)), $[Total Team]8, "")
For example, the formula is working correctly for the duration data range of 06/26/23 through 04/12/23 (shown in the first row.) But it isn't for the range 10/16/23 through 05/17/24 and 10/30/23 through 01/26/24 (shown in the red boxed cells.)
Best Answer
-
Try swapping your arguments to be start date is less than or equal to the END of October and the end date is greater than or equal to the START of October.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Try swapping your arguments to be start date is less than or equal to the END of October and the end date is greater than or equal to the START of October.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you Paul! That did the trick (and makes sense.) 🤣 I knew it was something I just kept reading over. I appreciate you helping me out.
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!