Concatenating multiple Smartsheet fields into a single JIRA field

steve.estoque72076

I have a need where I need 3 different Smartsheet form fields to be concatenated into a single JIRA field.

For example I would want these 4 from My Smartsheet fields:

Description of Request
Expected results
Why is this info needed
What resources have you utilized

To all be entered into the Description field in JIRA.

Could this be done?

Find more posts tagged with

Education

Integrations

Project Management

Importing and Exporting

Comments

Nathan Lloyd

Hello,

I'm guessing you're wanting form submissions to create new Jira tickets. You should be able to achieve what you're after using a formula to rollup separate field information into the Description field. I setup a test sheet / workflow and used a JOIN function (https://help.smartsheet.com/function/join) to roll up information from multiple columns into the Description field.

To make sure things looked neat, I used the solution outlined in the Community post here: https://community.smartsheet.com/discussion/formula-line-breaks

In summary, here are the steps to take:

Add a helper column to your sheet
In this helper column, add two "-" separated by a line break (this will be used as an absolute reference)
In the Description field use a use a JOIN function and set delimiter value to "SUBSTITUTE([JOIN Helper]$1, "-", "")"

It's worth noting that once the Jira Connector syncs, the formula in the Description cell will be overwritten with the raw text value from Jira. You might want to setup a Sheet Filter (https://help.smartsheet.com/articles/2476121-jira-workflows#fieldmapping) so new issues can be reviewed before they're automatically created in Jira (if you're using an automated workflow).

Overwrite would also in turn break auto-fill for formulas (https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting when new forms were submitted. It may be easiest to setup the formula in another helper column (not included in workflow field mappings), then copy & paste the rolled up value into the Description field to sync. This way, Jira won't overwrite the formula and new form submissions will continue to include them automatically.

If you have other questions on this please feel free to submit a ticket to Smartsheet Support.

Hope that helps!

Regards,

Nathan L.

Sign in to join the conversation!

Quick Links

Trending discussions

DocuSign integration suddenly not working with contacts that display the name instead of email.
I've had a DocuSign integration working for a while now. Today, I go to use it and it doesn't work because it sees invalided characters. Upon researching, I have discovered that if the contact field displays the person's email instead of their name the integration works. So it's like DocuSign used to be able to use the…
Checking provisional members on Smartsheet for USM model
Hi smartsheet community! I wanted to check if there is any way by which we can check who all are provisional members in our existing user list. Kindly note that we have not ye to move to User Subscription Model. Thank you for your response!
Pivot App doesn't allow date columns?
I have a source sheet that has the following columns: Project Code , Milestone and Milestone Date . I want to use the Pivot app so that it gives me a row for each project code, columns of Milestones and the corresponding dates for those milestones. Am I correct in understanding that the Pivot app cannot output dates? I…