Need help with IFERROR


I have a column with a formula that pulls the month out of a Completed Date column, but if there is no completed date I get "Invalid Data Type". My original formula is =MONTH([OR Completed Date])@row), which works, but I'd like to use the IFERROR so there isn't a whole column of "Invalid Date Type". I tried =IFERROR(MONTH([or Completed Date]@ROW, " ")), but it's returning an #INCORRECT ARGUEMENT SET. Thoughts? Suggestions?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!