Formula help

Paula Cosentino
Paula Cosentino ✭✭✭✭✭
edited 09/04/23 in Formulas and Functions

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)

Best Answer

  • Ipshita
    Ipshita ✭✭✭✭✭✭
    Answer ✓

    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.



    Ipshita Mukherjee


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!