+2I would like for the Due Date to be left blank instead of #Error if there is no start date or SLA.
Can someone help with an additional formula that I could add to the one above?
Thank you.
Best answer by aleaja
You could write this at least two ways.
1) Using ISERROR:
IF(
ISERROR(
WORKDAY(
{Start Date},
{SLA Test}
)
),
"",
WORKDAY(
{Start Date},
{SLA Test}
)
)2) Checking for values in the relevant fields:
IF(
AND(
{Start Date},
{SLA Test}
),
WORKDAY(
{Start Date},
{SLA Test}
),
""
)+5You could write this at least two ways.
1) Using ISERROR:
IF(
ISERROR(
WORKDAY(
{Start Date},
{SLA Test}
)
),
"",
WORKDAY(
{Start Date},
{SLA Test}
)
)2) Checking for values in the relevant fields:
IF(
AND(
{Start Date},
{SLA Test}
),
WORKDAY(
{Start Date},
{SLA Test}
),
""
)+2Thank you. How do I add the original formula and one of the formulas you provided? Can I have two formulas together? If so, how does it look?
+5Hi @JaclynB, both of the formulas in my initial response include your original formula. The two formulas I offered are two ways of doing the same thing. You can use the one you prefer.
+2Thank you for your help. The errors are gone however the formatting is not correct. Can you help me so it shows as a (work) day?
Background:
When start date and SLA number are entered the due date automatically updates using a work day formula.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.