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, Inc., Exton, PA
Did this answer help you? Show some love by marking this answer as "Insightful 💡" or "Awesome ❤️" and "Vote Up ⬆️"https://www.linkedin.com/in/amitinddr/ -
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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!