Formula using WORKDAY, TODAY, ISBLANK - #INCORRECT ARGUMENT

I want to calculate the number of days that a ticket is in Backlog.

[Ticket Status]@row = "Backlog"

WORKDAY([Date Submitted]@row, TODAY()) is the number of days from the date of submission to current date.

I realize that my Date Submitted cell sometimes is blank so I added:

NOT(ISBLANK([Date Submitted@row]) check. Now it is:

=IF(AND([Ticket Status]@row = "Backlog", NOT(ISBLANK([Date Submitted]@row)), WORKDAY([Date Submitted]@row, TODAY()), 0))

So IF the conditions of Ticket Status is Backlog AND the cell of Date Submitted is Not Blank THEN calculate the days from Date Submitted to Today else return 0.

I get #INCORRECT ARGUMENT

Find more posts tagged with

Formulas

Accepted answers

ericncarr

Hi @markh10 ,

I think the main issue is just that you need to use NETWORKDAYS instead of WORKDAY, so it would be like this:

=IF(AND([Ticket Status]@row = "Backlog", NOT(ISBLANK([Date Submitted]@row))), NETWORKDAYS([Date Submitted]@row, TODAY()), 0)

All comments

ericncarr

Hi @markh10 ,

I think the main issue is just that you need to use NETWORKDAYS instead of WORKDAY, so it would be like this:

=IF(AND([Ticket Status]@row = "Backlog", NOT(ISBLANK([Date Submitted]@row))), NETWORKDAYS([Date Submitted]@row, TODAY()), 0)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.