Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 02, 2023 11:09 AM
I 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.
Solved! Go to Solution.
May 02, 2023 12:01 PM
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}
),
""
)
May 03, 2023 06:54 AM
Hi @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.
May 02, 2023 12:01 PM
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}
),
""
)
May 02, 2023 04:47 PM
Thank 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?
May 03, 2023 06:54 AM
Hi @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.
May 04, 2023 02:15 PM