How do I change the #ERROR to null?

How do I change the #ERROR to null?

How do I change the #ERROR and NaN to null?

Page 1 / 1

You can remove those errors by surrounding your formulas in a conditional that checks for values in the fields being operated on first.

IF(
   {Wished ETA},
   DATEADD(...)
)

You can remove those errors by surrounding your formulas in a conditional that checks for values in the fields being operated on first.

IF(
   {Wished ETA},
   DATEADD(...)
)

Thank you :smiling_face_with_three_hearts: :thumbs_up:

Sign up