If Contains Contact Cell

I am trying to write what seems like a basic formula, but I'm not getting the expected result. I would like to reference a Contact Cell column with an If(Contains) formula. The basic formula I have written looks like this:

If(Contains("John Smith", [Received By]@row), 1, 2). The result is always returning false ("2") even when the contact of "John Smith" is present. I can create a straightforward "IF" statement, but the contains portion is not working.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!