Help

Format values from multiple fields (formula or automation)

Topic Labels: Automations Formulas
Solved
Jump to Solution
534 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Briana_Wertalik
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

Screenshot 2023-07-19 at 12.40.23 PM.png

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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?

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

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?

 

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

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