How to write an if or formula with either or return?


I am trying to write a formula that says if the Department column says Pharmacology then return "Pharm" or If Department column says Biology then return "Bio"

Thank you in advance.

This is what I have that isn't working:

=IF(OR(Department@row =Pharmacology, "Pharm",IF(Department@row =Biology, "Bio")))

Best Answer

  • Protonspounge
    Protonspounge ✭✭✭✭✭
    edited 06/04/24 Answer ✓

    Hello @RPlaud

    I think the formula below is what you are looking for.

    =IF(Department@row = "Pharmacology", "Pharm", IF(Department@row = "Biology", "Bio", ""))

    This formula will give a blank in [Department] if "Pharmacology" or "Biology" are not present in [Department]. If you have more than Pharmacology and Biology you can just add to the IF statements.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!