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

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.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!