Need a formula that will not give errors? Multiple "ifs" and a "contain" or "has"

Here is basically the question: IF the sales Order matches and the STR ID# contains or has , and it is marked shipped.

Sheet where formula needs to be and the lookups:

Cross reference sheet:


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!