HAS function with multiple valid choices

I have created the following formula to calculate aging for a row that has not been completed:

=IF(AND(HAS([Issue Status]@row, "Pending FWCI Triage", "Pending DC Fix", "Pending Fix", "JIRA Ticket Opened")), [Date Issue Closed]@row = "", NETWORKDAYS(Date@row, TODAY()))

The test criteria I used is the following:

Positive:

Issue Status = Pending FWCI Triage

Date Issue Closed = Blank

Returned Value = 12 (which is correct)

Negative:

Issue Status = Closed

Date Issue Closed = 07/01/24

Returned Value = 12 (It should not have met the criteria to calculate the number of days and should be blank)

I'm not sure if I'm not using the HAS function correctly or if I'm missing something else.

Thank you in advance for any help you can provide.

Find more posts tagged with

Formulas

Accepted answers

Brian_Richardson

You use HAS with multiple selection dropdown columns. Is that what you have here?

If so, HAS also only takes one criteria. But, you can use OR to put together multiple possible HAS criteria:

= IF( AND( OR( HAS([Issue Status]@row,"Pending FWCI Triage"), HAS([Issue Status]@row,"Pending DC Fix"), HAS([Issue Status]@row, "Pending Fix", HAS([Issue Status]@row, "JIRA Ticket Opened")), [Date Issue Closed]@row=""), NETWORKDAYS(Date@row,TODAY()))

All comments

Brian_Richardson

You use HAS with multiple selection dropdown columns. Is that what you have here?

If so, HAS also only takes one criteria. But, you can use OR to put together multiple possible HAS criteria:

krinnap

Thank you Brian! I had a sneaking suspicion I needed to identify each condition separately, but wasn't sure.

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.