Formula help

Hello all, I have the formula below. I also want it to bring in another STATUS besides "Initial in Process" ... I also want it to find anything with "Ready for Credentialing". Can I just put a comma in after Initial in process and add that in Quotes?

=IF(COUNTIFS([Individual NPI #]:[Individual NPI #], [Individual NPI #]@row, [Credentialing Status]:[Credentialing Status], @cell = "INITIAL IN PROCESS") > 1, 1, 0)

Find more posts tagged with

Accepted answers

Ipshita

Hi @Paula Cosentino Yes, you can add more find options in your formula but for every additional find, you have to add another IF statement, not just a comma. Your formula will need to look for the next condition in its search criteria hence the second IF statement is required.

Try it and let me know if it helps.

Cheers,

Ipshita

All comments

Ipshita

Try it and let me know if it helps.

Cheers,

Ipshita

Paula Cosentino

ahh, it does. Thank you!

Ipshita

@Paula Cosentino I'm glad it worked! Do hit the Awesome button to my answer ;)

Cheers,

Ipshita

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.