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)
Best 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.
Cheers,
Ipshita
Ipshita Mukherjee
Answers
-
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 Mukherjee
-
ahh, it does. Thank you!
-
Ipshita Mukherjee
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!