Iserror Formular - Same or different column

User Talk Formulas
1

Hey,

can the iserror formular refer to its own column?

e.g. Column A is the column containing the result.

Column A:
if(iserror({Column A}), 0, 1)

Or can it only refer to a different column:

Column B:
if(iserror({Column A}), 0, 1)

Currently, I receive mixed results after refreshing the base.

Furthermore, I think the Formluar page didn´t get updated.

2

Only to a different column. That applies to all formulas by the way.

(What result do you expect from a function that is self-referring?)

1 Like
3

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.