Format values from multiple fields (formula or automation)

[Briana_Wertalik]

I am hoping there is a formula to achieve this... but not sure. I want to automatically generate the formatting that is in the "IDEAL" field on the right, that way this does not have to be done manually.

Any help/thoughts would be appreciated!

[Sho · Accepted solution]

In this case, Add a Formula field to the "Speaker" table and generate a string in that format.
Reference the field you added in the Rollup field to that table (Session?).
Rollup Field Formula : ARRAYJOIN({field name},"\n")

How about this?

[Briana_Wertalik]

Thank you!!! So much easier than I made it out to be 😓

Worked great using ARRAYJOIN((values),"\n")