Sorry, I was multi tasking and did not realize that these are all date fields. Also the sequence matters, so you will need to check for the last sequence first.
IF(
not IsNull([Empty Return Date]),"Empty Returned",,
not IsNull([Port Pickup Date]),"Picked-Up",
not IsNull([ATA Destination Port]),"At Port",
not IsNull ([ETA Destination Port]),"In-Transit", "Not Shipped")
)
IF(
IsNull ([ETA Destination Port]),"In-Transit"),
IsNull ([ATA Destination Port]),"At Port"),
IsNull ([Port Pickup Date]),"Picked-Up"),
IsNull ([Empty Return Date]),"Empty Returned")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------