# Nested IF, using MONTH

Options
✭✭✭✭

I feel like I am missing something simple- maybe someone else can see it?

I want the formula to produce a "1" if the date in the row is January (01), February (02) or March (03). I want it to return a "2" if the date in the row is in April (04), May (05) or June(06), and so forth, to identify in which quarter of the year the project is scheduled to be complete.

If there is no date, just return a "?".

What am I missing?

=IF([End Date]@row= MONTH(01),MONTH(02)MONTH(03) ,"1",IF([End date]@row=MONTH(04),MONTH(05),MONTH(06) , "2", IF([End Date@row=MONTH(07),MONTH(08),MONTH(09) , "3", IF([End Date]@row=MONTH(10),MONTH(11),MONTH(12), "4", "?")

• ✭✭✭✭✭✭
Options

=IFERROR(IF(MONTH([End Date]@row)<= 3, 1, IF(MONTH([End Date]@row)<= 6, 2, IF(MONTH([End Date]@row)<= 9, 3, 4))), "?")

• ✭✭✭✭✭✭
Options

=IFERROR(IF(MONTH([End Date]@row)<= 3, 1, IF(MONTH([End Date]@row)<= 6, 2, IF(MONTH([End Date]@row)<= 9, 3, 4))), "?")

• ✭✭✭✭
Options

Hi Paul,

That formula is closer, it's no longer #UNPARSABLE, but it is returning "?" every time.

• ✭✭✭✭✭✭
Options

Is your End Date column set as a date type column? If so, exactly how is it being populated?

• ✭✭✭✭
Options

That was the issue! Thank you!!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

For troubleshooting...

The MONTH function will throw an error if the referenced cell value is not a date. In this case we used it to output the ? when there is a blank/no date. Since it was outputting the ? for ALL rows, that led me to believe that the cells being referenced did not contain an actual date value. The typical reason for that would be the column type is not a date type column.

• Options

@Paul Newcome You, sir, have saved my sanity. Thank you!

• ✭✭✭✭✭✭
Options

@Kelly Meck Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!