Jira Connector only allowing one project to one sheet

Ed Sheaf
Ed Sheaf ✭✭✭
edited 06/14/22 in Add Ons and Integrations

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

Comments

  • 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
    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,

    Ed

  • aclay
    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
    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.

    Ed