Help with extracting values from one cell to the other

Keya Sult
Keya Sult ✭✭
edited 07/25/23 in Smartsheet Basics

Hello, I am trying to extract a value from one cell to another cell. E.g. I have a column that goes by a specific sequence:" ["A"]_["B"]_["C"]_[ID No.]". I am trying to extract the [ID] portion (the string after the 3rd '_'). How may I be able to do this?

Best Answer