I am using IF, AND, CONTAINS - Result coming wrong

Jaimin

here the formula - the answer should False

IF(AND(

CONTAINS([ASSET NAME]@row, {A 2024 Range 3}),

CONTAINS("INTERNATIONAL", {A 2024 Range 5}),

CONTAINS([NAME HELPER]@row, {A 2024 Range 2}),

CONTAINS("Completed", {A 2024 Range 4})

), "TRUE", "FALSE")

Any advice please :) Thanks!

bisaacs

Hey @Jaimin,

What is the formula returning? Is it returning True? Or are you getting an error?

Jaimin

Hey @bisaacs,

returning True!

Thanks,

Jaimin

Jaimin

SO out of 4 condition 1st condition match but not other three!

bisaacs

Hey @Jaimin,

Hmmmmm strange. Could you share a screenshot of the ranges you're checking? Please remember to hide any sensitive data

Jaimin

Hey @bisaacs,

Sorry, I am afraid the data is sensitive. I can't share - you think anything wrong with formula?

Jaimin

Hey @bisaacs,

FYI

I found out something the 2nd condition we are looking is drop down list so its looking all the value use in that whole column. I put outside data which is not used in that column then I got false. which is interesting now the problem is how to make more specific that number 2 condition???

CONTAINS("INTERNATIONAL", {A 2024 Range 5}),

Thanks,

Jaimin

bisaacs

Hey @Jaimin,

What are the column types you're using? Also, maybe try changing the CONTAINS to HAS?

Jaimin

Hey @bisaacs,

Heres the column type:-

Text/Number

Dropdown List

Text/Number

Text/Number

will try now has :)