Separate Name and ID in Smartsheet multiple select column

Amr

I have a multiple select column in the sheet that contains the Name and ID of Carpenters. Is it possible to separate them in Smartsheet?

multi select dropdown.png

kowal

Hi Amr,

I assume you want to have the Name of carpenters in one column and the ID of carpenter in another column?

There are two solutions the easier one that needs some pre-work:

a) What I would suggest is having a reference sheet with 3 columns - Column 1 = "the full name of carpenter & ID" - Column 2 - "only the full name of carpenter" - Column 3 - "only the ID of the carpenter" - this is something that you would need to do manually - so after it's separated by those 3 columns you can use VLOOKUP formula in the orignal sheet (or better index/match formula) to look through the original column in original sheet but in 2 different columns provide name and in he other one the ID.

This requires some formulas skills:

b) I can see that unique in the ID of your carpenter is always like XXXXX dash(-) number eg. DF61-1 you could also use a formula that takes the word before the dash (-) and unless it finds the space it should take this to another column. It's a combination of multiple formulas like find etc.

Hope this helps.