Convert Look up to text

Ask for Help
1

Hi everybody,

I would like to convert a Look up column that is coming from a match multiple relation to a text. Is that possible? Any tips will be apreciate.

Many thanks in advanced.

Albert Puig

2

Use a Joined List column.

3

image
image1197×691 97.2 KB

Hi Darren,

Thanks for your answer, I tried but the Look up comlumn I am looking for is not showing. May be because the relation is a match multiple but I can’t avoid this…

Here an image…

Thanks again for your help.

Albert Puig

4

Sorry, what I meant is a joined list through the relation. Instead of the lookup.

5

use the ‘Join’ function.
=Join(", ", LookupColumn)
Replace “LookupColumn” with the actual name of your Look up column. Copy and paste this formula into the column where you want the text, and it should work for you!
Regards,
Lame

6

Isn’t this a Google Sheets solution? The Joined List column does the same thing and is built as a computed column in Glide.

7

OK, understood. It worked fine.

Thanks!

Albert Puig