- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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}
),
""
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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}
),
""
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 04, 2023 02:15 PM
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.
