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-Stearn
Portfolio Operations Tools Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives