May 26, 2022 07:52 AM
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.
Solved! Go to Solution.
May 26, 2022 09:02 AM
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.
May 26, 2022 09:02 AM
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.