Hide Error



I have a sheet with a couple of big weighty formulas. Sometimes the cells containing the formulas are not required to be used in the row and criteria might be missing in the row and so the error #INVALID VALUE appears as expected.

How can I hide this error from the sheet as it shows up on reports and makes them look bad. I have seen there is an IFERROR function however my formula is already so long I am concerned about getting it in there and was wondering if there is a simpler solution




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!