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.
Updated 19 hours ago