Help

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

Topic Labels: Formulas
Solved
Jump to Solution
1896 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Britt_Mottola
5 - Automation Enthusiast
5 - Automation Enthusiast

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:
Screen Shot 2022-05-24 at 3.15.52 PM

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.

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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.

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

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.