Using IF > Cell Reference > OR
Hey folks,
Basically I'm trying to put a cell reference in between two logical statements. In this case, if either "Person A" or "Person B" are in the cell, return "Team A". Here's my formula:
=IF([Assignee Contact]@row = (OR("Person A", "Person B")), "Team A", "N/A")
I can't find anyone indicating that this is even possible. Right now I'm getting #INVALID OPERATION. For now, I put the OR right after the IF and just referenced the cell in each OR argument, but I have a lot of "persons" and I'm just trying to make the formula as efficient as possible.
Any help is appreciated! Thank you!
Answers

Try:
IF(OR([Assignee contact]@rrow="Person A", [assignee contact]@row="person B"),"Team A", "N/A")
If Assignee Contact is a Contact Column then "Person A" needs to be the value of the contact. An easy way to see the value of a contact is to insert a temp Text column that = [Assignee Contact]@row.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Thanks Mark, that's what I ended up doing for the time being. I was hoping that my method above would work out since it was just a cleaner / more efficient approach. I have 3 teams & close to 15 people, so I assumed it would be easier for Smartsheet to reference the cell 3 times instead of 15 times. I also like the way its managed because its easier for someone who isn't as proficient with formulas to add / remove / correct people in there without having to call me up and ask me to fix it 😀
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!