How do I change the #ERROR to null?
How do I change the #ERROR and NaN to null?
Solved
How do I change the #ERROR to null?
+9Best answer by Jeremy_Oglesby
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(...)
)
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:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.