Reference a contact in IF formula

Kirstine ✭✭✭✭✭✭

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("<>", Team@row), true, "")

=IF(CONTAINS("", Team@row), true, "")

=IF(CONTAINS("Joe Bloggs <>", Team@row), true, "")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!