How do I change the #ERROR to null?

[Vijay_chen]

How do I change the #ERROR to null?

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

[Jeremy_Oglesby · Accepted solution]

Hi @Vijay_chen,

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(...)
)

[Vijay_chen]

Thank you :smiling_face_with_three_hearts: :thumbs_up: