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
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!