Jira Connector only allowing one project to one sheet

Hi,

We have recently implemented the Jira connector for Smartsheet and this is working well in each sheet where we have a one to one relationship with Jira Projects. We have a single sheet which is collating all enhancement requests (using a web form as a front end) which will place enhancements into the relevant Project depending on the backlog identified (via a field on the form).

At the moment I am getting an error when I try to create a workflow for the second Jira Project (see attached). My understanding is that this should be possible. Any assistance would be appreciated.

jira connector error.jpg

Find more posts tagged with

Construction

Integrations

IT & Operations

Importing and Exporting

Comments

JoeC.

When you establish a workflow with Jira initially, you have the option of including all projects on that server or you can select up to 10 individually. Once it is created, you cannot change this. You will need to create a new flow with a new mapping if the flow does not contain the projects you care about.

In the event that you have more than one instance of Jira like my company has, for example one is hosted, one is on premise, you have no choice but to use 3 sheets - 1 for each instance of Jira and the 3rd to combine the information.

Hope this helps.

Ed Sheaf

Hi JoeC,

Thanks for the info.

With our instance we have requests coming through on one sheet and one of the fields that they enter is Project ID which determines which project this issue will be added to.

When I have multiple projects selected in the workflow, I have no way of routing the issue through to the correct project in Jira as the field is locked.

My workaround was to have a workflow created for each project in Jira and apply a filter in the SmartSheet section.

When I try to add the second workflow (using this same Smartsheet on each) I get the error.

If there is an easier way using a single workflow I would be very happy, but to date havent been able to get that to work.

Cheers,

aclay

Hi Ed, Just wondering if you ever got this figured out. I have just implemented the connector and have run into the same issue. Thanks, Amy

Ed Sheaf

Hi @aclay, All of my workflows reference all projects within the Jira instance and then I filter using JQL on the queries. Seems to get around it.

Hope that helps.

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…