Skip to main content
Solved

Formula needed to pull out most recent status of a logged multiple choice field

  • May 15, 2025
  • 0 replies
  • 285 views
Forum|alt.badge.img+5

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 logged status with the dashes: --------------Needs Review

The current field contains

-- [MAY-13-25 Molly Smith] --------------
Closed

-- [MAY-12-25 Molly Smith] --------------
Action In Progress

-- [MAY-12-25 Molly Smith] --------------
In Review

-- [MAY-12-25 Molly Smith] --------------
Needs Review

The end result of the formula should just be Closed. What do I need to adjust in my formula?

Best answer by MarkShnierYou

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)

 

 

Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • May 15, 2025

Dawn,

I like to do these in stages so I can follow my logic

var text ParseOne = Right([PICC Request Status],"]");
var text ParseTwo = Right($ParseOne, "-");
$ParseTwo

Give this a try.

Terms & ConditionsAccessibility statement