I'm trying to create a formula in a saved search. We have 2 different shipping methods Marine Freight LLC {Trailers} indicated with YELLOW highlight and Customer Pick Up {Trailers} indicated with RED highlight. If the ship via is Marine Freight LLC {Trailers} I would like the formula to pull the "Ship Date"(custbody15) in this field. If the ship via is Customer Pick Up {Trailers} I would like the formula to pull the "Scheduled Pick Up Date"(custbody73). I would like to use 2 separate lines therefore 2 formulas so it doesn't have to be combined into 1 formula.
Formula 1: If the ship via is Marine Freight LLC {Trailers} I would like the formula to pull the "Ship Date"(custbody15) in this field.
Formula 2: If the ship via is Customer Pick Up {Trailers} I would like the formula to pull the "Scheduled Pick Up Date"(custbody73).
