If Statement to Group Notice Dates by 0-3,4-6,7-11,12-18, 18+

Options

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

  • Mark Rojas
    Mark Rojas ✭✭✭✭
    edited 06/20/24 Answer ✓
    Options

    @Matthew Bertucci

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!