Using the IF and FIND function multiple times
=IF([INT REQ]@row = "No", "Not Needed", IF(FIND("TH", [APPT LOCATION]@row) > 0, "Teams", " "))
The above formula works just fine. What I want it to do is look for certain initials and assign different modalities. For example, if the APPT LOCATION starts with "TH" it will assign Teams. So far so good. I also want it to look at APPT LOCATION again and if it starts with "WIC or "NC", then assign VRI. I have tried the following but it gives me #INCORRECT.
=IF([INT REQ]@row = "No", "Not Needed", IF(FIND("TH", [APPT LOCATION]@row) > 0, "Teams", " ", IF(FIND("WIC", [APPT LOCATION]@row) > 0, "VRI", " ")))
Any help would be really appreciated.
Mily Oti
Best Answer
-
Hi @Mily Oti
When you're adding multiple IF statements together, you'll want to "nest" them in a way that says IF this is NOT correct, then check the OTHER IF statement.
This means you'll want to take out the " " at the end of your first statement and go directly into your next IF statement as the value if false, like so:
=IF([INT REQ]@row = "No", "Not Needed", IF(FIND("TH", [APPT LOCATION]@row) > 0, "Teams", IF(FIND("WIC", [APPT LOCATION]@row) > 0, "VRI")))
Let me know if this works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @Mily Oti
When you're adding multiple IF statements together, you'll want to "nest" them in a way that says IF this is NOT correct, then check the OTHER IF statement.
This means you'll want to take out the " " at the end of your first statement and go directly into your next IF statement as the value if false, like so:
=IF([INT REQ]@row = "No", "Not Needed", IF(FIND("TH", [APPT LOCATION]@row) > 0, "Teams", IF(FIND("WIC", [APPT LOCATION]@row) > 0, "VRI")))
Let me know if this works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Good morning Genevieve,
Thank you so much for the solution; it works perfectly. I appreciate you taking the time to help me out. 🙂
Have a great day!
Mily
-
I'm so glad I could help! 🙂
I hope you have a great day as well.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!