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
Business Process Excellence 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
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
