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

Power automate insert row not working using dynamic Sheet Id
Hello - I am trying to use the Insert Row Power Automate Smartsheet connector and it works when the sheet ID is static/hardcoded; however, I need to be able to pass in the Sheet Id from prior step. When I change from static Sheet Id to dynamic, all of the sheet column fields go away. The problem I am having is formatting…
Switching the Logged in User for Docusign
When using the Docusign+Smartsheet Generate Documents integration, I used to be able to create a mapping with Docusign User A and Docusign Account A. I would test the process, make sure everything was good, and then swap out that user for Docusign User B and Docusign Account B. Now, I cannot do this, and I need to create a…
AppSheet - Image upload to cells crashed
Hi All, We have AppSheet integrated with Smartsheet as our User Interface in the field for use in inspections. We like AppSheet as it displays and presents data better, and uses Smartsheet's sheet as source. However, as of around Monday 1/September, we noticed that we no longer can "upload" images using AppSheet and save…