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?

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

Thank you :smiling_face_with_three_hearts: :+1:

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