# Leave Blank instead of #ERROR

Topic Labels: Automations Formulas
Solved
2034 4
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast
Hello,

I'm current working with this formula:

WORKDAY({Start Date},{SLA Test}  ---which is the formula in the 'due date' column.

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.

2 Solutions

Accepted Solutions
6 - Interface Innovator

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}
),
""
)``````
6 - Interface Innovator

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.

4 Replies 4
6 - Interface Innovator

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}
),
""
)``````
5 - Automation Enthusiast

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?

6 - Interface Innovator

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.

5 - Automation Enthusiast

Thank 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.