Formula Help

bborenstein

Using the below formula to pull serial numbers from multiple cells on one sheet, into one cell on another sheet.

=JOIN(COLLECT({Fleet Equipment SN Serial #}, {Fleet Equipment SN Ship Code}, Ship@row, {Fleet Equipment SN Device}, "X-Ray"), ",")

What returns is: (12345, 23456, 34567)

What I really want is: (12345) (23456) (34567) (all separate values) but in the same cell.

Is there a way to have the serial numbers as separate values, instead of one value with a delimiter? *I already have the column formatted as dropdown and "allow multiple values" turned on.

Genevieve P.

Hey @bborenstein

Yes!

Try using CHAR(10), a line break, as the delimiter instead of ","

=JOIN(COLLECT({Fleet Equipment SN Serial #}, {Fleet Equipment SN Ship Code}, Ship@row, {Fleet Equipment SN Device}, "X-Ray"), CHAR(10))

Cheers,

Genevieve

Genevieve P.

Hey @bborenstein

Yes!

Try using CHAR(10), a line break, as the delimiter instead of ","

=JOIN(COLLECT({Fleet Equipment SN Serial #}, {Fleet Equipment SN Ship Code}, Ship@row, {Fleet Equipment SN Device}, "X-Ray"), CHAR(10))

Cheers,

Genevieve

bborenstein

Thanks so much! It worked! @Genevieve P.