Hello! I'm needing help wording a formula for a field.
I want a field called Status to show "Shipped" if the order ship date field is not empty, show "Transfer" is the internal transfer date field is not empty and show nothing if both date fields are blank.
So i have 3 fields to think about on this formula (Status, Ship Date and Internal Transfer Date).
Any help would be amazing!