Forum Discussion
katieo8081
Aug 12, 2021Copper Contributor
Multiple IF Statement
I'm trying to use multiple IF(SEARCH) functions to find text within a specific column to return other specific text. I have attached a sample. I would like to write an IF statement that searches f...
Yea_So
Aug 12, 2021Bronze Contributor
if you did a query from a system you should include the sku number because the sku number might identify the color of the product and base your formula on said sku number instead of re-inventing the wheel
- katieo8081Aug 12, 2021Copper ContributorThank you for your response. Unfortunately in my actual data, the SKU numbers are random in relation to the item description.
- Yea_SoAug 12, 2021Bronze Contributor
https://www.lightspeedhq.com/blog/sku-numbers/#:~:text=A%20SKU%20number%20is%20an%20alphanumeric%20code%20that,are%20critical%20for%20managing%20inventory%20and%20maximising%20sales.