Rows lose custom order when using Jira connector

Hello everyone,

I've been using Smartsheet to keep a timeline for my projects in Jira.

So far everything has been working great but I noticed an issue when reordering rows.

When I do this, after a few hours, the rows will return to their original order. I have contacted support and they tell me that if a bidirectional workflow is setup, reordering rows is not supported.

I really need data to be synced bidirectionally as I have some automated rules in jira that keep track of start and end dates and I also sometimes manually change start and end dates in smartsheet.

Does anyone have a workaround for this?

I appreciate any input!

Find more posts tagged with

Integrations

Support

Gantt View

Project Management

Comments

Nathan Lloyd

Hello,

As you heard from Support this would be considered expected at this time. It's recommended to use Row Grouping to have rows sorted automatically with automated workflows.

Another solution would be to manually sort your sheet as desired, then in a new column assign a number value representing the order rows should be in. When the sheet is resorted by the connector, you can sort by the row ordering column to get the desired manually sorting. It's worth noting that this won't help with manual hierachy however.

Please do feel free to submit an enhancement request for manual sorting capabilities with automated workflows here.

Hope that other option helps for now.

Kind regards,

Nathan L.

mavalos

Thank you Nathan, this is very helpful!

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…