Skip to main content
Solved

Format values from multiple fields (formula or automation)

B

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!

Best answer by Sho

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?

 

View original
Did this topic help you find an answer to your question?

2 replies

S
  • Sho
  • Inspiring
  • 560 replies
  • Answer
  • July 19, 2023

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?

 

B
Sho wrote:

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")

S
1 person likes this

Reply


Most helpful members this week

Terms & Conditions