Formula help to combine multiple rollups

[Holli_Younger]

Can someone help me combine multiple roll-up fields into one?
These fields are notes from another table. Instead of having multiple roll-up fields spreading across the projects table I’d like to combine them into 1 field. I’d like to add a “heading” of text in between each rollup to differentiate each note field. My current formula gives me an error.

CONCATENATE("Incoming Request: " & {Incoming Request}& "\n" & "Contractor Notes: "{Contractor Notes}& "\n" &"Client Notes: " & {Client Notes}& "\n" &"Project Notes: " & {Project Notes}&"\n" &)

[andywingrave · Accepted solution]

Hello! Try this:

CONCATENATE("Incoming Request: " & {Incoming Request} & "\n" & "Contractor Notes: " & {Contractor Notes} & "\n" & "Client Notes: " & {Client Notes}& "\n" &"Project Notes: " & {Project Notes} &"\n")

If this solves it, please mark this as “solved” to help the community in future. If not - Let me know, and I’ll come back to make sure we sort it out for you

[Holli_Younger]

andywingrave:

CONCATENATE("Incoming Request: " & {Incoming Request} & "\n" & "Contractor Notes: " & {Contractor Notes} & "\n" & "Client Notes: " & {Client Notes}& "\n" &"Project Notes: " & {Project Notes} &"\n")

This worked perfectly, thank you. What change did you make?

[andywingrave]

It was just a shift to the inverted commas - You had it pretty much spot on, but the change I made was the kind only a fresh pair of eyes would be able to solve

:eyes:

[Holli_Younger]

Thank you. I appreciate you helping and the further explanation.

[kuovonne]

andywingrave:

It was just a shift to the inverted commas

It looks like you inserted a missing & in the concatenation.

Things like this are so hard to catch!

[Justin_Barrett]

BTW, I’m not sure if you’re aware of this, but you’re actually using two different forms of concatenation in that formula: the CONCATENATE() function and the & operator.

CONCATENATE() is designed to be used like this:

CONCATENATE(item1, item2, item3, ...)

Notice the comma separation between items. You’re passing in each item as an argument to the function.

The & operator is designed as a shortcut way of concatenating a series of items, and is meant to be used on its own, like this:

item1 & item2 & item3 & ...

By combining everything using the & operator first, and then passing that single item to CONCATENATE(), you’re effectively concatenating a single string that has already been concatenated. :slightly_smiling_face: In the end, all you need for your formula is the inner portion, without the CONCATENATE() wrapper around it.

One more optimization: I noticed in a few places that you’re doing this:

... & "\n" & "Another string" ...

…when the newline escape code ("\n") could be combined with the string immediately after it:

... & "\nAnother string" ...