Return a certain value if partial text is found on another cell

Hello guys, I've been struggling to find a good formula for this case. Basically I have one column with different text (Band 5 RN, Band 6 RN and Band 2 HCA) and I want to create a new column that returns "Nursing" when the cell contains the text RN and to return "Other" when it doesn't.

Anyone with a correct formula? I've tried IF(CONTAINS) without success. Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!