Adding IFERROR to another IF Statement

I am trying to add an IF ERROR statement to the formula below so that it is left blank instead of saying "#invalid data type". I'm struggling to make it work and would appreciate any help.

=IF(MONTH([Launch Date]@row) <= 3, "Q1 ", IF(MONTH([Launch Date]@row) <= 6, "Q2 ", IF(MONTH([Launch Date]@row) <= 9, "Q3 ", "Q4 "))) + YEAR([Launch Date]@row)

Thank you so much!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!