Formula help

Paula Cosentino

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)

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

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

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