Help

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

Re: Leave Blank instead of #ERROR

Solved
Jump to Solution
4789 0
cancel
Showing results for 
Search instead for 
Did you mean: 
JaclynB
5 - Automation Enthusiast
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
aleaja
6 - Interface Innovator
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}
  ),
  ""
)

See Solution in Thread

aleaja
6 - Interface Innovator
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.

See Solution in Thread

4 Replies 4
aleaja
6 - Interface Innovator
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}
  ),
  ""
)
JaclynB
5 - Automation Enthusiast
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? 

aleaja
6 - Interface Innovator
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.

JaclynB
5 - Automation Enthusiast
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.