Skip to main content

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

)

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

)

Thank you :smiling_face_with_three_hearts: :thumbs_up:

Reply


Terms & Conditions