Help

Join two column fields together and format

Topic Labels: Formulas
Solved
Jump to Solution
1801 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Danny_hearn
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello Airtable community…

I currently have two columns

User Name
User Fact Item 1, User Fact Item 2,

User Detail
User Detail Item 1, User Detail Item 2

I need a formula that creates an array with rich text formatting that merges the two columns to create this

At the moment I’m using
{UserFacts} & “\n” & {Facts Detail}

Which is doing this
User Fact Item 1,
User Fact Item 2,
User Detail Item 1,
User Detail Item 2

But I want this

User Fact Item 1
Item 1

User Fact Item 2
Item 2

Would you be able to help or give me a pointer?

Thank you

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Thank you for the screen captures.
It looks like you have a linked record field that contains multiple links and a rollup based on those links.

Try having a new formula field in the linked table that combines {UserFact} and {Fact Detail}. Then perform the rollup on that new formula field.

See Solution in Thread

3 Replies 3

Formula fields cannot display text formatting, such as bold text.

If you want to have formatting that changes commas to new line characters, you can use the SUBSITUTE function, which is documented in the formula field reference.

If you want a formula that splits items in a list, that is also possible, although a bit of a pain.

If you’d like additional help, please give a bit more information regarding field types (single line text, lookup, etc.) and more detailed example values.

Thanks @kuovonne,
I want the ‘combined’ column to read

Funding model confusion
Most new COOPs don’t understand what funding models are available

Another thing
some kind observation

But at the moment its doing this using this formula - ARRAYJOIN({UserFacts},{Facts Detail})
Screenshot 2020-04-19 at 17.27.15

kuovonne
18 - Pluto
18 - Pluto

Thank you for the screen captures.
It looks like you have a linked record field that contains multiple links and a rollup based on those links.

Try having a new formula field in the linked table that combines {UserFact} and {Fact Detail}. Then perform the rollup on that new formula field.