Dear Friends,
The formula checking only DANGEROUS GOODS word. What formula could be if I want to check the “DANGEROUS GOODS” and “CONSOL” words together?
IFS(
CONTAINS(
[COMMODITY TYPE],
{“DANGEROUS GOODS”}
),“DGR”
)
Do not know. That’s why i am asking.
Try this
User | Count |
---|---|
43 | |
30 | |
25 | |
23 | |
13 |