-
Formula that returns the title of any Issue Links in a Smartsheet linked to Jira project
Hello! I have a sheet that is linked to a Jira project, and for Bug tickets, I'd like to see the titles of the blocked issues. Typically, I would use an INDEX/MATCH formula, but I'm not sure of the best way to isolate the issue key(s) from the Issue Links field so I can use it as the lookup value. In some cases, a Bug…
-
Change the JIRA account an individual Smartsheet user is connected to
We were in the process of setting up a generic user to create JIRA connector workflows and did not have a user created in JIRA that matched. One of our users mistakenly connected the generic Smartsheet account to his own JIRA account and now we only see his JIRA projects. We've been told the only way to reset this is to…
-
Jira Connector Workflow is not bringing over Jira System populated fields or Jira Formula fields
Hi! I have two fields that are not coming over in my sheet from Jira. One is a field that is generated by the system when it looks at the status of related tickets that are not directly in the project that I'm linking in the workflow The second is a column that is a formula in Jira that calculates a weighted score based on…
-
Extract a Text String to Remove Unwanted Text from Jira Connector Ticket "Summary"
Situation: I have a SmartSheet utilized for Epic tracking of project deliveries. I use Grid and Gantt Views. These sheets are typically 50+ rows long with linked tickets under Jira Epics. Background: My Jira Ticket Summaries (ticket titles) are consistent and long for SOP purposes. Ex: "ABC-DEF | Client | Q3 August 2024 |…
-
Jira Connector should use "Filtered out by Connector" when Initiatives no longer match JQL query
When a Jira Connector is set up to sync Jira Initiatives bidirectionally to a SS Project, the set of rows which are synced is generated when the Connector is created or restarted. If an Initiative is updated such that it no longer matches the Connector's JQL filter, I would have expected the Connector to place the…
-
Move Initiatives to "Filtered out by Connector" when they are no longer returned by JQL filter
Currently, the JQL filter will populated a SS project with all of the Jira Initiatives which are returned by the filter - this is done when the Connector is created or reset. If an Initiative is modified such that it no longer matches the JQL filter, we would like it to be moved to the "Filtered out by Connector" group…
-
JIra-Smartsheet Connector
Hello All Just trying to figure out it if it is possible to create a Smart sheet workflow from Jira Cloud to smart sheet and within the workflow only connect it to a single ticket or Epic. We do not want it to pull the data in from the entire project. It is a Jira Work Management. Trying to figure out if there is an option…
-
Parent Field Added to Smartsheet Jira Connector
Hi Community, To support the new Parent field within Jira, we have added the Parent field for Jira Cloud and on-prem workflows. For Jira on-prem workflows, you can now select the Parent field (bi-directional) in addition to the Epic Link (bi-directional) and Parent Link (uni-directional) fields within the Jira Connector.…
-
Smartsheet-Jira Integration not synching assignee & date field
We have a few workflows where 11 fields are setup to synch between Smartsheet & Jira. The fields synching correctly include: Issue Key, Summary, Type, Status, Priority, Label, Start & Stop dates. However, the "Assigned to" (contacts, unrestricted) and a "Trend Start Date" & "Due Date" (both are date field, unrestricted)…
-
SmartSheet Jira Connector
Hi Team, We are trying to integrate SmartSheet into Jira, however when looking at "Jira Connector by Smartsheet" I see the following: https://marketplace.atlassian.com/apps/1215530/jira-connector-by-smartsheet/version-history We are running Jira Cloud. "version":"1001.0.0-SNAPSHOT", "versionNumbers":[1001,0,0],…
