IS AND OR
=IF(AND((([Asset Type]113 = "Success Story"), OR([Asset Type]113 = "Video - Client")), Ancestor113 = "2"), "1")
Trying to populate "1" where Asset type = Success Story OR Video - Client AND Ancestor = 2
THis throws an UNPARSABLE error. I think it may be related to my parenthesis
Best Answer
-
The OR is in the wrong spot.
Try this...
=IF(AND(OR([Asset Type]113 = "Success Story", [Asset Type]113 = "Video - Client"), Ancestor113 = "2"), "1")
If you are planning on using that 1 as a numerical value though, you will also want to remove the quotes from around it. The quotes turn it into text.
Answers
-
Best Regards
Amit Wadhwani, Smartsheet Community Champion
Smartsheet CoE, Ignatiuz Software, Exton, PA
https://www.linkedin.com/in/amitinddr/
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"
-
Hi Stavros,
You are right, it's your parenthesis, I have corrected it:
=IF(AND([Asset Type]113 = "Success Story", OR([Asset Type]113 = "Video - Client", Ancestor113 = "2")), "1")
-
Thanks Jayesh... I really need to work on my use of parenthesis
-
Hmm.. Actually it is getting Success Story but not picking up Video - Client
-
The OR is in the wrong spot.
Try this...
=IF(AND(OR([Asset Type]113 = "Success Story", [Asset Type]113 = "Video - Client"), Ancestor113 = "2"), "1")
If you are planning on using that 1 as a numerical value though, you will also want to remove the quotes from around it. The quotes turn it into text.
-
Thanks all for your help...
-
Happy to help! 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!