How to extract entries from a "Split Text" column into 2 new single value columns?

I am capturing multiple user selections into a Text column and then using Split Text column to create multiple comma separated components like in below screen:

But when I am trying to store these individual components into separate columns, I used single value column but its not working. Please see the screen below and suggest how to rectify this?

Glide table 3

My end objective is to store the split text components into separate columns.

Have you tried the “single value” column to select the first or last column of your array.

Yes, I tried that combination as well but still getting the same result.
Glide table 4

You must go directly to the subprocess1 column, not to the sheet again.

1 Like

Thank you. It is working now.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.