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!

    👍

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!