Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Workday_diff function remove #error

1983 2
cancel
Showing results for 
Search instead for 
Did you mean: 
SCOTT_GARDNER
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello-

I am trying to see the lead time between two dates and this is the function I am using - IF({DATE ENTERED},WORKDAY_DIFF({DATE ENTERED},{DATE SHIPPED}),’’").

It returns the lead time number just fine when both of the date fields are entered, it;'s when I have a blank space it still shows #ERROR.

Help Please!

Thank you.

SG

2 Replies 2

Hi @SCOTT_GARDNER - you need to check for DATE SHIPPED too:

IF(
  AND({DATE ENTERED}, {DATE SHIPPED}),
  WORKDAY_DIFF({DATE ENTERED},{DATE SHIPPED})
)

With this check, an empty field in either or both of the date fields produces an empty result:

Screenshot 2019-12-07 at 11.48.24

You also don’t need the final part of the IF statement (the empty quotes), unless you want to do something if the dates don’t exist. As an aside your quotes are “formatted”, not plain text, which also might be causing a problem.

JB

SCOTT_GARDNER
5 - Automation Enthusiast
5 - Automation Enthusiast

Perfect, thank you!!!