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
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!