How can I return the nth value from a multiselect dropdown?
In looking through the community posts, I have found information about how to count the number of values selected in a multiselect (COUNTM) and see if a specific value has been selected (HAS), but I haven't found anything to help me parse the values in a multiselect. For example, let's say I have a multiselect with three values selected, I would like to pull out each of the values selected and populate them in separate columns.
One idea I have explored is to use the "FIND" function to identify the delimitator [char(10)]. That can help me get the first value out easily. But then I am finding it challenging to get the rest without a bunch of helper columns that get messy. Also, this is not very generalizable to "n" values.
Something like INDEX() would be great, but that doesn't seem to work (SS treats the whole multiselect as a single entry).
Help Article Resources
Check out the Formula Handbook template!