I am using IF, AND, CONTAINS - Result coming wrong
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!
Answers
-
Hey @Jaimin,
What is the formula returning? Is it returning True? Or are you getting an error?
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
-
SO out of 4 condition 1st condition match but not other three!
-
Hey @Jaimin,
Hmmmmm strange. Could you share a screenshot of the ranges you're checking? Please remember to hide any sensitive data
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
Hey @bisaacs,
Sorry, I am afraid the data is sensitive. I can't share - you think anything wrong with formula?
-
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
-
Hey @Jaimin,
What are the column types you're using? Also, maybe try changing the CONTAINS to HAS?
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
Hey @bisaacs,
Heres the column type:-
Text/Number
Dropdown List
Text/Number
Text/Number
will try now has :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!