Smartsheet and JIRA integration

Hi,

I have two questions related to Smartsheet and JIRA integrator and I'd like to know if somebody here could help me:

** Question #1: Is it possible to insert a row (automatically) within a parent structure from JIRA integration? For example, suppose I have this smartsheet:

Marketing Team Tasks

Task 1...

Task 2...

Task 3...

IT Team Tasks

Task 1...

Task 2...

Then, I'd like to add a new task ("Task 4") in JIRA to Marketing team and want it "inserted" within correct parent task (below Task 3 from Marketing Team Tasks). Is it possible?

** Question #2: It's almost the same situation described above, but want to insert a new item (eg. an Epic issue) and want it sorted in correct position/row in the smartsheet. For example, suppose I have this:

Type Epic, Task 1

Type Epic, Task 2

Type Epic, Task 3

Type Story, Task 4

Type Story, Task 5

Type Story, Task 6

Type Story, Task 7

Then, I'd like to add another Epic issue in JIRA ("Issue 8") and want it inserted together with all other Epic rows. Is it possible?

Thank you,

John

Find more posts tagged with

Services

Integrations

Support

Product Development

Project Management

Comments

Robert Poddar

Hi John,

How have you configured your JIRA connector? Is it Automatic (both ways) or Manual (either way)?

If it configured as Automatic, then whenever a new ticket is created in JIRA and it fulfills the fields criteria that you have mentioned in the JIRA connector, the new ticket will automatically appear at the end of your Smartsheet plan.

If it is configured as manual, then whenever you click the "Run" button in the JIRA connector, it will then add the new ticket into the Smartsheet plan.

With respect to your Question #1 & Question #2, if the JIRA Connector is configured as "Automatic" then you don't have any issues and you can move the ticket to the location where you want it to be. If your JIRA connector is configured as Manual, then whenever you click "Run" button in the JIRA connector, the ticket sequence will change.

I had faced this issue when i configured by JIRA Connector as Manual, since i wanted the flow from JIRA to Smartsheet. I changed the flow from Manual to Automatic and now i don't have any issue, if i move the ticket in the plan.

Hope this helps..

JohnSmith

Thank you Roberto for your answer!

It's configured to perform a two-way automatic updates, but I'd like to know if there's a way to insert new row automatically within a parent structure. In the scenario above, I'd like the connector insert automatically the new Issue/Task 4 in the same 'group' of tasks related to the other Marketing Team tasks. Do you know how to do that? Can you give me a hint?

The second question is about a Sort functionality that I'd like to know if Smartsheet (or the connector) has, and if does, how to perform a sort in the sheet after a new row has inserted.

Thank you!

Robert Poddar

Hi John

I don't think it is possible that the JIRA connector will "place" the new ticket automatically within the parent structure. I have noticed that it always places the new ticket at the end of the project plan..

The "Highlight Changes" option will indicate any changes that are done to the plan. You can track using this option to see which tickets have got added into the plan; hence you wouldn't need any Sort functionality to check out the newly added ticket(s).

Hope this helps..

Robert.

Sign in to join the conversation!

Quick Links

Trending discussions

One user cannot select any sheets in the Jira Connector
We have a Service Account (that we use to set up all our Smartsheet/Jira workflows. Intermittently, when logged in as that user, we are unable to select any Smartsheet from the dropdown list (see image). The Service Account is a Sys Admin as well as a Jira Admin in Smartsheet, and is a licensed Member. It is an org admin…
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!