-
How to search cell string for text keyword presence
I'm using Jira Connector, and the Jira Label field in the source Jira project can contain multiple values, which get populated in Smartsheet Label column as comma separated strings for each Jira issue row. I am looking for guidance on how to write a formula to search the cell string for a specific keyword, to take…
-
Create chatgpt and other LLMs integration connector
Companies are adopting LLMs, either popular options, or their own versions built in house. It would be a useful feature to create API/Connectors similar to Jira Connector, allowing users to connect their Smarsheet account to their preferred LLM (either a popular choice or an in-house option) inside smartsheet. A company…
-
Jira Connector Error - Illegal Character
Hello, We are working on a bi-directional sync via Jira Connector and continue to receive this error when we try to push new tickets into Jira from our Smartsheet (which is successfully receiving Jira updates and updating existing tickets) - JIRA rest client exception occurred while syncing issue.…
-
Is it possible to copy a workflow in the jira+smartsheet connector?
Hi all, Have completed all testing of forumulas in a project we kicked off. Now I want to make that workflow bi-directional between Jira and Smartsheet. I've read you cannot change the workflow, but is there a way to copy a workflow? Thanks in advance.
-
If name in this column, put contact in another cell but not the cell with the formula
I'm using the Jira Connector and having a heck of a time getting contacts to sync. I've been through a laundry of ways so now I want to try this. I'm able to bring in the Assignee Display name with no issue in a text column only. Jira connector will fail if a column has a formula (so frustrating, let me tell you!), so I am…
-
Smartsheet Jira Connector Support for Atlassian Webhook Limitation Changes
Hi Community, To support the July 2024 Atlassian change to limit each Jira Cloud environment to 100 webhooks, we have introduced a new “Migrate All” workflows button to migrate Jira Connector workflows to the shared webhook model we introduced in November 2023. With this model, your Jira Connector workflows will all…
-
Smartsheet - Jira Connector Custom Fields
Hi Smartsheet Community, We are trying to integrate Jira with Smartsheet via Jira Connector and found that only system fields are available for selection and none of the custom fields show up in Smartsheet for bidirectional integration. Our bidirectional integration is successful for Jira System Fields but not unable to…
-
JIRA connector error
Hello community, Recently created a bi-directional sync and have experienced some very random errors. This is JIRA coming into Smartsheet and we have it set up to only bring in a JIRA number nothing else. Permissions are set correctly. Has anyone experienced this? "Smartsheet REST exception occurred. Error code: 5536.…
-
Invalid response from JIRA. statusCode: 400 - Original Estimate issue resolved
For anyone who is interested, I was encountering the following error when trying to sync a Duration field from Smartsheet to the Original Estimate field in Jira via the Connector. Invalid response from JIRA. statusCode: 400, reasonPhrase: Bad Request Field 'timetracking' cannot be set. It is not on the appropriate screen,…
-
Help Article updates
Hello Community, We’ve created new content to highlight specific capabilities: Jira Connector Learning Track Salesforce Connector Learning Track Integrations and Add-Ons Learning Track We’ve published the following new articles: Admin Center: Manage authentication options Admin Center: Apply security settings to forms…
