Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Leave Blank instead of #ERROR

Topic Labels: Automations Formulas
Solved
Jump to Solution
6533 4
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.