Help

Re: How do I change the #ERROR to null?

Solved
Jump to Solution
549 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijay_chen
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

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

See Solution in Thread

2 Replies 2
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

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: