Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
2 days ago
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...
formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    2 days ago

    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)

     

     

DawnRene3's avatar
DawnRene3
Qrew Trainee
2 days ago

Don, that was close. But it pulled out the oldest status, not the most recent status, with a space before it. 

 

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 days ago

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)

 

 

  • DonLarson's avatar
    DonLarson
    Qrew Elite
    2 days ago

    Dawn,

    Do it Mark's way and you will get the first entry from the bottom.

  • DawnRene3's avatar
    DawnRene3
    Qrew Trainee
    14 hours ago

    Mark, as crazy as that looks it worked like a charm! Thank you! It pulled the most recent Status only with no dashes or spaces.