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
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
This worked perfectly, thank you. What change did you make?
This worked perfectly, thank you. What change did you make?
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
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
Thank you. I appreciate you helping and the further explanation.
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
It looks like you inserted a missing & in the concatenation.
Things like this are so hard to catch!
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. 
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" ...
