Contains an Exact Match

Paul H
Paul H Community Champion
edited 03/04/22 in Formulas and Functions

Problem is double results using the contains function

=JOIN(COLLECT({ECN Num}, {ECN Item}, CONTAINS(Item@row, @cell)), " ")

{ECN Item} cell is a list of affected items numbers

If the ECN Item I am looking for is "1234" I also get the results for item number "1234-05"

Any advice?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!