I would love to be able to take action within a formula based upon which specific error the formula spits out. Right now, the IFERROR
function catches errors but doesn't tell us what kind of error it is. It would be great if we could recognize different errors like #BLOCKED
, #UNPARSEABLE
, #DIVIDE BY ZERO
, and others.
Example:
- =IF([Primary Column]@row = #BLOCKED, "Fix the error in the cell.", IF([Primary Column]@row = #UNPARSEABLE, "Check the formula.", IF([Primary Column]@row = #DIVIDE BY ZERO, "Cannot divide by zero.", IF([Primary Column]@row = #CIRCULAR REFERENCE, "Remove circular reference.", IF([Primary Column]@row = #INVALID COLUMN VALUE, "Check column reference.", IF([Primary Column]@row = #INVALID DATA TYPE, "Check data type.", IF([Primary Column]@row = #INVALID OPERATION, "Check operation.", IF([Primary Column]@row = #NO MATCH, "No match found.", "No error"))))))))
- This would help us give specific messages based on the error.
Why This Is Helpful:
- Easier troubleshooting when there's a chain reaction
- Create a column for the sheet user that explains how to fix the error in their particular sheet. (see above formula, but make it customized)
- We could color the column based on the error
- Take different actions based on different errors.
- Easier to fix problems
- Clearer error messages
- Better user experience
- Saves time
Thanks!