Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
formula based on an if-then statement
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.