Translate Cell value to a specific number

Hello,

My Master sheet has one column called "Portfolio,". Each cell in that column *may* contain multiple values - up to 5 choices (as shown below)

I'd like a new column that would convert those "names" to a specified number (ie. 1,2,3,4,5)

for example (using below as an example), it would translate to....

1

1,2,3,4,5

1,2,3

1,2,3,4,5

1,3


Do I need to do this using a report, or help column?

thanks, tons in advance,

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!