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.
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: