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
Jun 27, 2021 10:32 AM
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)
Jun 28, 2021 07:33 AM
Hi Matt. Give this a try…
IF(FIND(‘Spider’,{Item Name}),30,IF(FIND(‘Raw’,{Item Name}),3,7))
Good luck.