Split Text Column

The Split Text column splits up text by a value of your choosing. For example, say we have a list of people separated by commas.

Marie Rao, Tamsin Woodward, Alan Eijk, Fo Lambert, Christina Wallace, Ryan Holbert

Because this value lives in a single cell, Glide sees it as a single value. However we can split it up by the commas.

When we do this, we end up with a new column with multiple values.

Because this is a computed column, we can't then show that column in our Google Sheet, however, we can, for example, use it in a relation.

In the image below we have created a relation column with the joined list column which relates all employees who are attending this meeting.

We can now create an inline list inside a meeting which shows all the participants, and all we had to start with was a single cell of data! You can even show this cell in your app and allow people to add new values.