I am trying to autopopulate fields in a table based on the selections in a lookup-column in the same table. In essense the same as here:
I use the same formula structure as in the link. However, my lookup-column allows multiple selections. Therefore the field is populated with a list of the values associated with the selections of the lookup-column, separated by commas, which is fine.
For the sake of overview, I would like to add the title of the row for each value of the list.
Now, the auto-populated field looks like this:
“Value 1, Value 2, Value 3”
I would like it to look like this:
“Value 1 (row title), Value 2 (row title), Value 3 (row title)”.
It is no problem making a formula which results in one or the other, but I am not sure how I can combine the two to achieve what I am hoping.