If Statement to Group Notice Dates by 0-3,4-6,7-11,12-18, 18+
Hi, Looking for help please. I'm sure its some easy but I'm missing something. The formula works for 0-3 and 4-6 but not the rest.
=IF([Months to Notice Date]@row <= 3, "0-3 months", IF(OR([Months to Notice Date]@row >= 4, [Months to Notice Date]@row <= 6), "4-6 Months", IF(OR([Months to Notice Date]@row >= 7, [Months to Notice Date]@row <= 12, "7-12 Months", IF(OR([Months to Notice Date]@row > 12, "13-18 Months"))))))
Best Answer
-
Try this: =IF([months to notice date]@row > 12, "13-18 months", IF(AND([months to notice date]@row >= 7, [months to notice date]@row <= 12), "7-12 Months", IF(AND([months to notice date]@row >= 4, [months to notice date]@row <= 6), "4-6 months", IF([months to notice date]@row <= 3, "0-3 months"))))
~MR
Answers
-
Try this: =IF([months to notice date]@row > 12, "13-18 months", IF(AND([months to notice date]@row >= 7, [months to notice date]@row <= 12), "7-12 Months", IF(AND([months to notice date]@row >= 4, [months to notice date]@row <= 6), "4-6 months", IF([months to notice date]@row <= 3, "0-3 months"))))
~MR
-
Thanks Mark, I had to roundup the months column and then it worked! Thanks so much for the prompt response and help!
-
Happy to Help!
~MR
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!