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