I need to generate a lead time result based on the contents of a product description {Item Name}. Any help here would be much appreciated. If find “Spider” in {Item Name} result = 30 If find “Raw” in {Item Name} result = 3 If do NOT find “Raw” or “...

I’m looking for some help on formulas and building automation sequences. Must be good with IF / Find / And / OR formulas for some immediate needs.