Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 06, 2019 07:33 PM
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
Dec 07, 2019 03:49 AM
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:
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
Dec 09, 2019 11:07 AM
Perfect, thank you!!!