Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

If / And / Find Formula Help

Topic Labels: Formulas
280 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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 “Spider” in {Item Name} result = 7

I tried the formula below, using all the colors in the descriptions to try to isolate the result, but it sums up the results. ie. “730”.

IF(FIND(“Raw”, {Item Name}), 3) & IF(FIND(“Black”, {Item Name}), 7) & IF(FIND(“White”, {Item Name}), 7) & IF(FIND(“Clear”, {Item Name}), 7) & IF(FIND(“Turquoise”, {Item Name}), 7) & IF(FIND(“Spider”, {Item Name}), 30)

1 Reply 1

Hi Matt. Give this a try…

IF(FIND(‘Spider’,{Item Name}),30,IF(FIND(‘Raw’,{Item Name}),3,7))

Good luck.