Want to match values in multiple columns
![Joseph Aloysias](https://us.v-cdn.net/6031209/uploads/userpics/WZDEOXSJITB8/nDP4L5HRUUJSS.jpg)
I want to match the JIRA ID in the Jira ticket sheet to auto populate the Reported Issue ID1,Reported Issue ID2,Reported Issue ID3 (Issue ID in Issue Reporting sheet), there are multiple issue ID for same Jira ID
Is there a way we can auto populate Reported Issue ID's from Issue Reporting Sheet to Jira Tickets sheet?
Is there a way we can auto populate Reported Issue ID's from Issue Reporting Sheet to Jira Tickets sheet?
Answers
-
Hi Joseph I have re-created your scenario and have an answer for you, but my question is do you really want a column per Reported Issue or would it be better to just collect all Reported Issues and store them in 1 column?
Anyway to do what you asked, I did it this way (others might have an easier solution). I have added explanations into the screen shots. Let me know if this helps...
Kind regards
Debbie Sawyer - Chief Smartsheet Solutions Officer (CSSO)
-
Here is the version of the Jira Ticket sheet with the formula/column for All Reported Issue ID's (I prefer this one!) But it depends on what you want to do with the data as to which method you go for (all issue ID collated in 1 column or split across multiple columns)
I hope this helps.
Kind regards
Debbie
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!