Hi all - I am attempting to do the following:
I have board #1 that collects information.
When I hit a button, a new item is created in board #2. This automatically creates a Jira ticket.
Problem: I need to pull information out of multiple columns in board #1 in order to create the description for the ticket.
I am doing this with a formula column which uses concatenate() to pull the correct data out of the columns and create a description string. I want the format to be:
Key1: Value1
Key2: Value2
The problem I have here is that I don’t seem to be able to add in a newline into the concatenate function, so what should be a nice clean list of things (there are around 10 key/value pairs) turns into a big long string.
My questions are:
- Am I thinking about this the right way, or is there something simple that I am missing?
- Is there a way to add in a newline into concatenate(), or a different function that would work for me?