Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Format values from multiple fields (formula or automation)

Topic Labels: Automations Formulas
Solved
Jump to Solution
1124 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?

 

Briana_Wertalik
5 - Automation Enthusiast
5 - Automation Enthusiast

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

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