Jagadeeshbs
Member
Hi need a formula to check the item status.
Item
Item status
G157970103
generic
4501969498
Normal
Missing
Missing
4501949034
Normal
If the item is blank then missing if starts with G then generic and anything else then normal
Item
Item status
G157970103
generic
4501969498
Normal
Missing
Missing
4501949034
Normal
If the item is blank then missing if starts with G then generic and anything else then normal