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!
Answers
-
Try this:
=IF(CONTAINS("RN", [1st Column Name]@row), "Nursing", "Other")
-
Thank you Paul, I actually went around and used an IF(FIND()...
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!