Reference a contact in IF formula
I'm trying to return a value of "TRUE" in a tick box column if a contact referenced in the same row is a specific person. It's a multiple contacts column too but I've done dummy runs with only one contact and it still won't work. I've tried the following and they don't work, what am I doing wrong? 😞
=IF(CONTAINS("Joe Bloggs", Team@row), true, "")
=IF(CONTAINS("<joebloggs@outlook.com>", Team@row), true, "")
=IF(CONTAINS("joebloggs@outlook.com", Team@row), true, "")
=IF(CONTAINS("Joe Bloggs <joebloggs@outlook.com>", Team@row), true, "")
Best Answer
-
Try this:
=IF(FIND("Joe Bloggs", Team@row), 1)
Answers
-
Try this:
=IF(FIND("Joe Bloggs", Team@row), 1)
-
I found an error in original formula with multiple contacts, try this one instead:
=IF(COUNTIF(Team@row, FIND("Joe Boggs", @cell) >= 1), 1)
-
Thanks so much! x
-
The first one is working for me in cells where my contact is alone and in ones where he's not!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!