Creating a category column based off sub-categories from a dropdown column

Hi,


I'm looking to make a column which returns the corresponding category for sub categories in another dropdown column 


For example, I have column 1: The text/number column for writing a formula to return the category and column 2: the dropdown for which I have subcategories.


In column 1, I have categories X,Y and Z. in column 2, I have A,B,C,D,E,F.


Let's say I want A and B to be under X, C and D under Y, E and F under Z.


if I select A and B in column 2, column 1 should return X in the same row.


if I select A, B and C in column 2, column 1 should return X,Y (or any delimiter like X:Y).


How would I go about doing this?


Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!