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.