Smartsheet Jira Connector - Update Based on Smartsheet Column?
I have a Smartsheet Jira connection setup where the issues in Jira are copied and updated into a Smartsheet based on who is working the issue (because we have issues spread across multiple projects and there are thousands of issues that our company has within Jira we use a filter to only look at those from users on a team). However, when an issue is updated to another team, there is no longer an update from Jira on the status of the ticket because we have it only pulling in those tickets from users on our team. Is there a way to create a filter to keep tickets updated by a filter on what is in a Smartsheet? So that even if the issue is reassigned we will get the status updated.
Answers
-
Hey @Sarah123
It doesn't look like other members have tried something similar (although I'd love to be proven wrong!). Were you able to figure out a solution for your scenario?
It sounds like you may want to have two different sheets: one that's connected for your personal team, then another one with the tickets you've moved over. This way you could have a different Jira workflow set up for that second sheet to keep them updated.
Let me know if that may work for your team and process!
Cheers,
Genevieve
-
I haven't found a way to get it to work yet. I thought about setting up another sheet and having the tickets copied over to that sheet but I can't seem to find a way to pull just those tickets' status from Jira. Unfortunately doing a full pull from Jira won't work as we have too many tickets for a single sheet (and the tickets are not in just one Jira project).
