I know this should be relatively simple, I just can't figure out all the pipefitting.
I have a column of text strings (codes) that start with certain strings (for example, "PV", "SS", "WL") and I want a formula that returns / sets a value based on those strings.
I was hoping to use a simple...