Nested IF with IFERROR

PeggyLang ✭✭✭✭✭
edited 08/01/22 in Formulas and Functions

I have an IF statment that is working fine.

But in many cases it is returning '#INVALID DATA TYPE'. When it returns that I would like the cell to be empty. How do /where do I nest the IF with the IFERROR?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!