Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Formulas
Solved
Jump to Solution
2097 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.