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

  • Genevieve P.
    Genevieve P. Employee
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!