Extract a Text String to Remove Unwanted Text from Jira Connector Ticket "Summary"

edited 07/09/24 in Add Ons and Integrations

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 | Provide Data + Detail Files to Client"

Problem: I need this entire section of every ticket to be removed to focus on the task level.

For example, I only want to see "Provide Data + Detail Files to Client" on my sheet.

Request: What can I utilize to perform this action?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Is it consistent in that you want the rest of the string that comes after the third | every time, or is the number of | variable, or is there a possibility you want to also exclude some text after the indicated portion?

    If it is consistently everything after the 3rd | every time, you can use this:

    =RIGHT([Column name]@row, LEN([Column Name]@row) - (FIND("~", SUBSTITUTE([Column Name]@row, "|", "~", 3)) + 1))