IF(Contains . . . not returning value I'm actually looking for

PeggyLang
PeggyLang ✭✭✭✭✭✭

I have the following 'IF(CONTAINS . . . formula

which is returning '#UNPARSEABLE'.

What I need is the Names of individuals where #0136 appears in a column on another worksheet.

I don't really know if this is the correct formula to be using for the action I'm wanting.


Thoughts?

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!