Formula to Add Text based on Series

Hello,

I am trying to find a formula that will allow me use the series column and then return text in the approved column.

EX: if series is B, or L I want the Approver column to return RSM. If the Series column is S or K want the approver to be CE. I have hit a brick wall in figuring this out.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!