Initial Values_MV

[Muzekker_Vatan]

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

[Marc_Dillon]

help.appsheet.com

AND()

Are all true?

[Muzekker_Vatan]

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

[Rifad]

Muzekker_Vatan:

IFS(
AND(

CONTAINS(
[COMMODITY TYPE],
{“CONSOL”}
),

CONTAINS(
[COMMODITY TYPE],
{“DANGEROUS GOODS”}
)
),“DGR”
)

Try this