Parse a cell with colon : delimited variables

I need to select the string associated with each of the Tag names START: END: SCOPE: Are there command/s in Smartsheet to select the data and copy to a column on the same row as the string? Below is the example of data in a single Cell.

"START: 09:40 PST, Wed 12/25/2019 END: ONGOING SCOPE: Foo site 10G circuit to FOO hubsite is down."

In this example, I need to copy

  1. 09:40 PST, Wed 12/25/2019 to a column that I named, "START"
  2. ONGOING to a column that I named, "END"
  3. Foo site 10G circuit to FOO hubsite is down. to a column named "SCOPE"

The strings can be variable sized. However, the Tag names and colons are consistent within each string.

I appreciate any assistance.

Thanks!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!