Initial Values_MV

AppSheet AppSheet Q&A
1

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”
)

1 Like
2

Do not know. That’s why i am asking.

3

Muzekker_Vatan:

IFS(> AND(> > CONTAINS(> [COMMODITY TYPE],> {“CONSOL”}> ),> > CONTAINS(> [COMMODITY TYPE],> {“DANGEROUS GOODS”}> )> ),“DGR”> )

Try this