Nested IF Formula

I would like the IF statement to return a specified value if based upon date ranges. For example, if a date falls within a range:

09/01/23 - 11/30/23 should return the value "Q1"

12/01/23 - 02/29/24 should return the value "Q2"

03/01/24 - 05/31/24 should return the value "Q3"

06/01/24 - 08/31/24 should return the value "Q4"

This is what I have so far: =IF([End Date]@row >= DATE(2023, 9, 1), "Q1")

Any assistance you can provide would be greatly appreciated!

Best Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer βœ“

    See if this works for you. This ignores the days and year and simply matches the quarter based on the month.

    =IFERROR(IF(AND(MONTH([End Date]@row) >= 9, MONTH([End Date]@row) <= 11), "Q1", IF(OR(MONTH([End Date]@row) = 12, MONTH([End Date]@row) <= 2), "Q2", IF(AND(MONTH([End Date]@row) >= 3, MONTH([End Date]@row) <= 5), "Q3", "Q4"))), "")

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer βœ“

    Awesome, I'm glad you were able to learn something from it!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!