How to create a Dropdown from a CSV String in a column?

[lpfrnk]

Hello,

Trying to figure out how to convert a CSV string to a dropdown such that one of the values can be selected?

Example:

Bob,Joe,Tom is in row10, column1

When row10 column1 one is selected, I would like to display a dropdown of the names such that one may be selected. I am able to leverage split and index 1,2,3 but no luck with a dropdown.

Thanks.

[dbaum]

---

@lpfrnk wrote:

When row10 column1 one is selected

---

It's unclear what this means. If this cell's value is already "Bob,Joe,Tom", then there's no way within the same cell to parse that series into a list and allow the user to select part of the series to change the cell's value.

Maybe what you mean--or, at least, what you could do--is to create an additional column that uses the existing column's value as the source of a list from which the user can select a single value. For example, make the new column an Enum type and use an expression like the following in its Valid if property:

SPLIT([Names], ",")

[lpfrnk]

I changed the model a bit and was able to leverage a select from a reference sheet to create the drop down.