Jira Smartsheet integration - tickets that have moved between projects

CathyYonek
CathyYonek ✭✭
edited 01/28/24 in Add Ons and Integrations

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?

Tags:

Answers

  • Monique_Odom_Comcast
    Monique_Odom_Comcast ✭✭✭✭✭✭

    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.

    If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!

    Monique Odom

    Business Process Excellence Manager

    Smartsheet Leader & Community Champion

    Pronouns: She/Her (What’s this?)

    “Take chances, make mistakes, get messy!” – Ms. Frizzle