Hi @Scott_Gardner1 ,

What is the field type of the original field? Because if it is a Lookup or Rollup then you dont need to worry about the comma.

The extra commas make it seem its a Lookup or a Rollup

I did a concatenation in excel, but I could do a roll up in Airtable and then I would just copy the data and paste it in an open non formulated field ideally that is set up like I had listed in the rich text bullet format. So as it stands, how do I get from comma separated to a bullet format?

If this is a rollup, try

IF(

  values,

  "- " & ARRAYJOIN(ARRAYCOMPACT(values), "\n- ")

)

Then if you want to move the result to a rich text field for true bullets, move it over using an automation or using cod. A regular copy/paste from the user interface will not give you actual bullets.

Thank you!

So I have this:

ARRAYJOIN({Component 1}, ", ")

& ", " &

ARRAYJOIN({Component 2}, ", ")

& ", " &

ARRAYJOIN({Component 3}, ", ")

& ", " &

ARRAYJOIN({Component 4}, ", ")

& ", " &

ARRAYJOIN({Component 5}, ", ")

& ", " &

ARRAYJOIN({Component 6}, ", ")

& ", " &

ARRAYJOIN({Component 7}, ", ")

& ", " &

ARRAYJOIN({Component 8}, ", ")

& ", " &

ARRAYJOIN({Component 9}, ", ")

& ", " &

ARRAYJOIN({Component 10}, ", ")

& ", " &

ARRAYJOIN({Component 11}, ", ")

& ", " &

ARRAYJOIN({Component 12}, ", ")

& ", " &

ARRAYJOIN({Component 13}, ", ")

& ", " &

ARRAYJOIN({Component 14}, ", ")

& ", " &

ARRAYJOIN({Component 15}, ", ")

And I need a formula to remove the empty “,” if the Component is blank.

I am currently getting this: 6 Custom sculpted dice, Tin carrying case, , , , , , , , , , , , , (Since only 2 of the components are filled in.

Can you share a screen shot of your input fields?

They were just look up fields but I just changed them.

It looks like all the fields are single line text fields. Try this pattern.

TRIM(CONCATENATE(

  IF({Component 1}, "- " & {Component 1} & "\n"),

  IF({Component 2}, "- " & {Component 2} & "\n"),

  IF({Component 3}, "- " & {Component 3} & "\n"),

  IF({Component 4}, "- " & {Component 4} & "\n"),

))

Perfect!! Thank you.

So now how do I turn these into the rich text bullet format?

-1

-2

-3

-4

Thank you again.

NM, I saw that it automatically turns into the format!