Jira Smartsheet integration - tickets that have moved between projects
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?
Answers
-
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