Jira Smartsheet integration - tickets that have moved between projects

CathyYonek

I have built a one way Jira --> Smartsheet integration. When we have a ticket that has moved between Projects, I end up with two rows. The original ticket (E.g. AB-1023) and the new ticket number with the project it was moved to (XY-4567). I do not expect the integration to delete the original row but is there any field to use to determine that the original ticket was moved to a new ticket number so I can exclude it from reports and dashboards?

Monique Odom-Stearn

Hello @CathyYonek,

I would suggest creating a buddy column with a formula that helps to identify when a project has been moved to a new ticket number. That way, you could then use that buddy column in a report filter to exclude those old ticket numbers.