eliminate INVALID DATA TYPE when using a IF statement to display the month

thunt06
thunt06
edited 12/09/19 in Formulas and Functions

I am using an IF statement to display the month but when I don't have a date the column is displaying #INVALID DATA TYPE.  I understand why this is happening but I don't know if I can also incorporate the use of an IFERROR statement nested. What is the correct way to eliminate the #INVALID DATA TYPE?

Here is my IF Statement that works with all the dates but displays the INVALID DATA TYPE when there is NO date.

=IF(MONTH(Completed74) = 1, "January", IF(MONTH(Completed74) = 2, "February", IF(MONTH(Completed74) = 3, "March", IF(MONTH(Completed74) = 4, "April", IF(MONTH(Completed74) = 5, "May", IF(MONTH(Completed74) = 6, "June", IF(MONTH(Completed74) = 7, "July", IF(MONTH(Completed74) = 8, "August", IF(MONTH(Completed74) = 9, "September", IF(MONTH(Completed74) = 10, "October", IF(MONTH(Completed74) = 11, "November", IF(MONTH(Completed74) = 12, "December"))))))))))))

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!