Split text to multiple columns
Hello! My team is using the JIRA connector to pull ticket info from JIRA to Smartsheet. In the JIRA description field, the team has a template that contains several key pieces of information that I would like to separate into multiple columns. Basically, I would like the ability to pull everything to the right of the : for each of the lines into it's own new column. I know there is the RIGHT function, but how would I have it stop collecting at the end of the line when the number of characters is different each time?
Help Article Resources
Check out the Formula Handbook template!