Solved

How do you create a comma separated list from linked fields?

I want to list each linked entry in the “facts copy” column as a separate bullet point in a bulleted list in another column.
Here is the table:

Here is the formula I tried to use unsuccessfully:
REGEX_REPLACE(CONCATENATE({Facts copy}), “, “, “<br>⦁“)

I am not a programmer so apologies for my lack of knowledge.

Best answer by Kamille_Parks11

Instead, use a Rollup field using the “Facts copy” table’s name field. The following aggregation will make a list:

IF(values, "⦁" & ARRAYJOIN(values, "\n⦁"))

^ Array join will only put the bullet in front of each item after the first, which is why its necessary to add one at the start.

This topic has been closed for replies.

+27

Instead, use a Rollup field using the “Facts copy” table’s name field. The following aggregation will make a list:

IF(values, "⦁" & ARRAYJOIN(values, "\n⦁"))

^ Array join will only put the bullet in front of each item after the first, which is why its necessary to add one at the start.

Sign up