Extract Series of Occurrences of Strings into Separate Columns
Hi @Paul Newcome ,
You mentioned in another thread here:
"If you wanted to parse them out across individual columns, we would instead use a series of LEFT/FIND and MID/FIND statements."
The previous thread looked to me like someone was using the Jira Connector and separated linked issues by type of relationship, to sort of remove "excess" relationships. I need to do the same thing, but involving many-to-many issue links, such that my Smartsheet Issue Links column cell would look like this:
"relates to xyz-9992, relates to xyz-9991, tests xyz-0001, tests xyz-0002"
but maybe the strings come in like the above, maybe they're mixed up like ...
"tests xyz-0002, relates to xyz-9991, tests xyz-0001, relates to xyz-9992"
Some of my tickets will have one relationship. Some will have many. When there are many, I think I need to do what you mentioned of parsing each out into an individual column, based on its relationship like this:
Relates to 1 | Relates to 2 | Tests 1 | Tests 2
Do you think this would be possible? I'm not sure how to find the "first" and "second" instances of "tests" or "relates to" and so on.
Help Article Resources
Check out the Formula Handbook template!