How to extract the Row # digits from the Predecessor column


Here are some samples of what I have...

19FS -2d (I want to extract "19")

17SS (I want to extract "17")

762SS, 22FF (I want to extract "76" to one cell and "22" to another cell)

Any ideas?



  • Neil Watson
    Neil Watson ✭✭✭✭✭✭
    edited 08/28/22
  • Neil Watson
    Neil Watson ✭✭✭✭✭✭

    I am sure there are more elegant ways, this is how I do it:

    =VALUE(IF(CONTAINS("FS", [Primary Column]@row), MID([Primary Column]@row, 1, FIND("FS", [Primary Column]@row) - 1)))

    =VALUE(IF(CONTAINS("SS", [Primary Column]@row), MID([Primary Column]@row, 1, FIND("SS", [Primary Column]@row) - 1)))

    =VALUE(SUBSTITUTE(IF(CONTAINS("FF", [Primary Column]@row), MID([Primary Column]@row, FIND(", ", [Primary Column]@row) + 2, 100)), "FF", ""))

  • Berto D
    Berto D ✭✭

    Thank you so much for this. There may be a way to combine all three structures and produce the results in one cell with the JOIN function in a column that is formatted as a Dropdown with multiple values per cell.

    I'll give it a try and see if I can figure it out.

    Will let you know how it goes.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!