Is there a formula that will display latest status [status5] is not blank=[status5]. If [status5] is blank=[status4], if [status4] is blank =[status3] and so on?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Crystal

Crystal

  • 0 Points

Posted 3 years ago

  • 0
  • 1
try this

IF(

Trim([Status5]) <> "", [Status5],

Trim([Status4]) <> "", [Status4],

Trim([Status3]) <> "", [Status3],

Trim([Status2]) <> "", [Status2], [Status1])



Those are empty quote used in the test ie a " followed by another " and nothing in the middle of the quotes.
Photo of Crystal

Crystal

  • 0 Points
Thank you that does work!
:)