- What’s your feature request?
ISERROR should return true when the input is the text "#N/A"
- What’s the problem that you’re looking to solve?
ISERROR does not return TRUE if the input value is the string "#N/A".
This results in an annoying issue where if an automation writes "#N/A" as a value (for example, as a result of a FINDROW that did not return a matching result), then any formulas that use ISERROR will NOT correctly detect that there was an error.
See the below screenshot -
Cell A2 contains a formula =FINDROW(A_Actions,"A_Actions[Action Item]=%","nonsense")
.
Cell A3 contains the text "#N/A".
The formula =ISERROR([Column1])
returns different values, as shown in Column2.
- How are you/is your team currently blocked?
I think we can work around the issue by writing to cells as the formula rather than the value, or by explicitly checking for the text "#N/A", but this was an annoying subtlety to debug.