Solved
Formula needed to pull out most recent status of a logged multiple choice field
I have a multiple choice field, PICC Request Status, that is also a logged field. Most recent choices are at the top and on their own line. Trim(Right([PICC Request Status],"]")) pulls out the first...
Tag teaming with my buddy Don,
You are doing two things that are unusual, the prepending newest at the top and using the entries on a separate line causing those dashes.
Try this ridiculous looking formula
NotLeft(SearchAndReplace(Left(NotLeft([PICC Request Status],"]"),"["),"-",""),2)
