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.

+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