The Jira connector is missing one piece of functionality that would make it a great product. There is no way to show comments. This is kind of a deal breaker for us.
It's this reason (among a few) that we chose not to pursue the Jira connector, instead we're using an IPaaS system to automate the creation of Jira tickets from our project plans and add comments to Jira and Smartsheet using the API.
@Dan Cliff would you be kind enough to share instructions on how to do this?
@clawson, of course.
The system I use is make.com, but any Integration Platform as a Service system should be able to achieve the same thing.
Below is the integration scenario, in this case we use a Smartsheet form to collect technical requests from clients, so using Make, I monitor the smartsheet for new records. When a new row is created, I pull the row details into my scenario (field contents) and because we request an attachment from our clients I also use the Smartsheet API to get the details for the attachment.
From there I use Make's integration into Jira to create a new Jira ticket prepopulated with the details of the Smartsheet request. We can then @mention key users in Jira and feedback the Jira ticket details back to Smartsheet; by feeding back it makes a more seamless experience for the users and minimises the manual handling of data.
Throughout this scenario there are also error handlers that send notifications to a slack channel and post comments back to the Smartsheet row so nothing should be left to chance or missed if no one notices the error.
Not shown in this flow are the integrations uses to update and close out the tickets in Smartsheet, but those work in much the same way. Use Jira to trigger a webhook, pass the details of the Jira ticket back through Make.com and update the relevant Smartsheet row.
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
It would be incredibly helpful if I could simply create a workflow to automatically send a generated document to that row's recipient without including the link to the source sheet or requesting an approval or signature.
Hello, I have found that when a column is a formula column, you can no longer manually update those cells--ever. Is there a reason these cells need to be "locked down"? When you add a formula, just to the cells manually, and not the entire column, you can always update it whenever you need to. I know I can "turn off" the…
It would be great if there was an option to have an end date for a form submission so that you do not need to go in manually and make it inactive.
©2024. All Rights Reserved Smartsheet Inc.